Course Overview
This course goes into more detail on how to make the database objects more interactive within Microsoft Access 2010. Starting with an explanation of the different table relationships and setting advanced properties within a table, this course shows you how to effectively use the tools within Microsoft Access to verify data as it gets entered into the database. Additionally, this course shows you how to import an Excel spreadsheet and use the different Action Queries to create a relational database. Finally, the course shows how to create interactive forms and reports by adding calculated controls.
Course Objectives
Understanding Table Relationships, Introducing Advanced Table Design, Using Action Queries with Imported Data, Creating Calculated and Parameter Queries, Using Advanced Form Features, Advanced Report Functions
Course Prerequisites
There are no prerequisites for this course.
Agenda
1 - Introduction
2 - Understanding Table Relationships
- Understanding Table Relationships
- The 1 to 1 Relationship
- The 1 to Many Relationship
- The Many to Many Relationship
- Creating a 1 to 1 Relationship
- Enforcing Referential Integrity
- Creating a 1 to Many Relationship
- Creating a Many to Many Relationship
3 - Introducing Advanced Table Design
- Reviewing the Field Data Types
- Setting the Format Property
- Using the Input Mask Property
- Setting Default Values and Validation Rules
- Using the Required and Indexed Properties
- Reviewing the Unicode Compression
4 - Using Action Queries with Imported Data
- Importing vs. Linking External Data
- Using the Delete Query
- Using the Update Query
- Using the Make Table Query
- Using the Append Query
5 - Creating Calculated and Parameter Queries
- Calculating Numbers
- Calculating Totals and Using Group By
- Concatenating Text
- Creating Parameter Queries
- Using Wildcards with Your Parameter Entry
6 - Using Advanced Form Features
- Reviewing the Invisible Table
- Removing a Single Control from the Table
- Locking and Hiding a Control
- Modifying the Layout
- Adding an Unbound Control
- Adding Calculated Controls
- Adding a Combo Box Control
- Changing a Control Type
7 - Advanced Report Functions
- Using the Report Wizard
- Reviewing the Report Bands
- Manipulating Controls in a Report
- Adding Parameters to a Report
- Using a Parameter Query with a Report
- Using the Group/Sort Panel
8 - Conclusion