Excel Check List to Access

[alonsocolin]

Hello,

I hope everyone is having a good day. I need some of your kind assistance on moving from an Excel check list to Access. I have been trying to do this on my own for the past few weeks but I haven't been successful -I'm already going bananas. Any suggestions will be greatly appreciated.

The structure of my list is as follows and the Excel template is attached:

This is to keep track of items within categories which are entered by several users (operators) and a summary (at the top of the Excel list).

Summary:

Pass
Near Miss
Fail (if any of the items in the categories is fail the entire game is fail)



Game name
notes
operator (name selected in the welcome form and should not be able to change in the summary)
date
Incident (simple text box would do)

PreEvent (category 1)
Check Item One
Check Item two
.
.
Check item...
Notes

During Event (category 2)
Check Item One
Check Item two
.
.
Check item...
Notes


End of Event (category 3)
Check Item One
Check Item two
.
.
Check item...
Notes



I use the check list every time there is a new game and each game has a unique name. I'm thinking this would allow me to pull reports in Access if I need to know about a specific game and/or if I need to see if there is a pattern on specific check list item for all games, as well as the operator who entered them.

On my effort, I tried using a welcome form where users can select their name, and whether they want to open an existing game or create a new game. When creating the new game, the fields for new game will be revealed. The user would type in the game details and hit the created botton. Then the user will be taken to the form that has Four tabs (see image below). The user can populate notes only. The pass, near miss, or fail field are automatically populated based on the list; pass/fail would populate based on check list items if one item is fail the entire game is fail, the near miss is not dependent of pass,fail and will always be check if one item is checked in the list. The other tabs would be for the categories. I used tabs because it seems easier for the user to move from category (or stage of the game) to the other and not cause confusion of too long lists.


Each tab would have the check items. Each item has Pass, Fail, CaughtB4 (if this is checked then the near miss in the summary is populated), and time. It would be nice to have the time capture automatically when the pass fail, baughtB4 is selected-only one option will be selected.









I know this is a bit too much but I am having so much trouble putting all together in Access, any help would be greatly appreciated.


Regards,

Lonso

[June7]

What is the exact issue - how to capture time data?

[alonsocolin]

Sorry, the entire thing is the issue. I am having difficulties putting the tables together, creating the forms and well, it's a mess. I am new at this and really need help.

[June7]

Well, may be too much to cover in a thread. Need a specific issue to respond to.

What have you done to become educated on relational database concepts, Access functionality, programming concepts, VBA language/syntax? Have you studied tutorials (on-line or book), taken classes, have a mentor?

Here is an often recommended tutorial site http://www.rogersaccesslibrary.com/

General advice:

1. when learning relational database, forget everything you know about spreadsheets

2. study tutorials

3. when you have basic understanding, apply to your situation - identify data entities and relationships - build diagram

4. build db

5. post your attempts for analysis