Course Overview
Target audiences
- 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 2019 interface.
Schedule Dates
Curriculum
-
Module 7: Reports
This module explains how to work with reports in Microsoft Access.
-
Module 1: Quick Overview of the Access User Interface
This module explains how to become familiar with the Access user interface.
- 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
- 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 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.
- 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.
- Understand bout 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.
- Definition and Purpose
- Datasheet View
- Design View
- Lab 1: 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
- 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.
-
Module 6: Forms
This module explains how to work with forms in Microsoft Access.
- Forms
- Alter a Form
- Form Record Navigation
- Layout View and Design View
- One-click Forms
- •Frm 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