Access 2019: Relational Database Management

Chapter 1: Advanced queries

Module A: Grouping and summarizing

Module B: Updating, deleting, and relationships

Module C: Indexing for performance

Module D: Specialized query types

Chapter 2: Advanced forms

Module A: Subforms

Module B: Advanced control types

Module C: Specialized form types

Chapter 3: Advanced reports

Module A: Subreports

Module B: Advanced grouping

Module C: Advanced formatting

Chapter 4: Macros

Module A: Creating basic macros

Module B: Using variables

Module C: Troubleshooting macros

Chapter 5: Importing and exporting data

Module A: Data exchange basics

Module B: Exchanging data with other Access databases

Module C: Exchanging data with Excel

Module D: Using Text and XML data files

Chapter 6: Database management

Module A: Compact & Repair

Module B: Restoring a database

Module C: Other maintenance tasks

Access 2019: Relational Database Management provides the concepts and skills for the advanced use of Microsoft Access 2019: How to create advanced queries, forms, and reports, how to create macros, how to import and export data, and how to manage your databases.

Students will benefit most from this course if they want to be an advanced user of Access 2019.

The course assumes students have completed Access 2019 Relational Database Design, or have equivalent skills in using Access.

Which Access series is right for me?

Our Relational Database Design and Relational Database Management courses are meant for students who want to build Access databases from the ground up. The first course is two days and includes in-depth, hands-on exercises that teach effective relational database development. Any student who completes these courses will be able to create and maintain a database for a small business or other organization.

Level 1 and Level 2, on the other hand, are intended for students who will be working with existing databases rather than building them from scratch. In other words, these courses are best suited to database end users rather than database designers/managers.

To request the PowerPoints for this course, please e-mail

Access 2019: Relational Database Management

  • Product Code: ACCS2019-RDM-R10-
  • Availability: In Stock
  • Days of Training: 1
  • $18.90

Build Your Solution

Tags: Access 2016, Microsoft, databases, relational database design, normalization, tables, queries, forms, reports, reports, applications, development, macros, SQL