
Access 2003 Basic
|
|
Approximate Length: 3 hours
|
Course Description
The Access 2003 QUICK Source Learning Series will show you the basics of how to use Access 2003. The QUICK Source Learning Series combines three levels of training: Teaching, Trying, and Testing. The teaching section includes high-quality video so you are able to see what the instructor is teaching you to do. The trying section allows you to practice what you have learned right in our program. There is no need to switch between our software and Access 2003. The testing section involves a variety of test questions with immediate feedback. Trainers can track user’s progress, view test scores, and print out reports.
Objectives
- Getting Started
- Starting and Exiting Microsoft Access
- Identifying the Parts of the Access 2003 Window
- Using the Task Pane
- Opening an Existing Database
- Identifying Parts of the Database Window
- Identifying Database Objects
- Using the Database Toolbar
- Database Views
- Sorting Database Objects
- Working with Object Groups
- Working with an Existing Database
- Opening a Recently Used Database
- Opening a Sample Database or Project
- Viewing and Changing Object Properties
- Viewing Information on Object Dependencies
- Saving Database Objects
- Backing up a Database
- Converting a Database
- Working with Database Objects
- Opening and Closing Database Objects
- Navigating in Datasheet and Form View
- Selecting Records and Fields in Datasheet View
- Adding, Deleting, and Saving Records
- Entering Data
- Sorting Data
- Filtering Data
- Editing Database Objects
- Copying Database Objects
- Moving and Copying Data
- Finding and Replacing Data
- Inserting a Hyperlink
- Modifying the Appearance of a Datasheet
- Checking Spelling
- Using AutoCorrect Features
- Tables and Forms
- Formatting a Table
- Copying Fields and Records in a Table
- Linking Tables
- Editing Table Relationships
- Creating a Form Using Form Wizard
- Creating a Form Using AutoForms
- Checking Forms for Errors
- Queries and Reports
- Creating a Query Using Query Wizard
- Adding or Removing a Table or Query
- Changing the Query Type
- Creating a Report Using Report Wizard
- Creating Reports with Charts
- Creating a Report Using AutoReports
- Viewing a Report
- Output and Extras
- Printing a Database Object
- Using Print Preview
- Merging Access Documents with Other Office Programs
- Searching for a File
- Using the Office Clipboard
- Creating Mailing Labels
- Using Undo/Redo
- Getting Help
- Using the Type a Question for Help Box
- Using the Help Task Pane
- Using the Office Assistant
- Hiding or Turning Off the Assistant
- Changing the Assistant
- Getting Help in a Dialog Box
- Getting Help from Office Online
- Printing a Help Topic
Lessons
- A03B1 - Getting Started
- A03B2 - Working with an Existing Database
- A03B3 - Working with Database Objects
- A03B4 - Editing Database Objects
- A03B5 - Tables and Forms
- A03B6 - Queries and Reports
- A03B7 - Output and Extras
- A03B8 - Getting Help
Certificates
Completion of this course (all lessons must be passed or completed) will earn credit towards the following certificate(s):