Look at the MOUS specifications (http://www.mous.net/tests/access/htm). The goal here is to be able to do everything in the skill sets for Expert Level on the Access 97 exam.

To do this you can use an existing database that you have developed or you can develop a new database. Your project should include the following (some me, some them):

• Create a form
• Modify the form in design view
• Create controls on a form
• Modify controls
• Add a record using a form
• Show related records on a form
• Show a form with a subform in a 1 to many relationship
• Add a record with a main form
• Add a record with a sub form
• Show a list or combo on the form
• Anyone that successful does something worth while with radio, check etc gets extra credit
• Maintain data integrity by a validation test
• Set required properties
• Set validation rules
• Set look up fields (combo or list)
• Create a report
• Modify a report in design view
• Label a report
• Customize headers and footers
• Make a calculation on a report
• Group data in a report
• Sort data in a report