Class Descriptions
Please Note: Pre-requisites are guidelines to assist you in selecting the class best suited to your experience and needs; prior formal training is not required, students are encouraged to closely evaluate their skills to insure they register for the appropriate class; before registering for any class.
Access 2010 Level 2 (1 Day):
Prerequisites:
Description:
Lesson 1 - Database Relationships
1.1 A Look At Relationships
1.2 Creating A One-To-One Relationship
1.3 Creating A One-To-Many Relationship
1.4 Creating A Many-To-Many Relationship
1.5 Enforcing Referential Integrity
1.6 Cascade Update Related Fields
1.7 Cascade Delete Related Records
1.8 Creating & Printing A Relationship Report
Lesson Summary Database Relationships
Lesson 2 - Working With Tables
2.1 Setting Validation Rules
2.2 Formatting Fields
2.3 Indexing Fields
2.4 Requiring Data Entry
2.5 Creating An Input Mask
2.6 Creating A Lookup Field
2.7 Creating A Value List
2.8 Modifying A Value List
2.9 Creating Calculated Fields
2.10 Creating Multiple Primary Keys
2.11 Creating Multiple Field Values
Lesson 3 - Working With Queries
3.1 Creating Multi-Table Queries
3.2 Using Calculations In Queries
3.3 Changing Query Properties
3.4 Working With The Expression Builder
3.5 Creating A Totals Query
3.6 Creating A Parameter Query
3.7 Creating A Find Duplicates Query
3.8 Creating A Find Unmatched Records Query
3.9 Modifying Query Joins
Lesson Summary Working With Queries
Lesson 4 - Working With Forms
4.1 Adding Headers And Footers
4.2 Adding Controls To A Form
4.3 Moving And Sizing Controls
4.4 Creating A Calculated Control
4.5 Changing Control Properties
4.6 Changing Form Properties
4.7 Changing The Tab Order
4.8 Adding A Lookup Control
4.9 Inserting Graphics
4.10 Creating A Subform
Lesson 5 - Working With Reports
5.1 Working With Report Sections
5.2 Adding Controls To A Report
5.3 Changing Control Properties
5.4 Creating A Calculated Control
5.5 Changing A Controls Data Source
5.6 Changing A Reports Data Source
5.7 Sorting And Grouping Data
5.8 Changing Report Section Properties
5.9 Inserting Graphics
5.10 Applying A Theme To A Report
5.11 Applying Conditional Formatting
