Microsoft Access Expert Level 14 is 1 hour, 34 minutes long. This tutorial will continue our focus on Update Queries to manipulate data, and we'll begin learning about how to use Append Queries to copy records from one table to another. Topics include:

- More Update Queries
- Scrubbing (Cleaning) Data
- Data with Inconsistent Formatting
- Use Replace Function to Change Text
- CStr, Nz, InStr, Left, Right Functions
- Separate First & Last Names
- Fix Non-Relational Tables
- Append Queries
- Daily Student Attendence Table

Click here for more information on Access Expert Level 14, including a course outline, sample videos, and more. This course was recorded using Access 2013, but is also valid for Access 2007 and 2010 users. This class follows Expert Level 13. The next class in the series is Access Expert 15 which is now available.

Subscribe to Microsoft Access Expert 14
Get notifications when this page is updated