Course Overview
This ILT Series course covers the basic functions and features of Access 2010. After an
introduction to database concepts and the Access environment and Help systems, students will
learn how to design and create databases. Then they will work with tables, fields, and records;
sort and filter data; and set field properties and data entry rules. Students will then learn to create
queries, forms, and reports.
Course Overview
Course Introduction 2m
Course Introduction
Unit 01 Getting Started 17m
Topic A: Database Concepts
Database Components
Relational Database
Topic B: Exploring the Access Environment
The Access Environment
Demo B1: Starting Access and Examining the Access Window
Opening Databases
Demo B2: Opening a Database
The Navigation Pane and Menu
Demo B3: Using the Navigation Pane
Open a Database Table
Demo B4: Examining a Database Table
Topic C: Getting Help
Access Help Online
Access Help Offline
Demo C1: Using Help
Unit 01 Review
Unit 02 Databases and Tables 56m
Topic A: Planning and Designing Databases
Planning a Database
Rules for Names
Using a Database Template
Demo A2: Creating a Database from a Template
Creating a Blank Database
Demo A3: Creating a Blank Database
Topic B: Exploring Tables
Views for Tables
Datasheet View
Demo B2: Examining a Table in Datasheet View
Navigating in Datasheet View
The Record Selector
Demo B3: Navigating a Table in Datasheet View
Table in Design View
Demo B4: Examining a Table in Design View
Topic C: Creating Tables
Demo C1: Creating a Table from a Table Template
Creating Tables in Design View
Demo C2: Creating a Table in Design View
Demo C3: Adding Fields and Descriptions to a Table
Setting the Primary Key
Demo C4: Setting the Primary Key
The Save As Dialog Box
Demo C5: Saving the Table
Adding a Record
Demo C6: Adding a Record
The Paste Table As Dialog Box
Demo C7: Copying, Modifying, and Deleting a Table
A Composite Key
Demo C8: Creating a Composite Key
Demo C9: Using the Data Type Gallery
Unit 02 Review
Unit 03 Fields and Records 39m
Topic A: Changing the Design of a Table
Ineffective Field Names
Demo A1: Modifying Field Names
Selecting a Field
Deleting and Inserting Fields
Demo A2: Deleting and Inserting Fields
Moving a Field
Demo A3: Moving a Field
Using the Attachment Data Type
The Attachments Dialog Box
Demo A4:Using the Attachment Data Type
Demo A5: Adding a Totals Row
Topic B: Finding and Editing Records
The Find and Replace Dialog Box
Demo B1: Finding and Replacing a Value
Undoing Changes
Demo B2: Undoing Changes
Topic C: Organizing Records
Sorting Records by a Single Field
Demo C1: Sorting Records by a Single Field
Sorting Records by Multiple Fields
Demo C2: Sorting Records by Multiple Fields
Filter By Selection
Filter from the Shortcut Menu
Demo C3: Using Filter By Selection
Filter By Form
Demo C4: Using Filter By Form
Filter Excluding Selection
Demo C5: Using Filter Excluding Selection
Advanced Filter/Sort
Demo C6: Using Advanced Filter/Sort
Deleting Records
Demo C7: Deleting a Record
Unit 03 Review
Unit 04 Data Entry Rules 26m
Topic A: Setting Field Properties
Field Properties
Setting the Required Property
Demo A1: Setting the Required Property
Allow Zero Length Property
Demo A2: Using the Allow Zero Length Property
Field Size Property
Demo A3: Setting the Field Size Property
Append Only Property
The History Dialog Box
Demo A4: Setting the Append Only Property
Topic B: Working with Input Masks
Input Mask Definition: Sections
Creating an Input Mask
Demo B1: Creating an Input Mask
Using the Input Mask Wizard
Demo B2: Working with the Input Mask Wizard
Topic C: Setting Validation Rules
Creating a Validation Rule
Demo C1: Creating Validation Rules
Setting Validation Text
Demo C2: Setting Validation Text
Unit 04 Review
Unit 05 Basic Queries 36m
Topic A: Creating and Using Queries
Queries
The Simple Query Wizard
Demo A2: Using the Query Wizard
Creating Queries in Design View
Demo A3: Creating a Query in Design View
Saving and Running a Query
Demo A4: Saving and Running the Query
Sorting Query Results
Demo A5: Sorting Query Results
Filtering Query Results
Demo A6: Filtering a Query by Adding Criteria
Creating Queries from Filters
Demo A7: Creating a Query from a Filter
Topic B: Modifying Query Results and Queries
Editing Records in Query Results
Demo B1: Editing Query Results
Modifying the Query Design
Demo B2: Adding Fields to a Query
Searching for Null Values
Demo B3: Finding Records with Empty Fields
Topic C: Performing Operations in Queries
Using Comparison Operators
Demo C1: Using Comparison Operators
Using the OR Condition
Demo C2: Using the OR Condition
Using the AND Condition
Demo C3: Using the AND Condition
Wildcard Operators
Demo C4: Using the * Wildcard
Using Calculations
Demo C5: Using Calculations in a Query
Totaling a Group of Records
Demo C6: Totaling a Group of Records
Avg and Count Functions
Demo C7: Using the Avg and Count Functions
Demo C8: Using the Min and Max Functions
Unit 05 Review
Unit 06 Using Forms 29m
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 A1: Examining a Form
Using the Form Button
A Basic Form
Demo A2: Creating a Basic Form
The Form Wizard
Demo A3: Creating a Form by Using the Form Wizard
Topic B: Using Design View
Creating Forms in Design View
Demo B1: Creating a Form in Design View
Adding a Control
Demo B2: Adding Controls
A Property Sheet
Modifying Section Properties
Demo B3: Modifying Properties
Conditional Formatting
Demo B4: Applying Conditional Formatting
Topic C: Sorting and Filtering Records
Sorting Records
Demo C1: Using a Form to Sort Records
Filtering Records
Demo C2: Using a Form to Filter Records
Unit 06 Review
Unit 07 Working with Reports 28m
Topic A: Creating Reports
Print Preview
Demo A1: Examining a Report
Basic Reports
Demo A2: Creating a Basic Report
Using the Report Wizard
Sample Report Preview
Demo A3: Creating a Report by Using the Report Wizard
Sections in Design View
Demo A4: Creating a Report in Design View
Topic B: Modifying and Printing Reports
Modifying Reports
Demo B1: Modifying a Report in Design View
Layout View
Demo B2: Modifying a Report in Layout View
Grouping Records in a Report
Group, Sort, and Total Pane
Demo B3: Grouping, Sorting, and Filtering a Report
Adding Summary Fields
Summary Options Dialog Box
Demo B4: Adding Summary Fields by Using the Report Wizard
Modifying Report Layout and Style
Demo B5: Modifying the Layout and Style of a Report
The Print Preview Tab
Demo B6: Printing a Report
Unit 07 Review
Course Closure
Total Duration: 3h 54m