LANTEC Logo
Lantec | Course: Access Intermediate

Access Level 2

$275.00
1 days
Audience
Prerequisites

Description:

This course provides the concepts and skills for the advanced use of Microsoft Access. This includes how to create advanced queries, forms, and reports, how to create macros, and how to manage your databases.

Outline:

Chapter 1: Advanced Queries

  • Module A: Grouping and summarizing
  • Module B: Updating, deleting, and relationships
  • Module C: Indexing for performance

Chapter 2: Advanced forms

  • Module A: Subforms 
  • Module B: Advanced control types
  • Module C: Specialized form types

Chapter 3: Advanced reports

  • Module A: Subreports 
  • Module B: Advanced grouping
  • Module C: Advanced formatting 

Chapter 4: Macros

  • Module A: Creating basic macros
  • Module B: Using variables
  • Module C: Troubleshooting macros

Chapter 5: Database Management

  • Module A: Compact & Repair
  • Module B: Restoring a database
  • Module C: Other maintenance tasks

Scheduled Courses

This course isn't currently on the schedule, but we can add it. Just let us know.

Need to Request This Course On a Different Day?

LANTEC is very responsive to local client needs and unique or custom class demands. If you require a delivery date option for a class title on our schedule, please submit your specific request for immediate consideration. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.
Want to schedule it?


Hailay Nickens, Pelican State Credit Union

I appreciate Juan's approach and how he taught the class. He provided life experiences and examples to show/support what he was teaching.