|
|
|
ms202-ver12.7-sg
Microsoft Office Access 2007 - Level 2 (1 day)
Description
You have the basic skills needed to work Microsoft Office Access 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to create advanced reports.
Prerequisites• Microsoft Office Access 2007 - Level 1
Supplemental Instructor ResourcesInstructor class workshop files are available for download after purchasing this product.
Course OutlineLesson 1: Understanding Relational Databases • Understand Database Design • Work with Normalization • Use the Table Analyzer Wizard • Understand Relationships • Understand Referential Integrity • Create an Explicit Relationship
Lesson 2: Working with Table Design • Use the Table Design View • Utilize the Field Components • Work with the Field Properties • Understand Field Data Types • Enter Field Names • Enter Field Size • Understand the Format Property • Work with the Decimal Places Property • Understand the Input Mask Property • Use the Caption Property • Work with the Default Value Property • Utilize the Validation Rule Property • Utilize the Required Property • Understand the Allow Zero-Length Property • Use the Indexed Property • Work with the Unicode Compression Property
Lesson 3: Calculated and Action Queries • Work with an Action Query • Utilize a Parameter Query • Use the Query Design Tab • Perform Calculations in a Query • Calculate Totals with the Query • Use the Make-Table Query • Use the Update Query • Use the Append Query • Create a Delete Query • Create Parameter Queries • Create Crosstab Queries
Lesson 4: Advanced Form Functions • Use Advanced Form Features • Revisit the Form Design • Use Form Design Tools Ribbons • Add Controls • Add Bound and Unbound Controls • Use the Form Layout • Select, Move and Resize Controls • Add Calculated Controls • Place an Unbound Control • Add a Combo Box • Fine Tune a Combo Box • Change a Control Type
Lesson 5: Advanced Report Functions • Use Advanced Report Features • Use the Report Design Window • Understand Report Bands • Use the Report Layout Tools Ribbons • Format Fields • Create Calculated Controls • Create Dynamic Reports • Sort and Group Data
|
|
|
|
| Students interested in this course book have also been interested in the following virtual digital books (vBooks). |
|
 |
|
|
|
|
|
|
