Microsoft Access  Course Overview

Introduction to Microsoft Access 

This Introduction to Microsoft Access training class starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports.

Advanced Microsoft Access 

This course is intended for students who have basic skills with Microsoft Access 2019 who want to learn advanced-level skills or students who want to learn the topics covered in this course in the interface.

Apply Today

Instructor Led Learning

Duration: 1 Days
Registration Open Now!

Video Learning

Duration: 1 Days
Registration Open Now!

What you will learn

Introduction to Microsoft Access

  • Module 1: Quick Overview of the Access User Interface
  • Module 2: Fundamentals
  • Module 3: Tables and Their Views
  • Module 4:Tables
  • Module 5:Queries
  • Module 6:Forms
  • Module 7:Reports

Advanced Microsoft Access 2019

  • Module 1: Relationships
  • Module 2: Queries
  • Module 3: Table Functions
  • Module 4:Forms
  • Module 5:Reports
  • Module 6:Macros
  • Module 7 :Completing the Desktop Application

Basic computer skills

Computers made easy course

Introduction to Microsoft Office course

Microsoft Excel Level 1-3

FULL COURSE OUTLINE

Course Duration: 2 Days

About This Course

The Introduction to Access course provides a comprehensive foundation for students looking to learn about the Access database management system. This course covers the basics of Access, including its user interface, fundamentals, tables, queries, forms, and reports. Students will also gain insights into databases, Access terms, and relational databases. By the end of this course, students will have a solid understanding of Access and be prepared to use it effectively for managing and organizing data in various applications.

Access Version: This course primarily targets Access 2019; however, it can be used to teach Access 365 as well as earlier versions of Access. We draw attention to features that are not supported in earlier versions of Access, and point out alternative options, when available.

Audience Profile

This course is intended for students who have little or no familiarity with Microsoft Access 2019 or more experienced Access users who want to learn the topics covered in this course in the  interface.

Benefits

  1. Comprehensive Coverage: This course offers a thorough introduction to Access, covering all key aspects of the software, from user interface to tables, queries, forms, and reports.
  2. Hands-on Learning: Through practical exercises, students will gain firsthand experience using Access, allowing them to build confidence in their skills and understanding of the software.
  3. Database Knowledge: In addition to learning about Access, students will also gain insights into databases, relational databases, and related terms, providing a well-rounded understanding of database management systems.
  4. Real-world Applications: The course prepares students to use Access effectively for managing and organizing data in various real-world applications, enhancing their overall data management capabilities.
  5. Experienced Authors: The course material is developed by experienced authors who have in-depth knowledge and expertise in Microsoft Access, ensuring that students receive accurate and valuable information.

COURSE OUTLINE

Module 1: Quick Overview of the Access User Interface

This module explains how to become familiar with the Access user interface.

Lessons

  • Access Ribbon
  • Quick Access Toolbar
  • Object Navigation Pane
  • Access Work Surface
  • Object Overview
  • Process Overview
  • Create a Database Using a Wizard

Lab 1: Getting Around the Access Environment

  • Getting Around the Access Environment

After completing this module, students will be able to:

  • Understand the organization of the Access ribbon.
  • Understand context tabs in the ribbon.
  • Understand the Quick Access Toolbar and how to customize.
  • Understand the Navigation Pane.
  • Understand the objects and creation process.
  • Understand the Access work surface.
  • Understand how to create databases using a wizard.

Module 2: Fundamentals

This module explains how to think about some database fundamentals before diving into database creation.

Lessons

  • Questions to Ask Before You Starat
  • Approaches to Database Design
  • Gathering Information
  • A Few Words about Naming Conventions
  • Normalization
  • Table Relationships

Lab 1: Fundamentals Exercises

  • Asking Questions
  • Normalizing Data

After completing this module, students will be able to:

  • Ask questions to consider before you create a database application.
  • Understand common approaches to database design: top-down and bottom-up.
  • Go from paperwork and data samples to categorized data (data mapping).
  • Understand naming conventions for tables and other objects.
  • Understand what normalization is.
  • Understand some basic concepts of normalization and how to apply them.
  • Understandbout primary and foreign keys.
  • Understand relationships and establishing them among tables.

Module 3: Tables and Their Views

This module explains how to work with tables and their views in Microsoft Access.

Lessons

  • Definition and Purpose
  • Datasheet View
  • Design View

Lab 1: Working with Tables in Datasheet View

  • Working with Tables in Datasheet View

After completing this module, students will be able to:

  • Understand tables and table views in Access.
  • Work with tables in Datasheet view.
  • Add and Edit data records in Datasheet view.
  • Understand the purpose of Design view.

Module 4: Tables

This module explains how to work with tables in Microsoft Access.

Lessons

  • Creating an Access Database
  • Data Types
  • Create a Table in Design View

Lab 1: Tables Exercises

  • Creating a New Database
  • Determining Data Types
  • Creating a Table in Design View

After completing this module, students will be able to:

  • Creat an Access database.
  • Create a table in Design view.
  • Understand data types.
  • Assign a key field.
  • Understand input masks.
  • Use expressions to define validation rules.

Module 5: Queries

This module explains how to work with queries in Microsoft Access.

Lessons

  • Queries
  • Select Queries
  • Select Queries with Criteria
  • Logical Operators
  • Group and Total with Queries

Lab 1: Creating Select Queries

  • Creating Select Queries

After completing this module, students will be able to:

  • Use queries and query views.
  • Create a simple query.

Module 6: Forms

This module explains how to work with forms in Microsoft Access.

Lessons

  • Forms
  • Alter a Form
  • Form Record Navigation
  • Layout View and Design View
  • One-click Forms
  • Form Wizard

