Lubbock Access 5/22/2019

Length

7 hours (1 days)

Class Time

8:30 a.m. – 4:30 p.m.

Location:

Lubbock Classroom
Melonie Park Meeting Space
3502 74th Street
Lubbock, TX 79423

Course Description

This class is designed for the beginner Access user who wants to learn Access. In this class we will learn about relational databases. We will look at how to create and relate tables, build queries and learn 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 and Field Properties

Building Tables

Table Relationships

Use the Lookup Wizard

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

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

Class must be canceled 5 days before start date

Class Information

Class date: 05/22/19
Class end date: 05/22/19
Seats Remaining: 4
Cut off date: 05/22/19
Individual Price: $169.00
Location: Lubbock Classroom

Group Rate

No Number registrants Rate/Person($)
1 3 149.00
Share this class: