T
traveler72
Im stumped on this access project. I need to get this project started for
school. I need some guidance on where to begin and what to do for each step.
Can anyone give me some guidance. The following description of the
project is as follows:
You are an event planner for Special Events Plus. You are frequently asked
by your clients to provide a listing of restaurants in the area that might be
of interest to event participants. Until now, you have kept this information
in an Excel workbook, but you decide that you want to move the data to an
Access database. Currently, you track the type of restaurant (fast food,
ethnic, vegetarian, Italian, etc.), street address, telephone number, opening
and closing times for each day, approximate cost per guest for meals, and
approximate distance from your office. You would like to add a way to track
any special or unique features a restaurant may have.
Design and create an Access database to meet these needs. Create the
necessary tables with the necessary fields. Establish the appropriate
relationships between the tables. Enter at least five sample records in each
table. Prepare a sample report you could provide from your database to a
client.
Determine at least five questions clients might ask that you could answer
with your restaurant database. Design, build, and save five queries that
could answer your questions. At least two of the queries must involve more
than one table.
Design, build, and save at least two additional reports that might be of
value to your clients and to you.
-Thanks for the help
school. I need some guidance on where to begin and what to do for each step.
Can anyone give me some guidance. The following description of the
project is as follows:
You are an event planner for Special Events Plus. You are frequently asked
by your clients to provide a listing of restaurants in the area that might be
of interest to event participants. Until now, you have kept this information
in an Excel workbook, but you decide that you want to move the data to an
Access database. Currently, you track the type of restaurant (fast food,
ethnic, vegetarian, Italian, etc.), street address, telephone number, opening
and closing times for each day, approximate cost per guest for meals, and
approximate distance from your office. You would like to add a way to track
any special or unique features a restaurant may have.
Design and create an Access database to meet these needs. Create the
necessary tables with the necessary fields. Establish the appropriate
relationships between the tables. Enter at least five sample records in each
table. Prepare a sample report you could provide from your database to a
client.
Determine at least five questions clients might ask that you could answer
with your restaurant database. Design, build, and save five queries that
could answer your questions. At least two of the queries must involve more
than one table.
Design, build, and save at least two additional reports that might be of
value to your clients and to you.
-Thanks for the help