Access 2010 Training

Unit 01 - Getting Started
Topic A: Database Concepts
Database Components
Relational Database
Topic B: Exploring the Access Environment
The Access Environment
Demo - B-1: Starting Access and Examining the Access Window
Opening Databases
Demo - B-2: Opening a Database
The Navigation Pane and Menu
Demo - B-3: Using the Navigation Pane
Open a Database Table
Demo - B-4: Examining a Database Table
Topic C: Getting Help
Access Help Online
Access Help Offline
Demo - C-1: Using Help
Unit 01 Review
Topic A: Database Concepts
Unit 01 Review

Unit 02 - Databases and Tables
Topic A: Planning and Designing Databases
Planning a Database
Rules for Names
Using a Database Template
Demo - A-2: Creating a Database from a Template
Creating a Blank Database
Demo - A-3: Creating a Blank Database
Topic B: Exploring Tables
Views for Tables
Datasheet View
Demo - B-2: Examining a Table in Datasheet View
Navigating in Datasheet View
The Record Selector
Demo - B-3: Navigating a Table in Datasheet View
Table in Design View
Demo - B-4: Examining a Table in Design View
Topic C: Creating Tables
Demo - C-1: Creating a Table from a Table Template
Creating Tables in Design View
Demo - C-2: Creating a Table in Design View
Demo - C-3: Adding Fields and Descriptions to a Table
Setting the Primary Key
Demo - C-4: Setting the Primary Key
The Save As Dialog Box
Demo - C-5: Saving the Table
Adding a Record
Demo - C-6: Adding a Record
The Paste Table As Dialog Box
Demo - C-7: Copying, Modifying, and Deleting a Table
A Composite Key
Demo - C-8: Creating a Composite Key
Demo - C-9: Using the Data Type Gallery
Unit 02 Review

Unit 03 - Fields and Records
Topic A: Changing the Design of a Table
Ineffective Field Names
Demo - A-1: Modifying Field Names
Selecting a Field
Deleting and Inserting Fields
Demo - A-2: Deleting and Inserting Fields
Moving a Field
Demo - A-3: Moving a Field
Using the Attachment Data Type
The Attachments Dialog Box
Demo - A-4:Using the Attachment Data Type
Demo - A-5: Adding a Totals Row
Topic B: Finding and Editing Records
The Find and Replace Dialog Box
Demo - B-1: Finding and Replacing a Value
Undoing Changes
Demo - B-2: Undoing Changes
Topic C: Organizing Records
Sorting Records by a Single Field
Demo - C-1: Sorting Records by a Single Field
Sorting Records by Multiple Fields
Demo - C-2: Sorting Records by Multiple Fields
Filter By Selection
Filter from the Shortcut Menu
Demo - C-3: Using Filter By Selection
Filter By Form
Demo - C-4: Using Filter By Form
Filter Excluding Selection
Demo - C-5: Using Filter Excluding Selection
Advanced Filter/Sort
Demo - C-6: Using Advanced Filter/Sort
Deleting Records
Demo - C-7: Deleting a Record
Unit 03 Review

Unit 04 - Data Entry Rules
Topic A: Setting Field Properties
Topic A: Setting Field Properties
Field Properties
Setting the Required Property
Demo - A-1: Setting the Required Property
Allow Zero Length Property
Demo - A-2: Using the Allow Zero Length Property
Field Size Property
Demo - A-3: Setting the Field Size Property
Append Only Property
The History Dialog Box
Demo - A-4: Setting the Append Only Property
Topic B: Working with Input Masks
Input Mask Definition: Sections
Creating an Input Mask
Demo - B-1: Creating an Input Mask
Using the Input Mask Wizard
Demo - B-2: Working with the Input Mask Wizard
Topic C: Setting Validation Rules
Creating a Validation Rule
Demo - C-1: Creating Validation Rules
Setting Validation Text
Demo - C-2: Setting Validation Text
Unit 04 Review

Unit 05 - Basic Queries
Topic A: Creating and Using Queries
Queries
The Simple Query Wizard
Demo - A-2: Using the Query Wizard
Creating Queries in Design View
Demo - A-3: Creating a Query in Design View
Saving and Running a Query
Demo - A-4: Saving and Running the Query
Sorting Query Results
Demo - A-5: Sorting Query Results
Filtering Query Results
Demo - A-6: Filtering a Query by Adding Criteria
Creating Queries from Filters
Demo - A-7: Creating a Query from a Filter
Topic B: Modifying Query Results and Queries
Editing Records in Query Results
Demo - B-1: Editing Query Results
Modifying the Query Design
Demo - B-2: Adding Fields to a Query
Searching for Null Values
Demo - B-3: Finding Records with Empty Fields
Topic C: Performing Operations in Queries
Using Comparison Operators
Demo - C-1: Using Comparison Operators
Using the OR Condition
Demo - C-2: Using the OR Condition
Using the AND Condition
Demo - C-3: Using the AND Condition
Wildcard Operators
Demo - C-4: Using the * Wildcard
Using Calculations
Demo - C-5: Using Calculations in a Query
Totaling a Group of Records
Demo - C-6: Totaling a Group of Records
Avg and Count Functions
Demo - C-7: Using the Avg and Count Functions
Demo - C-8: Using the Min and Max Functions
Unit 05 Review

Unit 06 - Using Forms
Topic A: Creating Forms
A Sample Form
A Form in Design View
Form Tools on the Design Tab
Form Tools on the Arrange Tab
Form Tools on the Format Tab
Demo - A-1: Examining a Form
Using the Form Button
A Basic Form
Demo - A-2: Creating a Basic Form
The Form Wizard
Demo - A-3: Creating a Form by Using the Form Wizard
Topic B: Using Design View
Creating Forms in Design View
Demo - B-1: Creating a Form in Design View
Adding a Control
Demo - B-2: Adding Controls
A Property Sheet
Modifying Section Properties
Demo - B-3: Modifying Properties
Conditional Formatting
Demo - B-4: Applying Conditional Formatting
Topic C: Sorting and Filtering Records
Sorting Records
Demo - C-1: Using a Form to Sort Records
Filtering Records
Demo - C-2: Using a Form to Filter Records
Unit 06 Review

Unit 07 - Working with Reports
Topic A: Creating Reports
Topic A: Creating Reports
Print Preview
Demo - A-1: Examining a Report
Basic Reports
Demo - A-2: Creating a Basic Report
Using the Report Wizard
Sample Report Preview
Demo - A-3: Creating a Report by Using the Report Wizard
Sections in Design View
Demo - A-4: Creating a Report in Design View
Topic B: Modifying and Printing Reports
Modifying Reports
Demo - B-1: Modifying a Report in Design View
Layout View
Demo - B-2: Modifying a Report in Layout View
Grouping Records in a Report
Group, Sort, and Total Pane
Demo - B-3: Grouping, Sorting, and Filtering a Report
Adding Summary Fields
Summary Options Dialog Box
Demo - B-4: Adding Summary Fields by Using the Report Wizard
Modifying Report Layout and Style
Demo - B-5: Modifying the Layout and Style of a Report
The Print Preview Tab
Demo - B-6: Printing a Report
Unit 07 Review

Unit 08 - Relational Databases
Topic A: Database Normalization
Normalization
Steps to Normalize: Rule 1
Steps to Normalize: Rule 2
Steps to Normalize: Rule 3
Demo - A-3: Using the Table Analyzer
Demo - A-4: Identifying Object Dependencies
Topic B: Table Relationships
Establishing Relationships
The Relationships Window
Demo - B-1: Establishing a One-to-One Table Relationship
One-to-Many Relationship
Demo - B-2: Establishing a One-to-Many Table Relationship
Junction Tables
Many-to-Many with Junction
Demo - B-3: Establishing a Many-to-Many Table Relationship
Printing Table Relationships
Demo - B-4: Printing Table Relationships
Topic C: Referential Integrity
Referential Integrity
Demo - C-1: Planning Table Relationships
Orphan Records
Demo - C-2: Working with Orphan Records
Using Cascading Deletes
Demo - C-3: Setting Cascading Deletes
Testing Cascading Deletes
Demo - C-4: Testing Cascading Deletes
Cascading Updates
Demo - C-5: Using Cascading Updates
Unit 08 Review

Unit 09 - Related Tables
Topic A: Creating Lookup Fields
Lookup Field
Creating a Lookup Field
Demo - A-1: Creating a Lookup Field
Multivalued Fields
A Multivalued Lookup Column
Demo - A-2: Creating a Multivalued Lookup Field
Topic B: Modifying Lookup Fields
Display Column Headings
Demo - B-1: Modifying Lookup Field Properties
Types of Controls
Using a Value List Combo Box
Demo - B-2: Changing a Text Box to a Combo Box
Topic C: Using Subdatasheets
A Subdatasheet
Inserting a Subdatasheet
Demo - C-1: Using a Subdatasheet
Unit 09 Review

Unit 10 - Complex Queries
Topic A: Joining Tables in Queries
Joins
Query Wizard
Creating a Query
Demo - A-1: Creating a Query with the Simple Query Wizard
Creating Joins in Design View
Demo - A-2: Creating a Join in Design View
Creating Outer Joins
Demo - A-3: Creating an Outer Join
Joins with an Intermediate Table
Demo - A-4: Creating a Join with an Intermediate Table
Creating a Self-Join Query
Demo - A-5: Creating a Self-Join Query
Finding Unmatched Records
Demo - A-6: Finding Records that Do Not Match Between Tables
Finding Duplicate Records
Demo - A-7: Finding Duplicate Records
Demo - A-8: Deleting Tables from a Query
Topic B: Using Calculated Fields
Syntax for Calculated Fields
Creating Calculated Fields
Demo - B-1: Creating a Calculated Field
Modifying Formats
Demo - B-2: Changing the Format of a Displayed Value
The Expression Builder
Specifying Criteria
Demo - B-3: Using the Expression Builder
Topic C: Summarizing and Grouping Values
Summary Functions in Queries
Demo - C-1: Creating a Query to Display Summary Values
Concatenation
Demo - C-2: Using Queries to Concatenate Values
Unit 10 Review

Unit 11 - Advanced Form Design
Topic A: Adding Unbound Controls
Unbound Controls
Drawing a Rectangle on a Form
Demo - A-1: Drawing a Rectangle Around a Control
Changing the Tab Order
Demo - A-2: Changing the Tab Order
Creating a Grouped Control
Demo - A-3: Grouping Controls
Topic B: Adding Graphics
Add a Graphic to a Form
Demo - B-1: Adding a Graphic to a Form
Use an Unbound Object Frame
Demo - B-2: Embedding a Graphic in an Unbound Object Frame
Topic C: Adding Calculated Values
Bind Controls to Calculated Fields
Demo - C-1: Binding a Control to a Calculated Field
Create a Calculated Control
Align Controls on a Form
Demo - C-2: Creating a Calculated Control
Topic D: Adding Combo Boxes
Add a Combo Box to a Form
Demo - D-1: Adding a Combo Box to a Form
Modify Combo Box Properties
Demo - D-2: Modifying the Properties of a Combo Box
Topic E: Advanced Form Types
Create a Multiple-item Form
Demo - E-1: Creating a Multiple-Item Form
A Split Form
Demo - E-2: Creating a Split Form
A Datasheet Form
Demo - E-3: Creating a Datasheet Form
A Form and Subform
Demo - E-4: Creating a Subform
Unit 11 Review

