troubleshooting Question

Creating Tables in Access

Avatar of terrafirma
terrafirma asked on
Microsoft Access
8 Comments1 Solution501 ViewsLast Modified:
I am trying yo create a database using access.
I am struggling to get the tables right as i dont really understand the theory behind this all that well so I hope someone can point me in the right direction

The database is a evaluation system

A job is logged in a seperate database and we perform a evaluation of the job logged by checking about 30 cirteria. When evaluating the job handling it is a simple (Yes, No, NA) system. Each criteria will have one answer per cirteria per job number.

I have created the following tables

Staff Details ( Table Name)

Username (Primary Key)
Second Name
Start Date

Job Details (Table Name)

Job Number (Primary Key)
Date Raised
Date Evaluated

The bit i am unsure how to create is the criteria table, each criteria to me has a one to one relationship, so each criteria has one job number and one answer for each person Y,N, NA.

Example criteria are.

Used Correct opening
Established name of site
Established name of caller
Established Physical location
Established Phone Number
etc etc etc

Anyway hope I have made sense and someone can clear this up for me thanks

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros