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