Access 2007 Intermediate Comprehensive
This 2 day course provides the same content included in Access
2007 Intermediate Essentials, plus in-depth training in the following
core database components: tables, queries, forms and reports. Participants
will create a well-designed database from the ground up, making full use of
relevant features new to Access 2007. This course is appropriate for those
individuals seeking to create a new database or achieve a strong understanding
of Access 2007. Together with Access 2007 Basic
and Access 2007 Advanced, this course maps
directly to the MCAS certification exam.
Please see Access 2007 Intermediate Essentials
as an alternative course.
Register for a class
Personalized training and consulting is available upon
request.
Tables
Lesson 1: Database Design
- Database Design Recommendations
- Working with Table Relationships
- Creating a Database
Lesson 2: Creating Tables
- Design View v. Datasheet View
- Using Primary Keys
- Assigning Data Types
- Creating Lookup Fields
Lesson 3: Creating Relationships
- Creating One-to-Many Relationships
- Querying Related Tables
- Using Junction Tables
- Implementing Referential Integrity
- Using Subdatasheets
Lesson 4: Ensuring Valid Data Entry
- Advanced Field Properties
- Using Input Masks
- Lookup Field Properties
- Forms
Forms
Lesson 5: Creating Data Entry Forms
- Instant Forms
- Split Forms
- Multiple Items Forms
- Using the Form Wizard
- Blank Forms
Lesson 6: Form Enhancements
- Changing Fonts and Text Styles
- Using Conditional Formatting
- Formatting Numbers, Gridlines, and Other Special Elements
- Adding Fields from Related Tables
Lesson 7: Form Enhancements
- Working with Controls and Control Properties
- Creating Calculated Fields
- Using Control Layouts
Lesson 8: Applying Advanced Controls
- Tab Controls
- Combo Boxes
- Subforms
- Option Groups
|
|
Queries
Lesson 9: Revisiting Table Relationships
- Using Relational Databases
- Understanding Join Types
- Understanding Referential Integrity
Lesson 10: Creating Select Queries
- Querying from Related Tables
- Finding Unmatched Records
- Using Criteria
- Using Subqueries
Lesson 11: Using Calculations in Queries
- Creating Calculated Fields
- Using the Expression Builder
- Adding Grouping and Totals
- Concatenating Fields
Lesson 12: Additional Query Topics
- Using PivotTable Queries
- Using Parameter Queries
- Displaying Top Values
Reports
Lesson 13: Using Layout View
- Creating Reports in Layout View
- Changing Fonts and Text Styles
- Using Conditional Formatting
- Formatting Reports
- Adding and Arranging Fields
- Reporting from Related Tables
- Adding Grouping, Subtotals, and Grand Totals
Lesson 14: Using Design View
- Creating Reports in Design View
- Creating Custom Headers/Footers
- Creating Calculations and Unbound Objects
- Arranging, Aligning, and Sizing Controls
Lesson 15: Adjusting Page Layout and Printing
- Page Setup And Margins
- Changing Custom Group Properties
- Printing Reports
- Exporting Reports to Word
- Creating Mailing Labels
Lesson 16: Using Queries for Effective Reports
- Using Queries as a Record Source
- Filtering Reports Using Parameter Values
|
