Microsoft Access: Append Queries & Delete Queries

This lesson is part of the following series:

Microsoft Access & Excel: Concept Video Series (14 lessons, $217.80)
Microsoft Access: Understanding & Creating Queries (5 lessons, $89.10)

This is the third of a series that covers the nuts and bolts of queries in Microsoft Access. This series is designed for students and coaches seeking to learn access to compete in the UIL High School Computer Applications contest but has proven to be useful for anyone seeking to learn or brush up on their Access skills. In this lesson, we focus on the append query and delete query features in Microsoft Access.

In this video, you'll learn about how append and delete queries work, how they are different from select and make-table queries, how to create the, what to watch out for when using them, how to think about and approach "undoing" queries that you've inadvertently run twice, how to duplicate tables, etc.

To illustrate these things, we'll go through example append queries and delete queries in Microsoft Access. Note that a starting point access document is attached as is an ending point database in order to allow you to work off of the starting document and compare your results to the ending document.

This video is screencasted. To watch it in the resolution in which it was recorded (which will offer a crisper screen resolution than the player here), move your mouse over the player and click the 100% (Actual Size) button.

This video was recorded using Microsoft Access 2007. There are very minor differences between Access 2007 and 2010, but the content covered here is the same across versions.

Academic publishing company for 28+ years offering instructional videos, books, software, virtual flashcards, workshops, spelling coaching, and geographic coaching. Most products are geared for competitive academics and home schooling to include materials to study for the Scripps' National Spelling Bee, National Geographic Bee, Texas University Interscholastic League (UIL), North South Foundation, TAPPS, SAT, and more. The 2010 National Spelling Bee champion, Anamika Veeramani was the 11th champion in a row to use our products. Studio Hexco at MindBites is a collection of course material and live presentations by experts in a variety of popular topics. We welcome and appreciate your...

This lesson has not been reviewed.

Please purchase the lesson to review.