Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Task DB Design (2k3)

    Hi, I'm going to start making a new database sometime in the next week or so, and I was just hoping to get some input on the design/layout of it.

    Its going to be a database to help me multitask at work (and/or at home) because theres so much stuff that needs to be done on a regular basis. There would be 2 or 3 main categories i suppose, being Work, Pleasure, and Bills (or a more general category name for bills & paperwork if you can think of one). The work category would break down to 2 or 3 categories as well, like design, administrative, record keeping, etc (some would be regular daily or weekly tasks). The Pleasure category would be almost like a calendar i suppose - with different plans/events, things to do. Bills & paperwork would break down to... bills, and paperwork.

    So all of the items in their respective categories would have some level of importance, probably a 1 to 5 scale that i guess i would use a combo box to select, and then as the date got nearer, the color would change in the box to denote that it was becoming more and more important. Also if they were repetitive, a radio box or checkbox to denote that.

    I would want to use a mini form for each category with a combo box of the particular possible sub categories, and then a date formatted text box for the due date to be entered, and even an extra "ideal" due date would be useful to have. Then I think i would use a memo field or maybe just a regular text box to give a description of it. I would like to even make a button to give me a report break down of how many items are over due, incomplete, or whatever their status may be.

    Any ideas of what else might be useful? or what i should include in the forms? Also, I'm not quite sure how to do the table layout for this sort of thing, so suggestions for that would also be appreciated.

    if this post sounds jumbled, sorry, its just a basic idea of something i'd like to try to do so there just isn't much to it yet. be creative! <img src=/S/artist.gif border=0 alt=artist width=34 height=29>
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Task DB Design (2k3)

    Wouldn't Outlook, with its calendar and tasks be more appropriate for this problem? You can assign Outlook items to categories, create reminders, etc.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Task DB Design (2k3)

    i actually looked at it as i wrote that post, but w/ a database i could split it and use it from work/home which i think would be cool... i dont' use outlook at home, and i don't think i would want to put all of my personal stuff in the outlook calendar @ work... know what i mean?

    also, i need to keep in practice w/ access and can't think of anything else to make!
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  4. #4
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Task DB Design (2k3)

    Being creative....stop trying to schedule your pleasure <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Maybe you can have a form with three listboxes, one for each type of task...after you select a task a form pops up with the task details, etc... You can populate the form with filters (maybe you don't want to see tasks that are due 3 months from now) or sort them by rank, or due date...

    If you wanted to change the colors of the rows in your listbox, you may want to check out <post#=301,400>post 301,400</post: >.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  5. #5
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Task DB Design (2k3)

    To give you more to do (and perhaps some things to learn) try adding some of these features to your listboxes/forms

    -Filter the listboxes by year/month after listbox/text box entry (to search for tasks next month, next year, etc)
    -Notify yourself of any past due tasks on startup
    -Count the number of tasks completed/outstanding this (day, week,month, year), display in a text box on your form
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  6. #6
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Task DB Design (2k3)

    yeah i was definitely planning on some conditional formatting, i've done some of that in the past. the filter suggestion is a good idea as well. i'm gonna take a stab at the DB soon and see what works, i want it to look pretty too of course <img src=/S/nerd.gif border=0 alt=nerd width=20 height=21>

    as for scheduling pleasures... sometimes i feel like im so busy if i DON'T schedule something, i'll never do anything!
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  7. #7
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Task DB Design (2k3)

    <hr>as for scheduling pleasures... sometimes i feel like im so busy if i DON'T schedule something, i'll never do anything!<hr>
    <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15> maybe this task scheduling database will free up some time <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Task DB Design (2k3)

    <hr> ... i want it to look pretty too of course<hr>
    You have some major challenges in form design when you try to do scheduling - unless you want to get into using ActiveX controls. One of the most difficult things is to recognize scheduling conflicts - the people who market applications like this have typically spent hundreds of staff years developing such capabilities. If you want to brush up your Access skills, I'd suggest you find a different project, such as organizing your music collection or tacking your tennis ladder, or any of the other personal things that people do, and for your task organization, try using one of the Web apps that can sync with a PDA. We prefer Outlook, and the Web version it offers, and I am able to send tasks to my home Outlook via email, but I understand not wanting all of your personal details exposed at work.
    Wendell

  9. #9
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Task DB Design (2k3)

    Who said anything about scheduling conflicts?? Its a db for multitasking <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

    for the record, i can't possibly follow advice that says "don't try this"... <img src=/S/heavy.gif border=0 alt=heavy width=40 height=34> thanks for the other suggestions though, maybe i could include something for music
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  10. #10
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Task DB Design (2k3)

    <hr>i want it to look pretty too of course<hr>

    uh-oh...all too often quotes like that are synonymous with <img src=/S/megashout.gif border=0 alt=megashout width=33 height=17>[b]<big>BAD FORM DESIGN AND EXCESSIVE USE OF CLASHING COLORS</big>[b], but you wouldn't do that, now would you John
    <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  11. #11
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Task DB Design (2k3)

    don't worry about me.. i've got some style <img src=/S/bubbles.gif border=0 alt=bubbles width=31 height=17>
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •