Access Essentials: Introduction Part II


Overview
In this webcast David Ringstrom, CPA builds on the basics that he introduces in Part 1 of this series. The session starts with additional enhancements to the timekeeping database that he starts in Part 1. After adding enhancements to the database, David moves onto importing data from text files into Access, and then explores relational queries that enable you to assemble data from multiple sources into a single list. The session closes with a discussion of SQL statements so that you're empowered to extract the data you need.

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
  • Assemble data from tables and queries into reports and lists
  • Master relational queries to combine data from multiple sources
Emphasis
  • Create a simple report in Access based on results of a query.
  • Import data from multiple text files into an Access database.
  • Deconstruct a SQL statement, and learn how to tweak SQL statements with the TOP and DISTINCT keywords.
  • Use DLOOKUP to return data from a query or table
  • Make your database interactive by adding buttons to Access forms and reports.
  • Set a default form to appear when the database opens.
  • Create a relational query that assembles data from multiple tables into a single list.
Who Should Attend:
Practitioners interested in learning more about Microsoft Access.

Prerequisite
None

Preparation
None

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