Lubbock - Access Level 1 & 2 12/13-14/2017

Class Time: Day 1 8:30AM - 4:30PM
Day 2 8:30AM - 12:00PM

Location:

Lubbock County Training Center
916 Main Street 10th Floor
Lubbock, TX 79401

Do you need to better understand the design of your database or learn how to create queries? Do you currently work with an Access Database and you want to learn more effective ways to get the information you need from that database?

Take this interactive two-day class to learn the foundational skills necessary to build tables, forms and queries. You will also learn how to generate basic reports. Learn how to query the information in a database making it more relevant and useful for your daily work.

COURSE OUTLINE

DAY 1:

Understanding Relational Databases
•    Learn about Access Objects & Terminology
•    Discuss Design & Planning a Database

Create an Access Database
•    Navigate the Different Views
•    Work with Field Properties & Data Types
•    Understand the Concept of Primary Keys
•    Work with Relationships and Referential Integrity
•    Discuss Join Types

Data Basics
•    Add, Save and Find Records
•    Work with Filters and Sorting
•    Move and Copy Data
•    Learn data entry shortcuts

Creating the Basic Query
•    Create Select Queries
•    Understand the Design Grid
•    Use Comparison Operators
•    Learn And and Or Conditions

Use Queries for Calculations
•    Perform Calculations in a Query
•    Calculate Groups & Aggregate Functions

Create Variable Queries
•    Use Variables to Create Dynamic Queries
•    Use Variable in Calculations
•    Work with Query Parameters

DAY 2:

Action Queries
•    Create Update Queries
•    Work with Append Queries
•    Use the Make-Table Query
•    Create Delete Queries
Advanced Queries
•    Introduction to SQL
•    Create Queries using SQL
•    Create Union Queries
•    Work with Crosstab Queries
•    Find & Delete Duplicates

Import & Export Information
•    Import from another Access Database
•    Import and Export Excel Spreadsheets
•    Link information when Importing
•    Import & Export Text & Delimited Files

Forms & Reports
•    Create and Modify Forms
•    Create and Modify Reports


Payment:

The website will automatically email a confirmation confirming you have been registered in this class. If you are paying by check or purchase order we will send you an invoice within 7-10 days of registration. If paying by credit card, please print the online receipt. Payment by check should be made to CLOUD TRAINING SERVICES, Federal Tax ID 75-2745586 and mailed to P O Box 94686, Lubbock, TX 79493. (Please note that classes held at Odessa College will be invoiced by them and paid directly to them.)

In some locations group discounts are given if 3 or more people from the same organization attend this class or if the organization has a volume discount based on regular class attendance. If you are not sure if your organization qualifies for a group discount please contact Darla Cloud at This e-mail address is being protected from spambots. You need JavaScript enabled to view it or call 806.793.3301.

Return Policy:
If a person cancels a class up to 10 days prior to a workshop, they will receive a full refund. If they are unable to attend and do not cancel 10 days prior to the workshop, they may send a substitute. Cloud Training Services will consider emergency situations such as death of family members, illness, and weather and will make every attempt to work with the person in the event of an emergency.

Class must be canceled 5 days before start date

Class Information

Class date: 12/13/17
Class end date: 12/14/17
Seats Remaining: 6
Cut off date: 12/13/17
Individual Price: $259.00
Location: Lubbock County Training Center

Group Rate

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