ONLINE - Access Level 1 & 2 11/29-30/2022 (2 Day Class)

Length/CPE Hours

12.5 hours (2 days)

Class Time

Day 1: 8:30 a.m. – 4:00 p.m. Central Time
Day 2: 8:30 a.m. – 3:00 p.m. Central Time

45-minute lunch break and a 15-minute morning and afternoon break.

Method of Delivery

This class will be held online using GoToMeeting.  Class participants will receive a PDF of the book and will be able to access the class files online.

When you register, be sure to use the email that you would like your GoTo Metting invitation sent to.  The meeting invitation will be sent no later than 1 hour prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account.  You do not have to have a GoTo Metting subscription to participate.  

The web browser client will download automatically when you start or join your first GoTo Metting meeting and is also available for manual download here.

https://www.gotomeeting.com/

It is a good idea to download this prior to the online meeting.

Course Description

This class is designed for the beginner to intermediate Access user who wants to expand their knowledge of Access. In this class we will learn about relational databases. We will look at how to create and relate tables, build simple and advanced queries and how to create basic forms and reports. In the class you will learn:

INTRODUCTION TO RELATIONAL DATABASES

• Relational Databases vs Flat Databases
• Overview of Access Objects – Tables, Queries, Forms & Reports
• Understanding Data Types
• Building Tables
• Table Relationships
• Working with Field Properties
• Use the Lookup Wizard
• Navigating Datasheet and Design View
• Adding, Deleting and Rearranging Fields in a Table
• Working with a Primary Key
• Importing for other Access Databases
• Create a Basic Form

DATABASE BASICS

• Entering and Saving Data
• Finding Data
• Undo Changes
• Sort & Filter Records
• Move & Copy Data

QUERIES

• Create and Save a Basic Query
• Navigate the Query Views
• Work with the Parts of the Design Grid
• Using Comparison and Wildcard Operators
• Working with AND and OR Conditions
• Performing Calculations in Query
• Using Expression Builder
• Working with Parameter Queries
• Creating Action Queries
• Appending Data
• Introduction to SQL
• Working with Crosstab Queries
• Create Union Queries
• Find Duplicates

IMPORTING, REPORTS & FORMS

• Importing and exporting to Excel, Access, CSV and Sources
• Creating & Modifying Basic Reports
• Creating & Modifying Basic Forms

Who Should Attend?

Beginning and Intermediate Access users who would like to expand their knowledge of Microsoft Access.

Prerequisites

Basic Computer Knowledge.

Cancellation Deadline

The cancellation deadline is 5 business days prior to the class. If you are unable to attend, you may send a substitute. If you are a "no show" or you do not send a substitute you will be charged full price for the class.

Cloud Training Services will consider emergency situations such as a death in the family, illness, and weather, and will make every attempt to work with the person in the event of an emergency.

Note

Cloud Training Services partners with other training vendors such as Odessa College and New Mexico Junior College and has no control over payment and registration process. When the registration fees are paid to another agency or vendor, the cancellation and refund policy will be those of that agency or vendor.