CIS 110 Access 1 Assignment

Creating and Using a Database

Key Concepts
Databases and database management systems Features of the Access desktop Create a database Create a table and add records Close a table Open a database	Close a database and quit Access Print the contents of a table Create and use a simple query Create and use a simple form Create and print a custom form Design a database to eliminate redundancy

What to do

1. Complete SAM training and test for Access 1

2. Pages AC 1 to 52 - Ashton James College; this assignment is not graded or submitted

3. Pages AC-61 to 62 - #3 City Guide
Upload the completed database as City Guide.mdb

Points	Requirements
4	Advertiser table and Ad Rep table created
4	correct data entered into Advertiser table, Ad Rep table
4	Advertiser-Ad Rep Query
4	Advertiser form
4	Advertiser Status Report
20	Total possible for uploading City Guide.mdb

Drop Box - Upload Your Assignments to the Digital Drop Box

Downloads - Student files from publisher