Unit 12 - Reports and Printing
Topic A: Customized Headers and Footers
Report Header
Add a Report Header
Demo - A-1: Adding a Report Header
Report Footer
Demo - A-2: Adding a Report Footer
New Formatting Rule Dialog Box
Demo - A-3: Applying Conditional Formatting
Set the Keep Together Property
Demo - A-4: Keeping Parts of a Report on the Same Page
The Group, Sort, and Total Pane
Demo - A-5: Adding Controls to Group Footers
Force a New Page
Demo - A-6: Forcing a New Page
Topic B: Calculated Values
The DateDiff Function
Using the DateDiff Function
Demo - B-1: Working with the DateDiff Function
The IIf Function
Demo - B-2: Using the IIf Function
Topic C: Printing
Printing a Database Object
Demo - C-1: Printing a Table
Using the Database Documenter
Demo - C-2: Printing a Database Document
Topic D: Labels
Using the Label Wizard
Labels in Print Preview
Demo - D-1: Creating Labels
Unit 12 Review

Unit 13 - Charts
Topic A: Charts in Forms
Adding a Chart to a Form
Chart Types
Demo - A-1: Creating a Chart in a Form
Naming the X- and Y-axes
Demo - A-2: Modifying a Chart in a Form
Topic B: Charts in Reports
Charts in Reports
Demo - B-1: Adding a Chart to a Report
Format a Chart Item
The Chart Type Dialog Box
Demo - B-2: Modifying Charts in Reports
Unit 13 Review

Unit 14 - PivotTables and PivotCharts
Topic A: PivotTables
PivotTable View
Drop Areas
Demo - A-1: Examining PivotTable View
Add Fields to a PivotTable
Demo - A-2: Adding Fields to a PivotTable
Topic B: Modifying PivotTables
Summarize Data
Demo - B-1: Creating Totals
Move Fields in a PivotTable
Demo - B-2: Moving Fields in a PivotTable
Hide or Show Details
Demo - B-3: Showing and Hiding Details in a PivotTable
Change Field Settings
Demo - B-4: Formatting Fields
Topic C: PivotCharts
PivotChart Field Mapping
A PivotChart
Demo - C-1: Creating a PivotChart
Topic D: PivotTable Forms
Create a PivotTable Form
Demo - D-1: Creating a PivotTable Form
Unit 14 Review

Unit 15 - Querying with SQL
Topic A: SQL and Access
Sample SQL Statements
A Query in SQL View
Demo - A2: Examining a SQL Statement in Access
Topic B: Writing SQL Statements
Writing a SQL Statement
Demo - B1: Writing a SQL SELECT Statement
Syntax for WHERE Clause
Demo - B2: Using the WHERE Clause
Aliases
Demo - B3: Creating Aliases
Syntax to Display Matched Records
Demo - B4: Displaying Matching Records from Related Tables
Syntax to Display Unmatched Records
Demo - B5: Finding Unmatched Records
Context-Sensitive Help
Demo - B6: Getting Context-Sensitive Help on SQL
Topic C: Attaching SQL Queries to Controls
SQL-Specific Queries
Create a Union Query
Attach a SQL Query to a Button
Command Button Wizard
Demo - C1: Assigning a SQL Query to a Command Button
Unit 15 Review

Unit 16 - Advanced Queries
Topic A: Creating Crosstab Queries
A Crosstab Query Result
Demo - A-1: Viewing a Crosstab Query
Create a Crosstab Query
The Crosstab Query Wizard
Demo - A-2: Using the Crosstab Query Wizard
Topic B: Creating Parameter Queries
Create a Single-Criterion Query
Demo - B1: Creating a Single-Criterion Parameter Query
Create a Multiple-Criteria Query
Demo - B2: Creating a Query with Multiple Parameters
Create a Wildcard Query
Demo - B3: Using a Wildcard in a Parameter Query
Topic C: Using Action Queries
Types of Action Queries
Use an Append Query
Demo - C1: Adding Records to a Table with an Append Query
Use a Delete Query
Demo - C2: Deleting Records with a Delete Query
Use an Update Query
Demo - C3: Modifying Records with an Update Query
Use a Make Table Query
Demo - C4: Creating a Make Table Query
Unit 16 Review

