top of page

Data Modeling Fundamentals with Microsoft Access

DURATION: 24 hours (3 days)

Pre-requisite 

This course is intended for intermediate to advanced users of spreadsheets (such as Microsoft Excel) or equivalent record/data management. 

Course Description

This instructor-led advanced course on Microsoft Access is a combination of database conceptualization through data models and learning the Microsoft Access application. The data model is one place where you can store all relevant information about a data asset (definitions, structure, relationships, integration points, etc) and deliver it in a visual and contextually appropriate format for stakeholders involved in the management and consumption of data. 

In this course, you will use Access to create a data model for managing your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter and sort data. 

Course Objectives

At the end of this course, the participant should be able to:

  • Understand the basic concept of a database. 

  • Create entity relationship diagrams by identifying entities, attributes, relationships and constraints from a set of requirements. 

  • Normalize the entity relationship diagram to third normal form.

  • Develop sound database designs by applying proven data modeling techniques. 

  • Engineer/re-engineer the data models into and from relational database designs. 

  • Create and modify Tables in Access. 

  • Create and design Queries. 

  • Create Forms and Reports. 

Who Should Attend 

Anyone who needs to learn how to properly manage a huge amount of data and who wants to develop a self-service database for their own task or their team's. 

Course Content

  • Database Overview 

  • Entity Relationship Model 

  • Relational Model 

  • Relational Database Design 

  • Storage and File Structure 

  • Indexing and Hashing 

  • Transaction and Concurrency 

  • Backup and Recovery 

bottom of page