Quick Source Learning | Quick Source Learning | Access 2007 Basic Course

Access 2007 Basic Course

Microsoft Access

 

"


 

 

A07B

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

  • Introduction
  • Starting and Exiting Microsoft Access 2007
  • Identifying the Parts of the Access Window
  • Using the Ribbon
  • Using the Navigation Pane
  • Working with Tabs
  • Customizing the Quick Access Toolbar
  • Opening an Existing Database
  • Creating a New Database
  • Creating a New Database Based on a Template

Views and Database Objects

  • Introduction
  • Working with Database Objects
  • Saving a Database Object
  • Copying Database Objects
  • Using the Search Bar
  • Viewing Information on Object Dependencies
  • Working with Views
  • Navigating in Form, Datasheet, or Layout View

Tables

  • Introduction
  • Creating a New Blank Table
  • Adding a Field to a Table
  • Adding a Field to a Table in Design View
  • Selecting Records and Fields in Datasheet View
  • Adding a Record
  • Deleting a Record or Field
  • Setting or Changing Field Properties
  • Setting Table Properties
  • Creating Table Relationships
  • Editing Table Relationships

Data

  • Introduction
  • Entering Data
  • Sorting and Filtering Data
  • Importing Data
  • Enabling Rich Text Formatting in a Table
  • Formatting Text
  • Working with the Mini Toolbar
  • Moving and Copying Text
  • Using the Office Clipboard

Forms and Reports

  • Introduction
  • Creating a Form
  • Using the Blank Form Tool
  • Creating a Split Form
  • Creating a Report
  • Using the Blank Report Tool
  • Using the Group, Sort, and Total Pane
  • Adding a Field to a Form or Report

Queries and Extras

  • Introduction
  • Using the Query Wizard
  • Designing a Query
  • Changing the Query Type
  • Adding Items to a Query
  • Creating Labels
  • Using Undo and Redo
  • Finding and Replacing Data

Output

  • Introduction
  • Backing Up a Database
  • Converting a Database
  • Using Print Preview
  • Printing a Database Object
  • E-mailing an Object
  • Exporting Data to Another Access Database
  • Exporting Data to Excel
  • Exporting to Other Formats

Getting Help

  • Introduction
  • Using Access Help
  • Using the Help Table of Contents
  • Searching for Help Topics
  • Getting Help in a Dialog Box
  • Printing a Help Topic
  • Getting Help from Office Online
  • Displaying Access Keys
More in this category: Access 2007 Advanced Course »