Microsoft Access 2013 Intermediate Level

Current Status

Not Enrolled

Price

$14.95

Get Started

or

Course Content

Expand All

Course Introduction to Intermediate Level 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Introduction to Intermediate Level

1.0 Enhancing Tables 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

1.1 Intro to Chapter 1

1.2 Applying Validation Rules & Validation Text

1.3 Activating the Lookup Wizard

1.4 Using Hyperlinks

1.5 Utilizing the OLE and Attachment Data Types

1.6 Creating a Multi-Field Primary Key

1.7 Running a Relationship Report

2.0 Using a Variety of Query Types 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

2.1 Intro to Chapter 2

2.2 Querying with Two or More Tables

2.3 Creating a Parameter Query

2.4 Creating an Append Query

2.5 Using the Make Table and Update Queries

2.6 Applying a Delete Query

2.7 Creating a Crosstab Query

2.8 Finding Duplicates

2.9 Finding Unmatched Data

2.10 Grouping Records

2.11 Showing Top Values

3.0 Enhancing Forms 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

3.1 Intro to Chapter 3

3.2 Setting Tab Stops and Forms

3.3 Adding Button to Forms

3.4 Drawing Elements and Inserting Graphics

3.5 Controlling Form Input Using Option Groups

3.6 Aligning and Distributing Controls

3.7 Changing the Default View of the Form

4.0 Enhancing Reports 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

4.1 Intro to Chapter 4

4.2 Adding a Calculated Field

4.3 Applying Conditional Formatting

4.4 Hiding Fields and Duplicates

4.5 Creating Backgrounds

4.6 Inserting Page Breaks and Creating Headers and Footers

4.7 Grouping and Sorting

5.0 Maintaining and Customizing the Database 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

5.1 Intro to Chapter 5

5.2 Examining the Database Object Relationships

5.3 Documenting the Access Database

5.4 Protecting Data with a Password

5.5 Creating Custom Ribbon Tabs

5.6 Establishing Startup Options and Custom Icons

5.7 Customizing the Navigation Pane

5.8 Changing te Default Save Location