MOS: Microsoft Office Access 2016 - Course

Instruction Language: English
Application Language: English
This course serves as a preparation for the examination MOS - Microsoft Office Access 2016 (Exam 77-730). You will get familiarised in it with the terminology concerning relational databases and with the basics of working in the Access program. You will try various ways of creating tables and setting the properties of their fields. You will learn to further analyse the data in tables through select queries, including the creation of calculated fields in them. You will set relations between tables and ensure their referential integrity. You will also familiarise yourself with an easy way of creating simple forms and reports. You will learn to create calculated fields in queries that operate with functions. You will create totals queries and parameter queries. You will familiarise yourself with the properties of table joins and will examine how they can affect the result of queries. You will create forms in the Design view and will learn to insert calculated fields into them. You will also design and edit reports and will learn to perform various calculations in them. You will also learn how to insert controls into forms and reports, including subforms and subreports.

Product code: EN-MOS16-Acc


£ 32.00
£ 38.72 incl. VAT info
  • Introduction to databases and their objects
  • Copying and importing external data into tables
  • Crosstab query
  • Automatic creation of forms
  • Editing created reports
  • Access environment
  • Automated data import and export
  • Parameter query
  • Design View of forms
  • Advanced report options
  • Analysis of relationships between tables
  • Navigation in tables
  • Append and update queries
  • Tab order of form controls
  • Setting reports before printing them
  • Relationships between tables
  • Advanced field data types
  • Make table and delete action queries
  • Sorting and filtering data in forms
  • Grouping and summarising data in reports
  • Referential integrity
  • Totals
  • Joining tables for the purpose of a query
  • Form with a subform
  • Navigation in a database
  • Searching for records and editing them
  • Join properties in queries
  • Subform insertion in the Design view
  • Navigation Pane
  • Sorting and filtering data in tables
  • Creating manual joins in queries
  • Restricting data editing in forms
  • Creating a table in the Datasheet View
  • Design view of tables
  • Object dependencies and properties inheritance
  • Creating a form collecting query parameters
  • Access privacy and security
  • Restricting data input in tables
  • Select queries
  • Splitting a database
  • Lookup columns in tables
  • Creating a select query
  • Report creation
  • Editing a lookup column
  • Expressions in queries
  • Exporting data from a database
  • Use of functions in more complex expressions
  • Import and export in XML format
  • Aggregate queries
  • Criteria in select queries
  • Calculated fields in queries
Products specifications

System Requirements

ProductType Single courses
ApplicationLanguage English
EducationLanguage English