Archiving data is a routine maintenance task that is performed on any database. By leveraging the Make Table, Delete, and Append action queries, moving large numbers of records between databases is easy and secure. In this movie, Adam shows how to export old sales records to a separate archive database for safekeeping.
- [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 archive all of my orders…that occurred in January of 2016.…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.