Description

Microsoft Access is a Relational Database which has the core object which is Table, Query, Form and Report. In this fundamental level, you will be introduced to the Database concept using the four objects to build a simple system.

Learning Outcome and Goals

• Understand Concept of using Microsoft Access as a database tool
• Understand basic creation of table and its control
• Design a Data Entry Form
• Generate Reports using Design and Wizard
• Perform Query to extract relevant data

Course Requirement

• Participants should be able to use a PC at the beginner level
• Basic knowledge and functionality of Microsoft Excel
• Microsoft Office 2013 and above

Course Information

Course Outline

Module 1: Getting Started

• What is Microsoft Access?
• What’s New in Access?
• Basic Terminology

Module 2: Working with Tables

Customizing Tables

• Understanding Field Properties
• Adding a Primary Key to a Table
• Inserting, Deleting, and Moving Fields
• Importing a Table from another Source

Formatting Tables

• Formatting Number Fields
• Formatting Text Fields
• Adding Field Descriptions
• Changing Field Data Types
• Adding Captions

Module 3: Working with Forms

Basic Form Controls

• Adding a Control
• Using the Control Wizard
• Cutting, Copying, Pasting, and Moving a Control
• Formatting a Control

Advanced Form Controls

• Modifying a Control’s Properties
• Changing a Control’s Data Source
• Changing a Control’s Default Value
• Using Form Properties

Formatting Your Form

• Formatting Gridlines
• Modifying the Font
• Changing the Layout

Formatting Controls

• Changing the Color of a Control
• Using Control Properties
• Aligning Controls

Module 4: Working with Reports

Organizing Report Data

• Adding and Removing Fields
• Using Report Sections

Formatting Reports

• Formatting Gridlines
• Modifying the Font
• Changing the Layout

Common Report Tasks

• Adjusting Page Setup
• Adding Headers and Footers
• Adding Page Numbers

Module 5: Working with Queries

Basic Queries

• Creating a Query
• Sorting a Query
• Filtering a Query
• Hiding Fields

Multiple Table Queries

• Creating a Multiple Table Query
• Creating a Calculated Field
• Using Queries to Summarize