Microsoft Access Level I
(Database Design)
(2-day Course)

Online Format (Zoom, WebEx, Google Meet)

General Overview:

Access is Microsoft’s flagship database application which allows you to create and manage databases for many different purposes. Access incorporates features and connectivity options to make databases more accessible to the everyday user.

Learning Objectives:

By the end of this 2-day course, you will be comfortable with navigating the Access 2016 interface, creating a new database from scratch, querying a database, performing calculations, generating reports, sharing data, and much more.

You will:

• Learn the Access interface
• Create an Access database
• Work with tables and records
• Sort and filter records, and create lookup fields
• Query a database and perform calculations in a query
• Create parameter queries and action queries
• Generate reports and add controls
• Design a relational database
• Organize report information, format reports, and include charts and calculated fields
• Import and export data to other applications 

Target Student:

This course is intended for individuals who are new to Microsoft Access who would like to get up to speed quickly and become familiar with using Access to create and to query a database, perform calculations, organize information, generate reports, and share data with others effectively.  The course will also include database design.

Course Outline:

Day  1

Section 1: The Basics

• Database Concepts
• Getting Started
• Creating a Database
• Converting Access Files
• Working with Objects
• Using Access Help
• Review Exercise

Section 2: Table Data

• Table Concepts
• Viewing Data in a Table
• Changing the Database Appearance
• Entering and Editing Data
• Applying Filters
• Review Exercises

Section 3: Table Design

• Creating a Table
• Changing the Table Design
• Review Exercises 

Section 4: Data Entry

• Data Entry Concepts
• Data Formats
• Input Masks
• Input Validation
• Adding Records
• Review Exercise

Section 5: Relationships

• Relationship Between Tables
• Creating a Relationship
• Referential Integrity
• Removing a Relationship
• Printing Relationships
• Review Exercise

Day II

Section 6: 

• Creating a Form Using AutoForm
• Creating a Form Using the Form Wizard
• Creating a Form in Design View
• Opening a Form
• Changing a Form Design
• Adding Controls
• Placing Controls
• Multiple-Choice Controls
• Error Checking
• Review Exercise

Section 7: 

• Using the Query Wizard
• Creating a Query in Design View
• Selecting and Sorting in a Query
• Calculations
• Action Queries
• Parameter Queries
• Review Exercise

Section 8: 

• Creating Reports
• Using the Report Wizard
• Previewing Reports
• Creating Reports in Design View
• Changing Report Designs
• Control Operations
• Control Attributes
• Review Exercise

Section 9: Importing and Exporting Data

• Importing and Exporting
• Importing a Text File
• Importing Data from an Access Database
• Exporting Data
• Troubleshooting Importing and Exporting Problems

Section 10:

• Printing Objects
• Print Preview
• Customize General and Language Options
• Customize the Ribbon and Quick Access Toolbar

*All Classes are instructor led.
Class recording will be made available after the class.