Lab 1: Forms Exercises

  • Adding Data Records in Form View
  • Creating a Form with the Form Wizard

After completing this module, students will be able to:

  • Understand types of forms.
  • Add records using a form.
  • Understand one-click forms.
  • Create a form using the Form Wizard.

Module 7: Reports

This module explains how to work with reports in Microsoft Access.

Lessons

  • Reports
  • Report Wizard

Lab 1: Creating a Report with the Report Wizard

  • Creating a Report with the Report Wizard

After completing this module, students will be able to:

  • Understand reports.
  • Use the one-click report.
  • Use the Report Wizard to create reports.

Module 8: Databases and Access Terms

  • Database Defined
  • Databases vs. Spreadsheets
  • Access vs. Excel
  • Relational Database Defined
  • Understanding Relational Databases (Exercise)
  • Relational Database Management System (RDBMS) Defined
  • Access is an RDBMS
  • Creating a Relationship
  • Benefits and Limitations of Access

Required Prerequisites

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Course Duration: 2 Days

About This Course

The Advanced Access course builds upon the foundational skills acquired in the Introduction to Access course, diving deeper into topics such as relationships, queries, table functions, advanced forms, reports, macros, and completing a desktop application. This course equips students with the skills and knowledge to handle more complex Access tasks, further enhancing their data management capabilities and proficiency with the software.

Access Version: This course primarily targets Access 2019; however, it can be used to teach Access 365 as well as earlier versions of Access. We draw attention to features that are not supported in earlier versions of Access, and point out alternative options, when available.

Audience Profile

This course is intended for students who have basic skills with Microsoft Access 2019 who want to learn advanced-level skills or students who want to learn the topics covered in this course in the  interface.

Benefits

  1. Advanced Skill Development: This course delves deeper into Access, covering more complex topics and techniques that will enable students to handle advanced tasks and projects.
  2. Hands-on Learning: With practical exercises, students will gain valuable hands-on experience, allowing them to apply their new skills and knowledge to real-world scenarios.
  3. Improved Data Management: By mastering advanced Access features, students will be better equipped to manage and organize data effectively in a wide range of applications.
  4. Experienced Authors: The course material is developed by experienced authors who have in-depth knowledge and expertise in Microsoft Access, ensuring that students receive accurate and valuable information.
  5. Preparation for Further Learning: The advanced skills and knowledge gained in this course will prepare students for further learning in related topics, such as database administration or programming.

COURSE OUTLINE

Module 1: Relationships

This module explains how to work with relationships in Microsoft Access.

Lessons

  • Review
  • Referential Integrity
  • Relationships
  • A Few Words about Naming Conventions

Lab 1: Installing and Configuring Windows 7

  • Click here to enter text.

After completing this module, students will be able to:

Understand referential integrity.

Establish relationships between tables.

Module 2: Queries

This module explains how to work with queries in Microsoft Access.

Lessons

  • Query Design View
  • Review of Select Queries
  • Review of Select Queries with Criteria
  • Logical Operators
  • Parameter Queries
  • Action Queries

Lab 1: Queries Exercises

  • Cerating Select and Action Queries
  • Creating a Parameter Query

After completing this module, students will be able to:

Work with select and action queries.

Work with logical operators.

Create and run select, parameter, make table, append, update, and delete queries.

Module 3: Table Functions

This module explains how to work with table functions.

Lessons

  • Importing Data
  • Linking Tables from External Sources
  • Import Tables from Other Databases
  • Tables from Templates and Application Parts

Lab 1: Table Functions Exercises

  • Importing Data from Excel
  • Exporting Data to Excel

After completing this module, students will be able to:

Import data from Excel.

Export data to Excel.

Module 4: Forms

This module explains how to work with forms in Microsoft Access.

Lessons

  • Design View
  • Formatting
  • Tab Order
  • Create Forms with Application Parts
  • Creating a Subform
  • Alter a Form

Lab 1: Creating Forms

  • Click here to enter text.

After completing this module, students will be able to:

Understand the parts of a form.

Add objects to a form.

Add, move, format, and order fields on a form.

Understand controls available for forms.

Work with form properties, section properties

Module 5: Reports

This module explains how to work with reports in Microsoft Access.

Lessons

  • Design View
  • Report Sections
  • Arranging Fields on a Report
  • Resizing the Detail Section
  • Grouping and Sorting
  • Setting Properties on a Report
  • Special Report Fields
  • Controls
  • Subreports
  • Application Parts
  • Deleting a Report
  • Formatting a Report

Lab 1: Creating Reports

  • Click here to enter text.

After completing this module, students will be able to:

Create and format Access reports.

Work with the various sections of a report.

Group, sort, and add totals for records on a report.

Work with the Expression Builder.

Work with property sheets.

Module 6: Macros

This module explains how to work with macros in Microosft Access.

Lessons

  • Macro Basics
  • Running a Macro

Lab 1: Creating Simple Macros

  • Click here to enter text.

After completing this module, students will be able to:

Create several simple macros.

Run macros.

Module 7: Completing the Desktop Application

This module explains how to complete the desktop application in Microsoft Access.

Lessons

  • The Navigation Form
  • Running Macros from a Navigation Form
  • Setting the Navigation Form as the Default Form
  • Splitting the Database
  • Distributing the Front-end Database
  • Database Maintenance

Lab 1: Creating a Navigation Form

  • Click here to enter text.

After completing this module, students will be able to:

Create navigation forms.

Split an Access database into front-end and back-end databases.

Distribute an Access database front end to your users.

Join Over 10,000 Students that have studied with MasterGrade IT Now

Become Part of MasterGrade IT to Further Your Career.

Contact Us