ONLINE (SAO) - How Auditors Can Use Access to Combine, Link and Query Data 6/8-9/2020

To register for this class, please visit the Texas State Auditors Office Website.

Course Description

This class is designed for participants 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 and build queries that will help you analyze your data. We will learn how to import or link data from Excel, CSV files or other data sources. And will we look at basic forms and report design. The focus of this class is more on how to query the data verses how to build an extensive database. You will learn how to build a simple database to help you understand the structure and relationships of tables. This will help you write better queries and reports.

Potential CPE Credits: 16.0
Govt Hours: This class meets 16.0 hours of the 24-hour requirement for governmental CPE under Government Auditing Standards (yellow book), in most cases.
Technical Hours: This class meets 16.0 CPE credits of technical training in compliance with Texas Admin. Code Rule 523.102.
Instruction Type: LiveExperience
Level: INTERMEDIATE
Category: 02 Auditing

Course Objectives

Upon completion of this course, participants will be able to: Navigate all the Access views and understand table relationships. The participant will be able to write queries with AND and OR conditions and use relational operators. The participant will also learn how to work with variables in a query and build more advanced queries like a UNION query. Finally, the participant will be able to create a basic form or report.

INTRODUCTION TO RELATIONAL DATABASES

  • Relational Databases vs Flat Databases
  • Overview of Access Objects – Tables, Queries, Forms & Reports
  • Understanding Data Types
  • Understanding Table Design
  • Working with 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 AND LINKING TO OTHER SOURCES

  • Importing from other Access Databases
  • Importing from Excel files or CSV files
  • Importing vs Linking

DATABASE BASICST

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

QUERIES

  • Create and Save a Select 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

REPORTS & FORMS

  • Creating & Modifying Basic Reports
  • Creating & Modifying Basic Forms

Prerequisites

PREREQUISITE: The student should have basic computer knowledge.

Event Properties

Event Date 06-08-2020 8:30 am
Event End Date 06-09-2020 4:30 pm
Capacity Unlimited
Cut off date 06-08-2020
Individual Price $299.00