Access 2013 Intermediate

Learn by doing—not watching—with interactive simulations.

103 users

Course Includes

Certificate of Achievement
Interactive Tutorials
Skills Assessments
Student manual, instructor guide, & practice files

What you'll learn

Learn how to create a relational database with multiple tables.
Create powerful queries to find, update, append, and delete records.
Add professional forms and reports to your database.
Analyze and summarize database information with queries and reports.

Try sample lessons in the course outline shown below!

Proven Learning Method

Skill	Assess	Learn	Verify
Access 2013 Intermediate	Complete Course to Display Score
Creating Relational Databases
Table Relationships and Relationship Types	Click To Try Not Started	Not Started	Not Started
Create Relationships Between Tables	Not Started	Not Started	Not Started
Enforce Referential Integrity	Not Started	Not Started	Not Started
Print and Delete Relationships	Not Started	Not Started	Not Started
Work with Queries Subscribe to unlock
Create a Query
Hide, Remove and Sort Fields
Use AND and OR operators in a Query
Create a Multiple Table Query
Create a Calculated Field
Work with Expressions and the Expression Builder
Format Fields within Queries
Use an IIF Function
Summarize Groups of Records
Display Top or Bottom Values
Parameter Queries
Find Duplicate Records
Find Unmatched Records
Crosstab Queries
Delete Queries
Append Queries
Make-Table Queries
Update Queries
Work with Forms Subscribe to unlock
Create a Form with the Form Wizard
Create and Use a Form
Modify a Form in Layout View
Form Design View Basics
Change the Tab Order
Work with Control Properties
Work with Form Properties
Change a Controls Data Source
Create a Calculated Control
Change a Controls Default Value
Create a Subform
Work with and Modify Subforms
Create and Modify a Navigation Form
Work with Reports Subscribe to unlock
Create a Report
Use the Report Wizard
Use the Label Wizard
Work in Layout View
Format Fonts
Copy Formatting
Change Text Alignment
Insert a Logo and Background Image
Adjust Page Margin and Orientation
Add Page Numbers and Dates
Group and Sort
Summarize Data using Totals
Understand Report Sections
Advanced Topics Subscribe to unlock
Use Conditional Formatting
Work with Number Formatting
Use Themes
Import Information
Export Information
Link External Information
Mail Merge Records to Word
Use Hyperlink Fields
Database Object Dependencies
Compact and Repair a Database
Convert an Access Database
Back Up and Restore a Database
Password Protect a Database
Split a Database

Access 2013 Intermediate

Learn by doing—not watching—with interactive simulations.

Course Includes

Access 2013 Intermediate

Creating Relational Databases

Table Relationships and Relationship Types

Create Relationships Between Tables

Enforce Referential Integrity

Print and Delete Relationships

Work with Queries Subscribe to unlock

Create a Query

Hide, Remove and Sort Fields

Use AND and OR operators in a Query

Create a Multiple Table Query

Create a Calculated Field

Work with Expressions and the Expression Builder

Format Fields within Queries

Use an IIF Function

Summarize Groups of Records

Display Top or Bottom Values

Parameter Queries

Find Duplicate Records

Find Unmatched Records

Crosstab Queries

Delete Queries

Append Queries

Make-Table Queries

Update Queries

Work with Forms Subscribe to unlock

Create a Form with the Form Wizard

Create and Use a Form

Modify a Form in Layout View

Form Design View Basics

Change the Tab Order

Work with Control Properties

Work with Form Properties

Change a Controls Data Source

Create a Calculated Control

Change a Controls Default Value

Create a Subform

Work with and Modify Subforms

Create and Modify a Navigation Form

Work with Reports Subscribe to unlock

Create a Report

Use the Report Wizard

Use the Label Wizard

Work in Layout View

Format Fonts

Copy Formatting

Change Text Alignment

Insert a Logo and Background Image

Adjust Page Margin and Orientation

Add Page Numbers and Dates

Group and Sort

Summarize Data using Totals

Understand Report Sections

Advanced Topics Subscribe to unlock

Use Conditional Formatting

Work with Number Formatting

Use Themes

Import Information

Export Information

Link External Information

Mail Merge Records to Word

Use Hyperlink Fields

Database Object Dependencies

Compact and Repair a Database

Convert an Access Database

Back Up and Restore a Database

Password Protect a Database

Split a Database