AtoZComputer
Office Training

Site Menu                

 

 

Microsoft Access Professional 2007

Microsoft Approved Courseware
 This text is a comprehensive instructional tool designed for users of Microsoft Access. This self-paced, self-instructional guide provides you with all the instruction necessary to become a knowledgeable user of this popular database software.
 
 Features
 Comprehensive Review Exercises and hands-on activities placed throughout the text
 Beginning, intermediate, and advanced capabilities of Access
 Coverage of advanced features such as the Expression Builder, hyperlinks, and macros
 Also includes coverage of Access BASIC for advanced procedures
 Internet capabilities
  
 25 to 40 hours of instruction.

 
 Table of Contents
 
 Unit 1 Access Basics
 Lesson 1 Getting Started with Access
 Lesson 2 Using Access's Menus, Dialog Boxes and Help Feature
 Lesson 3 Creating a New Database
 Lesson 4 Entering and Editing Data
 Lesson 5 Creating and Using Basic Forms
 Lesson 6 Maintaining Data Integrity
 
 Unit 2 Managing Reports, Labels, and Relationships
 Lesson 7 Creating, Modifying, and Printing Basic Reports
 Lesson 8 Creating Mailing Labels
 Lesson 9 Relating Multiple Tables
 
 Unit 3 Finding Information
 Lesson 10 Sorting, Finding, And Filtering Figures
 Lesson 11 Basic Queries
 Lesson 12 Enhanced Queries
 Lesson 13 Creating Interactive Queries
 Lesson 14 Creating Multiple Table Queries
 Lesson 15 Using the Expression Builder and Building Summary Queries
 Lesson 16 Creating Advanced Queries
 
 Unit 4 Advanced Access Features
 Lesson 17 Creating Reports from Queries
 Lesson 18 Advanced Report Features
 Lesson 19 Advanced Form Features and Hyperlinks
 Lesson 20 Creating Basic Macros
 Lesson 21 Creating Advanced Macros
 Lesson 22 Modifying Macros
 
 Unit 5 Access Power Features
 Lesson 23 Writing Access Basic
 Lesson 24 Editing Access Basic Statements
 
 Appendix: Access and the Internet
 Glossary
 Index

 
Special Notes!          

Short Term Programs
Year Long Programs

Computerized Office Skills
Medical Insurance Billing specialist
Health Unit Coordinator.

 Phone: 800-386-3171
 Phone: 360-876-5540
 Fax:    360-876-5562
 
 Our hours are:
 8:30 A.M. to 3:30 P.M.
 Monday through Thursday