Access Essentials: Introduction Part II
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.
- 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
- 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.
Practitioners interested in learning more about Microsoft Access.
Level of Knowledge
Group Internet Based
NASBA Field of Study
Specialized Knowledge and Applications
David H. Ringstrom