Microsoft Access 2016 Advanced

Microsoft Access is a powerful visual tool for designing and developing database applications. Learning how to use Microsoft Access is an investment in both your personal and professional life. You learn to develop and support robust Access systems, manipulate and query data, develop forms, design sophisticated data analysis reports and upsize Excel spreadsheet.
 

Learn for less with 1Training discount courses online! You’ll love 1Training’s excellent quality, competitive prices, and first class learner support. With this excellent discount course you can expect professional qualification, which will enable you to enhance your CV in no time, and for less!
 

What skills am I going to get from this course?
✓ By enrolling to this course, you’ll be able to create, edit and update databases.
✓ Logging in to this course, you’ll learn master key concepts of DBMS.
✓ This course will gain your knowledge in SQL.
✓ In this course, you’ll learn how to create forms, queries & reports.
✓ Having this course will gain best database management skills.
✓ In this course, you’ll learn about mathematical calculations and functions.
✓ On completion of this course, you’ll learn advanced features in MS Access.
✓ At the end of this course, you’ll become expert in Database management system.


Course Duration: 
Learners will have 365 days access to their chosen course. The course is self-paced so you decide how fast or slow the training goes. If you need to extend your course access duration, it can be done at any time by extending your subscription.

COURSE CURRICULUM
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


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


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


How will I be assessed?
At the end of the course learners will take an online multiple-choice question assessment test. This online multiple-choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
Upon successful completion of this course, all learners will be awarded a FREE e-certificate (PDF format), and can also pay only £19 to receive a printed version of the certificate if they wish.


What Certification am I going to receive?
Those who successfully pass this course will be awarded a Microsoft Access 2016 – Advanced Level Certificate. Anyone eligible for certification will receive a FREE e-certificate with NO additional cost.