Access Database Design 2 Course Details

• What is a Form?
• Form Sections
• Form Controls
• Form Control Layout
• Using Form Controls
• Control Properties
• Control Wizards
• Multiple Table Forms

Advanced Form Design

• Using Advanced Forms Features
• The Form Worksurface
• Creating a Calculated Control
• Adding a Graphic to a Form
• Multi-Table Forms
• Using the Subform Control
• Switchboard Forms

Access and the Internet

• Using Hyperlinks
• Using Hyperlinks in Forms
• Exporting Datasheet Views to HTML
• Data Access Pages
• Reports
• Using Report Wizards as the Basis for Reports
• Report Sections
• Report Controls
• Report Control Layout
• Using Specific Controls
• Publishing Datasheet Views on the Internet
• Adding Hyperlinks to Datasheet Views
• Adding Hyperlinks to HTML Pages

• Applying Sorting and Grouping to Reports
• Performing Calculations on Reports
• Adding a Graphic to a Report
• Using the Subreport Control
• Modifying Section Properties
• Using the Chart Wizard

Importing, Exporting, and Linking Data

• Importing from Other Data Sources
• Linking Data
• Exporting Data

Database Management Tools

• Database Administration
• Documenting the Database Structure
• Backing Up and Restoring a Database
• Compacting and Repairing a Database
• Setting a Database Password
• Encrypting and Decrypting a Database

Access Performance Issues

• Indexes
• Data Validation
• Table Level Validation
• Relationships and Referential Integrity
• Relationships
• Field Types
• Referential Integrity Options
• Join Types
• Using Lookups for Referential Integrity
• Multi-Table Datasheet View