| |Microsoft Access 2010 Level 2 Tables, Queries, Forms and Reports
| |
ID: SAA101 | Course Length: 1 |  |
|
| | |
Module 0: Course Details |
| | | - Duration:1 Day Webinar Or Instructor-led Classroom Setting
- Modifying Tables
- Queries
- Formatting Controls
- Form Design
- Reports
- Prerequisites
- Successful Completion of An Introductory Course in Access
- Or Equivalent Knowledge and Experience.
- Some Degree of Practical Experience with Access
- Create Tables
- Understand and Create Relationships
- Create Simple Queries
- Objectives:this Course Will Cover
|
 |
| | |
Module 1: Review From Level 1 |
| | | - Using Field Properties
- Limiting Field Size
- Setting Number Formats
- Setting Date/time Formats
- Setting Yes/no Formats
- Setting Default Values
- Setting Validation Rules
- Creating An Input Mask
- Relationships
|
|
| | |
Module 2: Modifying Tables |
| | | - Inserting a Lookup Column
- Inserting a Hyperlink Column
- Adding Smart Tags
- Creating Complex Data Fields
|
|
| | |
Module 3: Designing Advanced Queries |
| | | - Setting Top Values in a Query
- Creating a Calculated Field
- Formatting a Calculated Field
- Creating a Function Query
- Creating a Parameter Query
- Creating a Concatenation in a Query
|
|
| | |
Module 4: Creating Action Queries |
| | | - Creating a Make-table Query
- Creating An Update Query
- Creating An Append Query
- Creating a Delete Query
|
|
| | |
Module 5: Using Advanced Query Wizards |
| | | - Using the Crosstab Query Wizard
- Using the Find Duplicates Query Wizard
- Using the Find Unmatched Query Wizard
|
|
| | |
Module 6: Working and Formatting Forms |
| | | - Basic Form Controls
- Adding a Control
- Using the Control Wizard
- Copying, Pasting, and Moving a Control
- Modifying the Font
- Changing the Layout
- Using Autoformat
|
|
| | |
Module 7: Formatting Controls |
| | | - Changing the Color of a Control
- Using Control Properties
- Aligning Controls
- Applying Special Effects
|
|
| | |
Module 8: Advanced Form Controls |
| | | - Modifying a Control’s Properties
- Changing a Control’s Data Source
- Changing a Control’s Default Value
- Creating a Calculated Control
- Using Form Properties
|
|
| | |
Module 9: Using Advanced Form Design |
| | | - Creating a Combo Box
- Creating a List Box
- Creating An Option Group
- Setting the Tab Order
- Adding a Form Header and Footer
|
|
| | |
Module 10: Working with Reports |
| | | - Organizing Report Data
- Adding and Removing Fields
- Using Report Sections
- Changing Section Properties
- Grouping and Sorting in a Report
- Changing Group Properties
- Using Calculated Controls in a Report
|
|
| | |
Module 11: Common Report Tasks |
| | | - Adding a Photo
- Adjusting Page Properties
- Adding Headers and Footers
- Adding Page Numbers
- Using the Label Wizard
|
|
| | |
Module 12: Lab |
| | |
|
|