Access 2010-Designing & Packaging Databases

About the Class:

This workshop lasts 3 hours.

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, and 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.

What You’ll Learn:

  • 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

What You Need to Know:

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

If you don’t have those skills, consider first taking the workshop:

  • Access 2010 – Reports

Resources

Access 2010(PC) Access 2012(Mac)
 Microsoft Office: Database Design Basics
 Microsoft Office: Encrypt a Database by Using a Database Password
 Microsoft Office: Help Prevent and Correct Database File Problems by Using Compact and Repair