100 megs data gift for every genuine quote requested

Access 2016 is the database application in the Microsoft Office suite. A relational database application such as Microsoft Office Access 2016 can help you and your organisation collect and manage large amounts of data.

The Microsoft Access 2016 Beginner training course will show the users how it can be applied as a personal data management tool (for your use alone) or as a construction set to develop applications for an entire department or organisation.

This dynamic training course is now available in Gauteng, Durban and Cape Town.

Contact us today for a group quote.

Excel

Word

PowerPoint

Outlook

Access

Project

Who Should Attend

This course is for students with no prior knowledge of Microsoft Access or relational databases.

This course is designed to teach you the concepts of relational database architecture and knowledge for building an Access database.

During this course, you will learn how to build tables to store data in related tables, create forms for data entry, create and execute queries to analyse data and produce printable reports.

If you have inherited an Access database that you have to learn how to manage and maintain or simply just need to know how to work with an Access database, then this course is for you.

At the completion of this course, students will gain a solid understanding of the relational database concepts and terminology used throughout Microsoft Access.

Students will also be able to build a simple database, manipulate data via forms and create basic queries and reports.

Learning Outcomes - Microsoft Access 2016 Beginner Training

Upon successful completion of this course, participants will be able to:

  • Navigate within the Microsoft Access application environment, create a simple database, and customise access configuration options.
  • Organise and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Course Content - Microsoft Access 2016 Beginner Training

Lesson 1: Getting Started with Access
Topic A: Orientation to Microsoft Access
Topic B: Create a Simple Access Database
Topic C: Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data
Topic A: Modify Table Data
Topic B: Sort and Filter Records

Lesson 3: Querying a Database
Topic A: Create Basic Queries
Topic B: Sort and Filter Data in a Query
Topic C: Perform Calculations in a Query

Lesson 4: Using Forms
Topic A: Create Basic Access Forms
Topic B: Work with Data on Access Forms

Lesson 5: Generating Reports
Topic A: Create a Report
Topic B: Add Controls to a Report
Topic C: Enhance the Appearance of a Report
Topic D: Prepare a Report for Print
Topic E: Organise Report Information
Topic F: Format Reports