This course is not currently offered by Global Knowledge. Information here is provided for reference only.

This course covers the essential concepts of Access 2007, provides guidance on how to use the Access interface, and provides the training students need to create a database from scratch. Students will concentrate on designing and editing tables, finding and filtering data, printing data, and creating relationships between tables. This course provides information on how to present the data contained in your database using Forms, Queries, and Reports.

For this course, training is performed on student's equipment. We provide the software and data files for the training.

What You'll Learn

• Explore Access
• Create tables
• Work with tables
• Edit tables
• Find and filter data
• Print Data
• Create Relationships
• Use Simple Queries
• Modify Query Results
• Analyze Tables
• Create Basic Forms
• Create Basic Reports

Who Needs to Attend

Business users who need training on Access 2007

Prerequisites

An understanding of Windows

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Exploring Access

• Working with Access
• Starting Access
• Using the interface
• Using the Office Button
• Opening an Existing Database
• Using the Ribbon
• Using Contextual Command Tabs
• Using the Quick Access Toolbar
• Using the Mini Toolbar
• Using Database Objects
• Using the Navigation Pane
• Opening Database Objects
• Using Tabbed Documents
• Closing Tabbed Documents
• Using the Status Bar
• Using the Options Dialog Box
• Closing a Database
• Exiting Access

2. Creating Tables

• Using Database Templates
• Creating a New Database
• Designing Tables
• Creating a Table in Datasheet View
• Creating a Table in Design View
• Adding Fields
• Assigning Data Types
• Using Multi-Valued fields
• Adding a Field Description
• Setting a Primary Key
• Saving a New Table

3. Working with Tables

• Using Datasheet View
• Navigating Fields in Tables
• Using Field Templates
• Adding Records
• Moving through Records
• Selecting Records
• Editing Records
• Saving Records
• Deleting Records
• Displaying a Totals Row

4. Editing Tables

• Changing the Row Height
• Changing the Column Width
• Changing the Row Height
• Changing a Font Attribute
• Changing a Cell Effect
• Using Alternate Background Colors
• Selecting a Column
• Moving a Column
• Hiding a Column
• Unhiding a Column
• Freezing a Column

5. Finding and Filtering Data

• Sorting Records
• Finding Specific Records
• Finding Records using Wildcards
• Using Replace
• Using Filter By Selection
• Applying/Removing a Filter
• Using Filter Excluding Selection
• Using the Search Box
• Using Quick Filters
• Using AutoFilter

6. Printing Data

• Printing Table Data
• Changing the Page Setup
• Using Print Preview
• Printing Selected Records

7. Creating Relationships

• Using Related Tables
• Creating a Relationship between Tables
• Setting Referential Integrity
• Viewing Subdatasheets
• Deleting a Join Line

8. Using Simple Queries

• Using Queries and Recordsets
• Using the Simple Query Wizard
• Creating a Query in Design View
• Opening a Query
• Adding a Table to a Query
• Joining Tables in a Query
• Running a Query

9. Modifying Query Results

• Sorting a Query
• Adding Criteria to a Query
• Hiding a field in a Query
• Displaying a Totals Row in a Query
• Adding a Record using a Query
• Printing a Query

10. Analyzing Tables

• Analyzing a Table
• Using Relationships in Splits
• Using the Table Analyzer Wizard
• Using the Performance Analyzer

11. Creating Basic Forms

• Using Forms
• Using the Form Button
• Adding a Record Using a Form
• Using the Calendar for Date Picking
• Using the Form Wizard
• Viewing Records in a Form
• Printing Records in a Form
• Basing a Form on a Query

12. Creating Basic Reports

• Using Reports
• Using the Report Button
• Using Print Preview - Reports
• Printing Pages of a Report
• Using the Report Wizard
• Changing Views in a Report
• Grouping and Summarizing Report Data
• Basing a Report on a Query