Microsoft Access Intermediate Course – Classroom
Build on from the basics and learn to improve and customise tables, queries, forms and reports, and share Access data with other applications.
- All Courses
- Microsoft Office
- Microsoft Access
- Microsoft Access Intermediate Course – Classroom
Course Overview
You will improve and customise tables, queries, forms and reports, and share Access data with other applications.
This course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.
Price
Duration
1 Day
Training Options
Classroom
Microsoft Access Intermediate Course Content:
- Lesson 1: Promoting Quality Data Input
- Lesson 2: Improving Efficiency and Data Integrity
- Lesson 3: Improving Table Usability
- Lesson 4: Creating Advanced Queries
- Lesson 5: Improving Form Presentation
- Lesson 6: Creating Advanced Reports
Upon successful completion of this course, students will be able to:
- Provide input validation features to promote the entry of quality data into a database
- Organise a database for efficiency and performance, and to maintain data integrity
- Improve the usability of Access tables
- Create advanced queries to join and summarize data
- Use advanced formatting and controls to improve form presentation
- Use advanced formatting and calculated fields to improve reports
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
- Professional Microsoft Certified Trainer
- CPD Accredited Classroom training in Small Groups for Max Focus
- Only Microsoft Approved Courseware and Exercise Files are used
- Free Assessment of Skills prior to booking
- Certificate of Completion & Complementary 12 Months Post Course Support
- 100% Money Back Guarantee & Price Match Guarantee
- Bespoke Courses & Group Discounts from £89 per person
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Office Access.
It is suggested that you have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
To meet this prerequisite, you can take the following course:
- Microsoft Access Introduction
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.
The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Choose Your Date & Location
Testimonials
Take Yourself Further With Infero
Top Microsoft Access FAQs
- Start: 9:00am
- Break: 11:00am
- Lunch: 1:00pm
- Break: 3:00pm
- Finish: 5:00pm