MS Access 2016 Package – Introduction, Intermediate and Advanced

Description

• Begin with the basics of working in the Access program.
• Familiarise yourself with the key database terminology.
• Try various ways of creating tables and practise setting the properties of their fields.
• Learn to further analyse the data in a table through select queries, including the creation of calculated fields.
• Understand how to set relations between tables and ensure their referential integrity.
• Discover an easy way to create simple forms and reports.

• Learn to create calculated fields in queries that operate with functions.
• Practise creating totals queries and parameter queries.
• Study the properties of table joins and examine how they can affect the result of queries.
• Learn to create forms in the Design view and insert calculated fields into them.
• Design and edit reports, and learn to perform various calculations in them.
• Continue on to learn how to insert controls into forms and reports, including subforms and subreports.

• Begin the advanced course by familiarising yourself with action queries.
• Examine different types of queries in the SQL view and get acquainted with the essential clauses of this language.
• Learn to create and use macros to automate your work with databases.
• Explore the importing and exporting of objects and their data.
• Look at the printing options of different objects in detail.
• Study the normalisation of data.
• Examine the options of navigation in a database.

• This great value three course package will take you from beginner to advanced level.
• Courses are led by a virtual teacher with voice and/or written text instruction.
• A variety of different teaching tools are utilised including lectures using illustrative simulation, exercises and quizzes.
• A pre-assessment and final test will track the learning journey across the courses.
• Individual tasks are corrected if necessary to ensure that students can identify and learn from mistakes.
• Progress and results are recorded and stored, making it easy to pick up where you left off at each study session.
• A search function enables you to tailor your own learning and study program.
• If databases play a part in your current or potential job role, this course package contains all you need to achieve full proficiency.
• An impressive addition to any CV, especially when applying for roles in administration and business.

• MS Access 2016: Introduction
• MS Access 2016: Intermediate
• MS Access 2016: Advanced