Access Essentials: Introduction Part I


Overview
In this webcast David Ringstrom, CPA turns helps Excel users establish a good grounding in Microsoft Access. The session opens with a comparison between Excel worksheets and Access tables, and then demonstrates how easily data can be moved between both programs. From there David walks attendees through building a simple timekeeping database from scratch. This gives first-hand experience with the major components of Access databases: tables, queries, forms, and reports.

David will teach from Access 2010, but will provide detailed handouts with specific instructions for these versions of Access: 2003, 2007, 2010, and 2013.

Objectives

  • Establish a baseline of knowledge about Microsoft Access
  • Compare and contrast aspects of Access versus Excel
  • Build a simple, yet functional, database from scratch 
Emphasis
  • Learn how to create tables in an Access database
  • Explore the different types of data that can be stored within an Access table.
  • Design queries to return exactly the data that you’re seeking
  • Easily move data between Excel worksheets and Access tables
Who Should Attend:
Practitioners interested in learning more about Microsoft Access.

Prerequisite
None

Preparation
No advance preparation required
 
Level of Knowledge
Basic
 
CPE Credit
2 Hours
 
Delivery Method  
Group Internet Based
 
NASBA Field of Study
Specialized Knowledge and Applications

Author
David H. Ringstrom