Access 2016: Relational Database Design

Chapter 1: Database fundamentals

Module A: Understanding general database terms
Module B: Relational databases
Module C: Access interface and objects

Chapter 2: Database design

Module A: Fundamentals of efficient design
Module B: The normal forms
Module C: Creating and Modifying Databases
Module D: Relationships and keys

Chapter 3: Tables

Module A: Creating tables
Module B: Creating fields
Module C: Data validation
Module D: Relationships and keys

Chapter 4: Basic queries

Module A: Creating basic queries
Module B: Modifying queries
Module C: Using calculated fields

Chapter 5: Forms

Module A: Creating simple forms
Module B: Form design
Module C: Form controls

Chapter 6: Reports

Module A: Creating reports
Module B: Report controls
Module C: Formatting reports

Access 2016: Relational Database Design gives students a solid start in building and populating relational databases from the ground up. Topics covered in this two-day course include database fundamentals, relational database structure and normalization, and how to create tables, queries, forms, and reports. Both levels of our Access 2016 courseware map to the Microsoft Office Specialist exam for Access 2016. Objective coverage is marked throughout the course.

Students will benefit most from this course if they want design and create relational databases in Access 2016, or if they want to have a solid foundation for continuing on to become an Access expert. If they intend to take a Microsoft Office Specialist exam for Access, this course is a good place to start their preparation, but they will need to continue both courses in the series to be fully prepared for the exam.

The course assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Access or a similar database application before.    

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

Access 2016: Relational Database Design

  • Product Code: ACCS1613-RDD-R10-
  • Availability: In Stock
  • Days of Training: 2
  • $34.15

Build Your Solution

Tags: Access 2016, Microsoft, databases, relational database design, normalization, tables, queries, forms, reports