Quick Source Learning | Quick Source Learning | Access 2003 Basic Course

Access 2003 Basic Course

Microsoft Access

 


"

 

A03B

The Quick Source eLearning Series combines three levels of training: Learn It, Try It, and Evaluation. The Learn It section includes high quality video that shows you everything the instructor is teaching. The Try It section allows you to practice what you have learned right in our course. There is no need to switch between the course, and the software that you are learning. The Evaluation section gives you the ability to test your knowledge and receive immediate feedback.


Topics covered in this course:

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

 

More in this category: Excel 2003 Basic Course »