|
Provided by: Last Minute Training Access Intermediate - Level 2Access |
 |
Training
Provided by Last Minute Training
This course provides competency in creating and using forms and sub forms, using advanced form features, creating and using reports, using advanced report features, enhancing forms and reports, using data access pages, managing databases, and importing and exporting data.
|
|
||||||||||
Access Intermediate - Level 2
Unit 1 : Creating relational databases
Topic A: 0 Database normalization
A-1: Determining first normal form
A-2: Determining second normal form
A-3: Determining third normal form
Topic B: 0 Relating tables
B-1: Establishing a one-to-one table relationship
B-2: Establishing a one-to-many table relationship
B-3: Establishing a many-to-many relationship
Topic C: 0 Implementing referential integrity
C-1: Planning table relationships
C-2: Working with orphan records
C-3: Setting cascading deletes
C-4: Testing cascading deletes
C-5: Setting cascading updates
C-6: Testing cascading updates
Unit 2 : Working with related tables
Topic A: 0 Using the Lookup Wizard
A-1: Examining table relationships
A-2: Creating a Lookup list field
Topic B: 0 Modifying Lookup fields
B-1: Modifying Lookup field properties
B-2: Changing a text box control to another type of control
Topic C: 0 Adding data to related tables
C-1: Adding data to related tables
Unit 3 : Defining data entry rules
Topic A: 0 Working with input masks
A-1: Creating an input mask to control how data is entered in a field
A-2: Creating an input mask for a combo box in a form
A-3: Working with the Input Mask Wizard
Topic B: 0 Setting properties
B-1: Setting the Required property for a field
B-2: Using the AllowZeroLength property for a field
B-3: Setting the Field Size property to limit field length
Topic C: 0 Setting validation rules
C-1: Establishing default values
C-2: Creating validation rules
C-3: Setting validation text
Unit 4 : Using advanced query features
Topic A: 0 Joining tables in queries
A-1: Using a query to join tables
A-2: Creating a join in Design view
A-3: Creating an outer join
A-4: Creating a join by using an intermediate table
A-5: Creating a self-join query
Topic B: 0 Creating calculated fields
B-1: Creating a calculated field
B-2: Modifying the format of a displayed value
B-3: Using the Expression Builder
Topic C: 0 Using action queries
C-1: Copying a table object
C-2: Using an append query to add a record to a table
C-3: Deleting records with a delete query
C-4: Modifying records with an update query
C-5: Creating a make-table query
Unit 5 : Creating advanced queries
Topic A: 0 Summarizing and grouping values
A-1: Creating a query to display summary values
A-2: Concatenating values
A-3: Finding records that do not match between tables
Topic B: 0 Creating crosstab queries
B-1: Viewing a crosstab query
B-2: Creating a crosstab query with the Crosstab Query Wizard
Topic C: 0 Using parameter queries
C-1: Creating a single-criterion parameter query
C-2: Creating a query with multiple parameters
C-3: Using a wildcard in a parameter query
Topic D: 0 Using indexes
D-1: Creating a single-field index
D-2: Creating a multiple-field index
Unit 6 : Creating advanced form design
Topic A: 0 Adding graphics
A-1: Adding a graphic to a form
A-2: Embedding a graphic in an unbound object frame
Topic B: 0 Adding calculations
B-1: Binding a control to a calculated field
B-2: Creating a calculated control
B-3: Aligning objects
Topic C: 0 Adding combo boxes
C-1: Adding a combo box to a form
C-2: Modifying the properties of a combo box
Topic D: 0 Adding unbound controls
D-1: Adding an unbound control to a form
D-2: Drawing a rectangle around a control
D-3: Changing tab order
Unit 7 : Using advanced report features
Topic A: 0 Creating customized headers and footers
A-1: Adding a report header
A-2: Adding a report footer
A-3: Applying conditional formatting
A-4: Keeping parts of the report on the same page
A-5: Adding controls to group footers
A-6: Forcing a new page
A-7: Working with the HideDuplicates property
Topic B: 0 Adding calculated values
B-1: Working with the DateDiff function
B-2: Using the IIF function
Topic C: 0 Working with subreports
C-1: Embedding the subreport
C-2: Viewing and troubleshooting report results
Unit 8 : Creating charts
Topic A: 0 Creating charts in forms
A-1: Creating a chart in a form
A-2: Enhancing a chart in a form
Topic B: 0 Creating charts in reports
B-1: Adding a chart to a report
B-2: Modifying a chart in a report
Appendix A : Working with data access pages
Topic A: 0 Creating a data access page
A-1: Creating a data access page by using the Page Wizard
Appendix B : MOUS exam objectives map
Topic A: 0 Core exam objectives
Topic B: 0 Expert exam objectives
Topic A: 0 Database normalization
A-1: Determining first normal form
A-2: Determining second normal form
A-3: Determining third normal form
Topic B: 0 Relating tables
B-1: Establishing a one-to-one table relationship
B-2: Establishing a one-to-many table relationship
B-3: Establishing a many-to-many relationship
Topic C: 0 Implementing referential integrity
C-1: Planning table relationships
C-2: Working with orphan records
C-3: Setting cascading deletes
C-4: Testing cascading deletes
C-5: Setting cascading updates
C-6: Testing cascading updates
Unit 2 : Working with related tables
Topic A: 0 Using the Lookup Wizard
A-1: Examining table relationships
A-2: Creating a Lookup list field
Topic B: 0 Modifying Lookup fields
B-1: Modifying Lookup field properties
B-2: Changing a text box control to another type of control
Topic C: 0 Adding data to related tables
C-1: Adding data to related tables
Unit 3 : Defining data entry rules
Topic A: 0 Working with input masks
A-1: Creating an input mask to control how data is entered in a field
A-2: Creating an input mask for a combo box in a form
A-3: Working with the Input Mask Wizard
Topic B: 0 Setting properties
B-1: Setting the Required property for a field
B-2: Using the AllowZeroLength property for a field
B-3: Setting the Field Size property to limit field length
Topic C: 0 Setting validation rules
C-1: Establishing default values
C-2: Creating validation rules
C-3: Setting validation text
Unit 4 : Using advanced query features
Topic A: 0 Joining tables in queries
A-1: Using a query to join tables
A-2: Creating a join in Design view
A-3: Creating an outer join
A-4: Creating a join by using an intermediate table
A-5: Creating a self-join query
Topic B: 0 Creating calculated fields
B-1: Creating a calculated field
B-2: Modifying the format of a displayed value
B-3: Using the Expression Builder
Topic C: 0 Using action queries
C-1: Copying a table object
C-2: Using an append query to add a record to a table
C-3: Deleting records with a delete query
C-4: Modifying records with an update query
C-5: Creating a make-table query
Unit 5 : Creating advanced queries
Topic A: 0 Summarizing and grouping values
A-1: Creating a query to display summary values
A-2: Concatenating values
A-3: Finding records that do not match between tables
Topic B: 0 Creating crosstab queries
B-1: Viewing a crosstab query
B-2: Creating a crosstab query with the Crosstab Query Wizard
Topic C: 0 Using parameter queries
C-1: Creating a single-criterion parameter query
C-2: Creating a query with multiple parameters
C-3: Using a wildcard in a parameter query
Topic D: 0 Using indexes
D-1: Creating a single-field index
D-2: Creating a multiple-field index
Unit 6 : Creating advanced form design
Topic A: 0 Adding graphics
A-1: Adding a graphic to a form
A-2: Embedding a graphic in an unbound object frame
Topic B: 0 Adding calculations
B-1: Binding a control to a calculated field
B-2: Creating a calculated control
B-3: Aligning objects
Topic C: 0 Adding combo boxes
C-1: Adding a combo box to a form
C-2: Modifying the properties of a combo box
Topic D: 0 Adding unbound controls
D-1: Adding an unbound control to a form
D-2: Drawing a rectangle around a control
D-3: Changing tab order
Unit 7 : Using advanced report features
Topic A: 0 Creating customized headers and footers
A-1: Adding a report header
A-2: Adding a report footer
A-3: Applying conditional formatting
A-4: Keeping parts of the report on the same page
A-5: Adding controls to group footers
A-6: Forcing a new page
A-7: Working with the HideDuplicates property
Topic B: 0 Adding calculated values
B-1: Working with the DateDiff function
B-2: Using the IIF function
Topic C: 0 Working with subreports
C-1: Embedding the subreport
C-2: Viewing and troubleshooting report results
Unit 8 : Creating charts
Topic A: 0 Creating charts in forms
A-1: Creating a chart in a form
A-2: Enhancing a chart in a form
Topic B: 0 Creating charts in reports
B-1: Adding a chart to a report
B-2: Modifying a chart in a report
Appendix A : Working with data access pages
Topic A: 0 Creating a data access page
A-1: Creating a data access page by using the Page Wizard
Appendix B : MOUS exam objectives map
Topic A: 0 Core exam objectives
Topic B: 0 Expert exam objectives
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