Unit 17 - Macros
Topic A: Creating, Running, and Modifying Macros
Topic A: Creating, Running, and Modifying Macros
Sample Macro
The Macro Tools | Design Tab
Demo - A1: Creating and Running a Macro
Demo - A2: Modifying a Macro
Topic B: Attaching Macros to the Events of Database Objects
The Event Tab
Demo - B1: Attaching a Macro to the Open Event of a Form
Attach Macro to Command Button
Demo - B2: Attaching a Macro to a Command Button
Unit 17 Review

Unit 18 - Advanced Macros
Topic A: Creating Macros to Provide User Interaction
Sample Macro with a Condition
Create a Data Validation Macro
Demo - A1: Creating a Data Validation Macro
Create a Data Entry Macro
Demo - A2: Creating a Data Entry Macro
Topic B: Creating Macros that Require User Input
Macro to Run a Parameter Query
Demo - B1: Creating a Macro that Runs a Parameter Query
Topic C: Creating AutoKeys and AutoExec Macros
The AutoKeys Macro
Demo - C1: Creating an AutoKeys Macro
Create an AutoExec Macro
Demo - C2: Creating an AutoExec Macro
Topic D: Creating Macros for Data Transfer
The ImportExportData Action
Demo - D1: Importing a Database Object by Using a Macro
Export Data to a Spreadsheet
Demo - D2: Exporting Data to a Spreadsheet by Using a Macro
Unit 18 Review

Unit 19 - Importing, Exporting, and Linking
Topic A: Importing Objects
Import Objects from a Database
The Import Objects Dialog Box
Demo - A1: Importing Multiple Objects
Import Objects from Excel
Demo - A2: Importing an Object from Excel
Manage Data Tasks
Demo - A3: Using a Saved Import Specification
Fixed Width vs. Delimited Format
Demo - A4: Importing a CSV File
Topic B: Exporting Objects
Export Objects from a Database
The Export Table Dialog Box
Demo - B1: Exporting an Object
Demo - B2: Using a Saved Export Specification
Topic C: Working with XML Documents
Export as XML
The Export XML Dialog Box
The Import XML Dialog Box
Demo - C1: Exporting and Importing XML Documents
Export with an XSL File
Demo - C2: Exporting to an XML Document with an XSL File
Publish as PDF or XPS
Demo - C3: Saving a Table as an XPS File
Topic D: Linking Access Objects
Link a Table
Demo - D1: Linking to an Access Table
Update a Link
Linked Table Manager
Demo - D2: Updating Links
Link to an Excel Workbook
Demo - D3: Linking to an Excel Workbook
Topic E: Using Hyperlink Fields
Create a Hyperlink Field
Demo - E1: Creating a Hyperlink Field
The Insert Hyperlink Dialog Box
Demo - E2: Inserting Data in a Hyperlink Field
Modify Hyperlink Data
Demo - E3: Modifying Data in a Hyperlink Field
Unit 19 Review

Unit 20 - Database Management
Topic A: Optimizing Resources
Convert to a Prior Version
Demo - A1: Converting a Database to a Prior Version
The Performance Analyzer
Performance Analyzer Results
Demo - A2: Analyzing Performance
Split a Database
Demo - A3: Splitting a Database
Compact and Repair a Database
Demo - A4: Using the Compact and Repair Database Utility
Back Up the Active Database
Demo - A5: Backing up a Database
Topic B: Protecting Databases
Encrypt and Password-Protect
Demo - B1: Encrypting a Database with a Password
Remove Password and Encryption
Demo - B2: Removing a Password and Encryption
Topic C: Setting Options and Properties
The Access Options Dialog Box
Demo - C1: Setting Access Options
Database Properties Dialog Box
Demo - C2: Creating and Populating Database Properties
Unit 20 Review
Course Closure