Access 2007 Intermediate

This course has been superseded

We suggest the following instead:
Access 365 - Part 2

Course Description

You have the basic skills needed to work with Microsoft Office Access 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.
1 Day
Contact us for pricing
 

Prerequisites

To ensure the successful completion of the Intermediate course, the completion of the Foundation course or equivalent knowledge is recommended.

Using My Computer within Access

Navigating with My Computer
Performing Basic Tasks with My Computer
Changing Views with my Computer
Using the My Places Toolbar

Database Management

Compact and Repair a Database
Backing up Your Database
Editing Database Properties

Saving Your Files

Using the Save As Dialogue
Using the Save As Menu
Using File Properties
Using AutoRecover

Exporting Files

Exporting to PDF or XPS
Exporting to Word or Excel
Exporting to Other Destinations
Using Saved Exports
Exporting to a CAB File
Exporting to Older Versions of Access

Linking Files

Linking to an Excel Spreadsheet
Linking to Another Database
Linking to a SharePoint Site
Other Types of Linked Documents
Creating a Hyperlink

Customizing Tables

Understanding Field Properties
Adding a Primary Key to a Table
Indexing a Field
Inserting, Deleting, and Moving Fields
Importing a Table from another Source

Formatting Tables

Formatting Number Fields
Formatting Text Fields
Adding Field Descriptions
Changing Field Data Types
Adding Captions

Controlling Table Data Entry

Setting a Default Value
Setting a Required Value
Creating and Using Input Masks
Creating and Removing Table Relationships

Managing Table Data Entry

How to Validate Data
Creating a Lookup Field
Modifying a Lookup Field
Creating a Value List
Modifying a Value List

Basic Form Controls

Adding a Control
Using the Control Wizard
Cutting, Copying, Pasting, and Moving a Control
Formatting a Control

Advanced Form Controls

Modifying a Control’s Properties
Changing a Control’s Data Source
Changing a Control’s Default Value
Creating a Calculated Control
Using Form Properties

Formatting Your Form

Formatting Gridlines
Modifying the Font
Adding Logos
Changing the Layout

Formatting Controls

Changing the Color of a Control
Using Control Properties
Aligning Controls
Applying Special Effects

Formatting Records

Modifying Fonts
Using AutoFormat
Using the Formatting Ribbon
Using the Arrange Ribbon

Organizing Report Data

Adding and Removing Fields
Using Report Sections
Changing Section Properties
Grouping and Sorting in a Report
Changing Group Properties
Using Calculated Controls in a Report

Formatting Reports

Formatting Gridlines
Modifying the Font
Adding Logos
Changing the Layout
Using AutoFormat

Common Report Tasks

Adding a Photo
Adjusting Page Properties
Adding Headers and Footers
Adding Page Numbers
Using the Label Wizard

Basic Queries

Review of Queries
Creating a Query
Sorting a Query
Filtering a Query
Hiding Fields
Using AND OR Operators
Use of IIF Functions

Multiple Table Queries

Creating a Multiple Table Query
Creating a Calculated Field
Using the Expression Builder
Using Queries to Summarize

Using Advanced Queries

Creating a Parameter Query
Using Parameter Queries
Creating Crosstab Queries
Using Crosstab Queries
Using Make-Table Queries

Management Queries

Append Queries
Delete Queries
Update Queries
Exporting Queries
Microsoft Access