In this assignment, you will design a relational database for a business that sells
high-quality frozen meals over the Internet.
After your database design is completed, you will create database tables and populate
them with data. Then you will produce one form, three queries and one report.
Note that the screenshot images in the instructions may appear somewhat different than
what you see in your database, depending upon what database version you are using.
Nonetheless, the same functions/actions will be available. A little research should provide
you the information you need.
If Microsoft Access is not installed on your computer, then you can use the software in the
Cook library computer lab/CBE Computer Lab. Title your database according to the rules
used for the course
Your dad’s friends, Fred and David plan to sell quality, gourmet frozen meals over the
Internet. He hires you for the summer based on your proficiency in database design and
Access to help create this exciting business.
Fred envisions the business to include the following tables: Customers, meals, orders,
shipping costs, and transactions.
The next slide would show you the steps to create tables in Access
Microsoft Access Exercise
NOTE: screenshots may appear slightly different depending upon MS Access version you are using (These
steps also apply to MS Access 2013)
Open Microsoft Access to create database, then
0 comments