Microsoft Access 2007 Basic and Intermediate

 

 

Objective:

Participants will understand the concept of database. Using Access create tables, queries, forms and reports.

Course Outline

  1. Getting Started
  • Microsoft Office Toolbar
  • The Ribbon
  • Quick Access Toolbar
  • Navigation
  • Tabbed Document Window Viewing
  1. Database Term
  1. Creating a New Database
  • New Database
  • Database Templates
  1. Create a Table
  • Table Views
  • Adding New Fields
  • Data Types
  • Types of fields properties
  • Setting Number format
  • Setting Date/Time format
  • Setting Yes/No format
  1. Working with a Table
  • Moving around in the datasheet view
  • Edit Records
  • Delete records
  • Changing  table structure
  • Delete Table
  • Rename Table
  1. Edit a Table
  • Changing view to datasheet view
  • Change  Font
  • Change  Cell Effects
  • Move a Column
  • Hide/Unhide Column
  • Freeze/Unfreeze column
  1.  Keys
  • Primary Key
  1. Table Relationships
  • One-to-One Relationship
  • One-to-Many Relationship
  • Creating a Table Relationship
  • Print a Table Relationship Report
  1. Managing Data
  • Add Records to a Table
  • Find and Replace
  • Totals
  • Sort Records
  • Filter
  1. Querying a Database
  • Query Wizard
  • Query Design Feature
  • Query Criteria
  1. Designing Forms
  • Form Views
  • Create a Form
  • Form Wizard
  1. Reports
  • Report Views
  • Create a Report
  • Report Wizard
  • Print a Report
  • Print a Report