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

3/30/2011
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  


Share


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.


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

In Business Magazine

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

LEARN MORE

Small is the New Black

ThinkSmallBiz

What's trending for 2017? 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 ThinkSmallBizAZ.com! #ThinkSmallBiz

LEARN MORE

Speakers Forum

Speakers Forum.

ASBA is on the cutting-edge of what is happening right now in the business community. We are looking for dynamic speakers to present inspiring and relevant content at future events and become part of our current Mindshare or Storytellers series. If you or someone you know is experienced capturing a crowd and delivering insightful information on sales, marketing, HR, finances, or other topics we invite you to share your knowledge and apply today. We are your partner in business.

APPLY TODAY

RSVP

Experience ASBA

REGISTER

Date: Held monthly
Time: Click for times based on location
Location: Phoenix or Tucson

RSVP

ASBA Speed Networking

REGISTER

Date: Held monthly
Time: Click for times based on location
Location: Phoenix or Tucson

Affordable Dental Plans for ASBA Members

Delta Dental

Your smile deserves Delta Dental, the nation’s leading dental benefits provider. With the largest network of dentists, personalized service & special pricing for ASBA members, we make it easy to keep your smile healthy.

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!

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.

LEARN MORE

Association Management Software Powered by YourMembership  ::  Legal