× Course by Subject Webinars Self-Study eBooks Certificates Compliance Manager Subscriptions Firm CPE Blog CCHCPELink.com

Introduction to Microsoft Access Part 1 (Completed)

Date: Wednesday, January 18, 2012
Instructor: David H. Ringstrom
Begin Time:  8:00am Pacific Time
9:00am Mountain Time
10:00am Central Time
11:00am Eastern Time
CPE Credit:  2 hours for CPAs

In the first session of this two part series, David Ringstrom, CPA will walk you through building your first database in Microsoft Access. Many Excel users often shy away from Access, but you'll see that Access is not only approachable, but easier than you think to use. David will create a simple timekeeping database from scratch, so you'll gain firsthand experience with tables, queries, forms, and reports.

Attendees can download a copy of the presentation handout as well as a copy of the completed database to review prior to the session. David will be teaching from Access 2010 in this session, but Access 2007 users will be able to easily follow along. The presentation includes alternate instructions for Access 2003 users.

The second session covers more advanced topics that enhance the functionality of this database.

Who Should Attend
Practitioners interested in learning more about Microsoft Access.

Topics Covered

  • See the key differences between Access and Excel
  • Learn how to create tables in an Access database
  • Add interactive forms to your database that include input fields and simple formulas
  • Design queries to return exactly the data that you’re seeking
  • Build reports based on data within the database

Learning Objectives

  • Learn how to build a complete and functional Access database that you can adapt to other uses

Level
Basic

Instructional Method
Group: Internet-based

NASBA Field of Study
Computer Science (2 hours)

Program Prerequisites
None

Advance Preparation
None

">
 Chat — Books Support