New to Access. Need some help creating a database

[cumberlandfarm]

Hello everyone!

I heard from a number of people that this is the place to come for Microsoft Access related help.

So here is my question and I hope someone can help me understand access a little bit better.

I am trying to create a database for a job I am doing. THere are 700+ convenience stores that we (4 inspectors) inspect every three months.

We have been told to do an ADA compliance survey when we visit these stores.

The ADA checklist that we have is about 78 questions and my manager wants me to create an ADA database for this information.

So I am in need of help on how to create a database that allows me to input the answers of this ADA checklist for each store inspected.

I then would like to be able to pull all that information into a report that I could say of the 700+ stores, 50% passed all questions, 25% passed only questions 1-??, etc. etc.

I can upload the two files: The ADA checklist and our Store list if anyone would like to help me out!

Thanks Much!

 

[KeithG]

I would suggest picking up a copy of the Access bible and start reading it.

 

[cumberlandfarm]

Yeah I have some access books but my boss wants an example by the end of the week. Yet he is forgetting I have never worked with Access before!

 

[KeithG]

Can't you tell him that is not enough time?

 

[cumberlandfarm]

Can't you tell him that is not enough time?

I tried he said it doesn't have to be the greatest right now.

I have been trying to just create a form where I can fill in the answers for each survey but I am not having any luck creating one.

I have created a table with the ADA checklist but I am not understanding when I go to make a form that I am trying to input the Store #, Inspection Date, 78 Questions, Answers, and Measurements. I try to make the form but how do I get all 78 questions to appear on one form? In the form view each question makes me fill in the store number etc. Is their a way to put all questions on one form or do I need to go back to the table and correct that?

Honestly I am lost but he isn't having anything about extending the time frame sine may is a new quarter here and new inspections start and he wants something done to allow data to be entered into a database!

 

[KeithG]

I would suggest contracting some one to build the database for you.

 

[cumberlandfarm]

I would suggest contracting some one to build the database for you.

How much would that cost?

 

[Joe8915]

I am bored, send me some info and let me see what I can do

 

[cumberlandfarm]

I am bored, send me some info and let me see what I can do

You have PM!

Thanks!

 

[Joe8915]

Use my email address and I will see if I can get you started