Advanced Microsoft Access 2016 Training

To employers, you’re only as good as you CV…

To prove that you can use Microsoft Access, the most popular database management software, get a recognised qualification from Study365. Enhance your CV and give yourself an advantage.

Who is it for?

• This course is ideally suited for learners working in a web-based environment or those working in an office role.
• Whether you are new to Access or an advanced user, this training will cover what you need to know as efficiently as possible. However, this course is designed for learners who have a thorough understanding of the basic user features of Microsoft Access 2016, and are interested in learning introductory level administrator skills.

Course Description:

This online training course is comprehensive and is designed to cover the topics listed under the curriculum. This course has been designed for 15 guided learning hours.

Course Curriculum

1. Microsoft Access 2016 - Beginner

• Introduction To Ms Access                          
• Creating Tables & Setting Up Properties                               
• Queries                               
• Creating Forms & Reports                           
• Working With Macros, Integrating Access With Office Suite                         
• Database Management               
• Exercise Files- Microsoft Access 2016                     

2. Microsoft Access 2016 - Advance Questions In Depth

• Introduction To Access 2016 Advance Questions In Depth                            
• Understanding Queries                
• Query Criteria                   
• Parameters Queries                      
• Use Mathematical Operations And Functions                    
• Summarise Data With Aggregate Functions                         
• Dates, Time And Numbers Functions                     
• If Function And Calculations                       
• Records And Database                 
• Explore The Basics Of Sql                             
• Values, Database And Markup                  
• Exercise Files- Access 2016 – Advance Questions In Depth                           

3. Microsoft Access 2016 - Advance Tricks And Tips

• Introduction To Trick And Tips Of Access 2016                    
• Explore Startup Options                               
• Embed Queries In Reports                          
• Create A Back End And Front Ends                          
• Build The Forms And Reports                    
• Add Customised Functions And Visual Basics                      
• Exercise Files- Access 2016 Advance Tips & Tricks

Course Duration:

You will have 12 Months access to your online study platform from the date you purchased the course. The course is self-paced so you decide how fast or slow the training goes. You can complete the course in stages revisiting the training at any time.

Method of Assessment:

At the end of the course, learners will take an online multiple choice question assessment test. The online test is marked straight away, so you will know immediately if you have passed the course.

Certification:

Successful candidates will be awarded a certificate for “Advanced Microsoft Access 2016 Training”.

Entry Requirement:

• Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

Career Path:

This Qualification is helpful for any Office job, such as:

• Admin Assistant
• PA
• Secretary
• Administrator
• Office Manager
• Business Developer
• IT Technician
• Web Developer
• Accountant