Print Page   |   Contact Us   |   Your Cart   |   Report Abuse   |   Sign In
phx :: Access Level 1 - Introduction to Databases
View Registrations Tell a Friend About This EventTell a Friend

When: Wednesday
9am - 4pm
Where: Executive Training Solutions
4926 E. McDowell Road
Suite 201
Phoenix, Arizona  85008
United States
Contact: rhette baughman

« Go to Upcoming Event List  


Access Level 1 – Introduction to Databases

Not quite sure if it’s time to move your data from Excel to Access? In this class, we will discuss the differences between Excel and Access, how to navigate and create items in Access, and how databases can save you time. We will focus on planning a database, creating tables, and building relationships.Even if you don’t need to design and build your own database, this class will demystify the underlying architecture of a database so that even someone tasked with data entry and running reports will feel more comfortable with MS Access.

General Information:
Course length: 2 day (9am – 4pm)
Prerequisites: Excel Level 2 or equivalent experience

Cost: $350 - ASBA member | $470 - non-member price
To register, click here or call 602-955-7787.

IMPORTANTINFORMATIONto receive your discounted ASBA member price:
online registration- put "ASBA member" in the comment section of registration
phone registration- mention you are an ASBA member

Course Overview:

Getting Started with Access Databases

  • Identify the Elements of the Access 2010 Interface
  • Identify the Components of a Database
  • Examine the Relational Database Design Process

Building the Structure of a Database

  • Create a New Database
  • Create a Table Using the Design View
  • Manage Tables
  • Establish Table Relationships

Managing Data in a Table

  • Modify Table Data
  • Sort and Filter Records
  • Work with Subdatasheets

Controlling Data Entry

  • Constrain Data Entry Using Field Properties
  • Establish Data Entry Formats for Entering Field Values
  • Create a List of Values for a Field

Querying a Database

  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping

Designing Forms

  • Create a Form
  • Modify the Design of a Form
  • View and Edit Data Using an Access Form

Generating Reports

  • Create a Report
  • Add a Control to a Report
  • Format the Controls in a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print

Sharing Data across Applications

  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

ASBA members receive special pricing on all courses offered through Executive Training Solutions. To view a complete list of courses, please click here.

May the Workforce be With You


Date: Friday, October 28, 2016
7:45 AM - 9:00 AM
GateWay Community College Copper Room


ASBA's Fantasy Lights Holiday Soiree


Date: Thursday, December 1st
6:00 PM - 9:00 PM
Stone House Pavilion at the Phoenix Zoo

Get $5k-$20 in Free Marketing: Make 2016 Your Year for Success!

In Business Magazine

Use In Business Magazine as a tool to reach your customers for 2016. Through Print, Online, Social Media, Email & Events, you can realize an additional $5k to $20k in free advertising with In Business Magazine over 2016.


Small is the New Black


What’s trending for 2016? Small Business! This year, resolve to support our local economy by “Thinking Small” at least one time each week! Need help finding a small biz? Visit! #ThinkSmallBiz


Allowing you to concentrate on what’s really important.

Low and Johnson Inc.

We understand the insurance needs of locally-owned businesses because we’re one, too. As an ASBA member backed by CNA, we’re dedicated to helping small businesses like yours safeguard all you've worked so hard to build.



ASBA 101


Date: Held monthly
Time: Click to check times
Location: Phoenix or Tucson


ASBA Speed Networking


Date: Every 2nd Tuesday of the Month
Time: 3:30 PM - 5:00 PM
Location: Phoenix or Tucson

You're important to us and we want to help protect you

Mutual of Omaha

and your family through the use of insurance products. As a valued association member, you have the opportunity to purchase an insurance policy with lower premiums and/or enhanced benefits not available to the general public. Click here to learn more.


Have questions on small business and health insurance?

Health Insurance

Get the latest on individual, sole proprietor, or group plans related to small business. We can help you find the right plan for you, and your employees. Click to learn more!


CopperPoint Insurance Companies

CopperPoint Mutual

CopperPoint Insurance is Arizona's premiere provider of workers compensation insurance. We've been providing coverage and advocating for Arizona businesses, small and large, throughout the state since 1925.


Association Management Software Powered by®  ::  Legal