Microsoft Access 2016 - Introduction

Getting started with Microsoft Access

• Identify the components of the Access 2016 interface
• Understanding database terminology and relationships
• Using the new “tell me what you want to do” help and search feature of 2016
• Using the new insights smart lookup feature to access definitions or web content
• Planning and designing a database
• Learn about security warnings

• Constructing a new database
• Naming conventions
• Using Database Templates – New Templates and themes Introduced in 2016
• File formats

• Creating a table - using the table wizard.
• Field types and field properties
• Table relationships
• Formatting a table
• Table views
• Add, edit and delete records
• Search, browse and print records
• Format a table

• Creating and modifying a form
• Changing the theme of a form
• Understanding bound and unbound controls
• Adding fields, controls, images and logos to a form
• Using a form

• Understanding types of queries
• Creating a simple query – using the wizard
• Using wildcards and operators
• Running a query
• Viewing, sorting and filtering results
• Create and use multiple table queries
• Create and use a parameter query
• Exporting results to excel

• Creating a Report – design view
• Using the wizard
• Modifying placement, colours, fonts, headers & footers
• Create a report from an object
• Preview results
• Printing reports
• Printing reports to PDF