Access 2007 Foundation

This course has been superseded

We suggest the following instead:
Access 365 - Part 1

Course Description

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2007 relational database application.
1 Day
Contact us for pricing
 

Prerequisites

Participants should have completed an Introduction to Windows 2000/XP/Vista or possess equivalent knowledge before starting this course.

Starting Out

What is Microsoft Access?
What’s New in Access 2007?
Basic Terminology
Opening Microsoft Access
Interface Overview
Closing Microsoft Access

Using the Getting Started Window

Overview of the Window
Navigating Through the Window
Creating a Database from a Template
Creating a Blank Database

The Trust Center

Warnings You May See when Opening a Database
Enabling Content
About Digital Signatures
About Trusted Locations
Opening the Trust Center
Assigning a Password to your Database

Getting Help

Opening the Help Screen
Overview of the Help Screen
Online Help vs. Offline Help
Searching for Help

Using the Quick AccessToolbar

About the Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar

Basics of Ribbons

About Ribbons
Opening Dialogue Boxes from the Ribbon
About the Office Menu

The Home Ribbon

Views
Clipboard
Font
Rich Text
Records
Sort and Filter
Find

Create Ribbon

Tables
Forms
Reports
Other

External Data Ribbon

Import
Export
Collect and Data
SharePoint Lists

Database Tools Ribbon

Macro
Show/Hide
Analyze
Move Data
Database Tools

First Steps

Planning a Database
Creating a Database from a Template
Creating a Blank Database
Using Database Objects
Setting Navigation Options

About Records

What is a Record?
Navigation Tips
Adding Records
Editing Records
Deleting Records
E-Mailing Records
Printing Records

Creating a Table

About Tables
Creating a Table
Entering Data into a Table
Formatting a Table

Formatting Text

Using the Zoom Box
Selecting Data
Cutting, Copying, and Pasting
Using the Format Painter
Using Undo and Redo
Checking your Spelling

Creating Forms

What is a Form?
Bound vs. Unbound Controls
Creating a Form with the Wizard
Using Design View to Modify Your Form
Using Forms

Creating Queries

What is a Query?
Creating a Query with the Wizard
Using Design View to Modify a Query
Using Queries

Reports

What is a Report?
Creating a Report with the Wizard
Using Design View to Modify a Report
Using Reports

Sorting and Filtering Data

Using Find and Replace
Sort Ascending or Descending
Toggling Filter
Using Selection Sort
Using Advanced Sort

Viewing Data

Using the View Menu
Using the View Icons
Using the Tabs
Closing Individual Tabs

Printing a Database Object

Using the Quick Print Icon
Using the Print Menu
Using Print Preview
Using the Print Preview Ribbon
Printing vs. Exporting
Microsoft Access