Access Level 2
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.