Katherine Carr Designs

Software Training ▪ Database Design & Development

New York, NY  ▪   info@kcarrdesigns.com

Course Outline

Description: Access is a relational database that gives you a powerful set of tools that are sophisticated, yet easy for new users to learn. We will discuss the concept of a relational database and you will learn how to create database solutions that make organizing, accessing, and sharing information easier than ever. 

• What is a relational database?

• Benefits of using a relational database

• Types of relationships

Overview of Database Objects

• Tables, Forms, Queries, Reports, Macros and Modules

Creating a Database

• Planning Your Database

• Create Tables

• Create Relationships between Tables

• Import Data from Excel

Managing Data

• Add, Edit and Delete Records

• Sort Records

• Find Records

• Filter Records

Querying the Database

• The Select Query

• Add Criteria to a Query

• Add a Calculated Field to a Query

• The Action Query

Designing Forms

• Create a Form in Design View

• Create AutoForms

• Create a Form Using the Form Wizard

• Modify the Design of a Form

• Create a Subform

• Add Command Buttons to a Form

Producing Reports

• Create an AutoReport

• Create a Report with the Report Wizard

• Create a Report in Design View

• Add a Calculated Field to a Report

• Modify the Format Properties of a Control

• Sorting and Grouping Records in a Report