Microsoft Access Beginner

Microsoft Access is a desktop database application used all over the world in commercial and industrial applications where the creation and maintenance of desktop databases are involved. It is a relational database and stores data tables that could be related. It also has a powerful query tool that allows users to extract complex information from the database for reporting purposes.

Course Outline
Lesson 1: Exploring the Access Interface

• Database Basics

• Running Microsoft Access

• The Opening Screen

• The Initial Access Screen

• Working with Help

Lesson 2: Creating a New Database

• Database Design Basics

• Creating a Database

Lesson 3: Creating a Table

• Designing a Table

• Redesigning a Table

• Renaming a Database Object

Lesson 4: Working with a Table

• Viewing a Table

• Editing a Table

• Modifying a Table

• Sorting Table Records

• Filtering Table Records

• Printing a Table

• Print Previewing

• Page Setup

Lesson 5: Setting up Table Relationship

• Creating Relationship

• Viewing Subdatasheets

• Enforcing Referential Integrity

• Printing Database Relationships

Lesson 6: Creating a Query

• Querying Tables

• Saving or Opening a Query

• Using Wildcards in Queries

• Compound Queries

• Miscellaneous Operators

• Creating Calculated Fields

• Using Summary Operators

• Querying Multiple Tables

Lesson 7: Creating a Form

• Form Overview

• Creating Forms

• Customizing the Form

• Saving or Opening a Form

• Using the Form Filter

Lesson 8: Creating a Report

• Creating Reports

• Saving or Closing a Report

Our Microsoft Access Beginner course is designed for office users or those planning to work in an office. It is a foundation course that teaches you the basics of creating a desktop database and other features like queries, forms, and reports. Please refer to the detailed course outline below to learn what is covered in the course.