Access 2016 Advanced

Develop your Access 2016 skills. Do you want to use Access rationally and professionally to solve database tasks, and do you want knowledge of the more advanced functions in Access? Then this thorough course will be something for you. The course includes many practical assignments.

Prior skills

The participants must possess skills equivalent to our Access 2016 Basic course.

Contents

Database design

• Design, create and edit a database with advanced relationships
• To normalize a database

Tables

• Field properties, field layout and database presentation

Queries

• Create and use queries
• Calculations and formulas in queries
• To relate tables and analyze data in a query
• Make Table, Append, Update, Crosstab, and Delete queries
• Parameter queries

Forms

• Design, create and use forms
• Create and use subforms
• Edit data in tables and forms
• Controls in forms
• Design and create forms for other users
• Forms based on queries
• Forms with macros

Formulas in forms

• DLOOKUP
• IIF

Reports

• Design, create and use reports

Print

• Print queries, forms and reports

Data import

• Data import from Excel, text files and Access

Access in the cloud

• Demonstration of Access Web Apps on SharePoint 2016
• Save in the cloud and share with others on OneDrive and SharePoint
• Upload Access tables to SharePoint as Lists
• Download SharePoint lists to Access

Courseware

Instructor

The course is provided by an experienced instructor from Teknologisk Instituts instructor network.