listed below

You can complete this MS Word document

Actions

or use MS Access to create your database. Note, Mac users must use the Word document.

___1. Create a database and name the file using your last name_final project

___2. Create a table

___3. Create a minimum of 5 fields in table

___4. Create a minimum of 6 records in table

___5. Assign a primary key (note the primary key must be unique for all possible data)

___6. Create a form based on table

___7. Create a query containing 3 fields – your choice of fields

___8. Create another query containing 4 fields – sort the query on your choice of field

___9. Create a query with at least 3 fields and restrict the query results with your choice of criteria

___10. Create a report based on table or one of queries