From the course: Access 2019: 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: Part 1

Make table, delete, and append queries: Part 1

From the course: Access 2019: Queries

Start my 1-month free trial

Make table, delete, and append queries: Part 1

“

- [Instructor] 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: the make table, append, and delete queries. Before we get started, make sure that you have a backup of your database safely stored away. Let's take a look at how we can create an archive database of some of our older orders. I'll start the process by going to the create tab and starting a new query in design view then I'll grab my orders table. I need to add in all the columns from my orders table and a shortcut way to do that is to simply double click on the asterisk at the top of the table. That'll add the field down here that says orders.*. Essentially what this means is everything from the orders table. Let's go ahead and run this query and you'll see we indeed get all the columns from that table. Let's go back in to…

Contents