From the course: Access 2016: Queries

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Make table, delete, and append queries

Make table, delete, and append queries

From the course: Access 2016: Queries

Start my 1-month free trial

Make table, delete, and append queries

“

- [Voiceover] Creating an Archive database is a great way to house data that you may need to reference occasionally, but typically will not enter into your day to day work such as old financial or sales records. We can accomplish this by using three action queries together. The Make Table, Append, and Delete Queries. Before we get started, make sure you have a backup of your database safely stored away. Let's go ahead and take a look at how we can create an Archive Database of some of our older orders. I'm gonna go to the Create tab and create a new query in Design View. And we're gonna pull in our Orders Table here. Now a shortcut way of adding all of the fields from a table into a query is to use this asterisk character at the very top. If I double click on it, it's gonna say orders.* which just means all the columns from the Orders Table. And if I run the query you'll see that we get, in fact, all of the columns. Let's go back in to Design View. Now for this example, I wanna…

Contents