This workshop introduces experienced Access users to issues relating to database design and the packaging of completed databases for distribution to end users. The workshop begins with an extensive lecture and discussion section on database modeling, then proceeds into a series of hands-on exercises to implement the database design and create a usable application for end users. Also provides a brief introduction to database security considerations.

(Description continued below)

Participants will:

• define database needs
• use business rules in database design
• model a database before creating it
• normalize imported flat file data into separate tables
• create and maintain complex table relationships
• package and password protect a database
• compact a database

The following workshops are suggested prerequisites to this workshop:

• Access: Reports

Participants should already be able to:

• Understand database relationships
• Create and edit relational forms and reports
• Create a form-based application