• About
  1. Overview
  2. Philanthropy
  3. Testimonials
  4. Case Studies
  5. Service Area
  6. Site Map
  7. Privacy Policy
• Benefits
  1. Onsite Training
  2. Materials
  3. Follow-Up Guarantee
  4. Flat-Rate Pricing
  5. Custom Curriculum
  6. For Government Agencies
• Training Courses
  1. General Computing
  2. Microsoft 365
  3. Microsoft Word
  4. Microsoft Excel
  5. Microsoft Access
  6. Microsoft Outlook
  7. Microsoft Visio
  8. Microsoft Publisher
  9. Microsoft PowerPoint
  10. Microsoft Project
• Additional Services
  1. Slideshow Design
  2. Docs, Forms, Templates
  3. Database Development

training : microsoft access

essentials

This class provides participants with a basic introduction to Microsoft Access databases, covering simple tables, queries, forms, and reports.  Participants will create their own database for a fictitious customer listing and run reports for basic analysis and mailing address labels.  (Recommended Time: 2 Hours)

building queries

This class will show participants how to create advanced queries.  Queries that prompt for parameters, delete queries, append queries, and update queries will be the focus of this class.  Creating queries based on sub-queries will also be covered.  This class assumes prior knowledge of basic Access skills.  (Recommended Time: 2 Hours)

creating forms

This class will demonstrate to participants how forms can be created to support user-input and retrieve information.  Concepts such as text controls, graphics, function buttons, and sub-forms will be covered.  This class assumes prior knowledge of basic Access skills.  (Recommended Time: 2 Hours)

designing reports

This class provides participants with demonstrations on how to create appealing, powerful reports.  Covered topics include incorporating graphics into a report, using headers and footers, setting page size and margins, and using groups to subtotal your results.  This class assumes prior knowledge of basic Access skills, particularly queries.  (Recommended Time: 2 Hours)

additional topics of interest:

• tables, normalization, and relationships
• SQL server manager
• macros
• Visual Basic for Applications (VBA)
• importing and exporting data

P.O. Box 1582  Lodi, CA 95241  209‑610‑0651

Copyright 2024 Applied Office   Privacy Policy   Site Map  Forward Page