Integrity Training – Microsoft Office Access 2010 Intermediate

Complex Queries (0:22)

Topic A: Joining Tables in Queries (0:09)

Joins (3:55)

Query Wizard (0:22)

Creating a Query (0:31)

Demo ­ A­1: Creating a Query with the Simple Query Wizard (1:23)

Creating Joins in Design View (1:11)

Dem o ­ A­2: Creating a Join in Design View (1:50)

Creating Outer Joins (1:28)

Demo ­ A­3: Creating an Outer Join (1:47)

Joins with an Intermediate Table (1:03)

Demo ­ A­4: Creating a Join with an Inter mediate Table (2:20)

Creating a Self ­Join Query (0:45)

Demo ­ A­5: Creating a Self­ Join Query (1:29)

Finding Unmatched Records (1:08)

Demo ­ A­6: Finding Records that Do Not Match Between Tables (1:48)

Finding Duplicate Records (1:06)

Demo ­ A­7: Finding Duplicate Records (1:25)

Demo ­ A­8: Deleting Tables from a Query (2:25)

Topic B: Using Calculated Fields (0:08)

Syntax for Calculated Fields (0:44)

Creating Calculated Fields (0:24)

Demo ­ B­1: Creating a Calculated Field (2:43)

Modifying Formats (0:27)

Demo ­ B­2: Changing the Format of a Displayed Value (0:38)

The Expression Builder (2:00)

Specifying Criteria (0:52)

Demo ­ B­3: Using the Expression Builder (1:06)

Topic C: Summarizing and Grouping Values (0:05)

Summary Functions in Queries (1:59)

Demo ­ C­1: Creating a Query to Display Summary Values (3:16)

Concatenation (1:01)

Demo ­ C­2: Using Queries to Concatenate Values (1:56)

Unit 03 Review (0:22)

Unit 03 Quiz

Advanced Form Design (0:29)

Topic A: Adding Unbound Controls (0:06)

Unbound Controls (0:25)

Drawing a Rectangle on a Form (0:30)

Demo ­ A­1: Drawing a Rectangle Around a Control (1:47)

Changing the Tab Order (1:16)

Demo ­ A­2: Changing the Tab Order (1:26)

Creating a Grouped Control (1:03)

Demo ­ A­3: Grouping Controls (1:46)

Topic B: Adding Graphics (0:03)

Add a Graphic to a Form (0:36)

Demo ­ B­1: Adding a Graphic to a Form (0:57)

Use an Unbound Object Frame (1:01)

Demo ­ B­2: Embedding a Graphic in an Unbound Object Frame (1:49)

Topic C: Adding Calculated Values (0:05)

Bind Controls to Calculated Fields (0:46)

Demo ­ C­1: Binding a Control to a Calculated Field (1:48)

Create a Calculated Control (0:47)

Align Controls on a Form (0:55)

Demo ­ C­2: Creating a Calculated Control (2:19)

Topic D: Adding Combo Boxes (0:04)

Add a Combo Box to a Form (1:20)

Demo ­ D­1: Adding a Combo Box to a Form (1:59)

Modify Combo Box Properties (0:33)

Demo ­ D­2: Modifying the Properties of a Combo Box (0:51)

Topic E: Advanced Form Types (0:10)

Create a Multiple­-item Form (0:45)

Demo ­ E­1: Creating a Multiple­-Item Form (1:32)

A Split Form (1:06)

Demo ­ E­2: Creating a Split Form (0:55)

A Datasheet Form (1:11)

Demo ­ E­3: Creating a Datasheet Form (1:50)

A Form and Subform (1:05)

Demo ­ E­4: Creating a Subform (1:30)

Unit 04 Review (0:26)

Unit 04 Quiz

Reports and Printing (0:26)

Topic A: Customized Headers and Footers (0:08)

Report Header (0:13)

Add a Report Header (0:32)

Demo ­- A-­1: Adding a Report Header (2:09)

Report Footer (0:20)

Demo – A-­2: Adding a Report Footer (1:50)

New Formatting Rule Dialog Box (1:15)

Demo -­ A-­3: Applying Conditional Formatting (1:32)

Set the Keep Together Property (0:57)

Demo- ­ A-­4: Keeping Parts of a Report on the Same Page (2:07)

The Group, Sort, and Total Pane (1:22)

Demo -­ A-­5: Adding Controls to Group Footers (2:53)

Force a New Page (0:46)

Demo ­- A-­6: Forcing a New Page (0:49)

Topic B: Calculated Values (0:04)

The DateDiff Function (1:02)

Using the DateDiff Function (0:31)

Demo ­ – B-­1: Working with the DateDiff Function (2:53)

The IIf Function (1:22)

Demo ­ – B­-2: Using the IIf Function (2:06)

Topic C: Printing (0:07)

Printing a Database Object (0:16)

Demo ­ – C-­1: Printing a Table (1:05)

Using the Database Documenter (1:00)

Demo ­ – C-­2: Printing a Database Document (1:23)

Topic D: Labels (0:03)

Using the Label Wizard (1:00)

Labels in Print Preview (0:51)

Demo ­ – D-­1: Creating Labels (3:09)

Unit 05 Review (0:31)

Unit 05 Quiz

Charts (0:20)

Topic A: Charts in Forms (0:10)

Adding a Chart to a Form (1:30)

Chart Types (0:40)