MicroKnowledge Inc.
Contact | Driving Directions | Home
Current Course Calendar
Quick Learn Sessions
Course Descriptions
Quick Learn Sessions
Basic Skills
Business Programs
Business Skills
Databases
Desktop Publishing & Graphics
Internet and Communications
Operating Systems
Presentations
Programming
Report Writing
Spreadsheets
Web Page Design
Word Processing
Customer Appreciation Training
Register for a Class
Customized Training
Proprietary Technology Training
On Site Training
About On Site Training
MobileKnowledge
Consulting Services
Technical Writing
Employment Opportunities
About Us
Site Map
Create Profile
Request Information
Support
Download Course Training Files

Access 2007 Basic

Explore the Access environment, plan and create databases, add fields and records, set properties, create simple queries, forms and reports.

Recommended preparation: Welcome to Windows XP or Welcome to Windows Vista or equivalent knowledge.

Register for a class
Personalized training and consulting is available upon request.

Lesson 1: Getting started

  • Database concepts
  • Exploring the Access environment
  • Getting help

Lesson 2: Databases and tables

  • Planning and designing databases
  • Exploring tables
  • Creating tables

Lesson 3: Fields and records

  • Changing the design of a table
  • Finding and editing records
  • Sorting and filtering data

Lesson 4: Data entry rules

  • Setting field properties
  • Working with input masks
  • Setting validation rules
  • Using indexes
 

Lesson 5: Simple queries

  • Creating and using queries
  • Modifying query results
  • Using operators in queries

Lesson 6: Using forms

  • Creating forms
  • Using forms for data entry
  • Finding, sorting, and filtering data

Lesson 7: Working with reports

  • Creating reports
  • Sorting and grouping report data
  • Modifying and printing reports

 

 

 

 

 

Dates:
August 17
8:30-4:30

September 14
8:30-4:30

October 12
8:30-4:30

November 16
8:30-4:30


Price:
$169 for open enrollment courses, when available.

Length: 8 Hours

Quick Links

Request information

Register for a class

Get follow-up support

Create a My MicroKnowledge profile

Get Directions