Access 2021/365: 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 2021/365: Relational Database Design provides the basic concepts and skills to start being productive with Microsoft Access: How to design and create a relational database, navigate the Access interface, and how to create and modify tables, queries, forms, and reports.

Students will benefit most from this course if they want to gain a basic understanding of relational databases and be able to design and build a simple database in Access.
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 another database system before.

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 2021/365: Relational Database Design

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

Build Your Solution

Tags: Access 2021, Office 365, Microsoft, databases, relational database design, normalization, tables, queries, forms, reports