Exam 77-424: Microsoft Access 2013 2.0 Build Tables 2.1 Create a Table: Create a Copy

Create an Archive Program 2. An Alternative Approach: Archive the Data The following pages will look at ways to archive old data. Here is a overview.   Revise the Movie Table: tblMovies There are three Fields that should be added to the Movie Table to make this a really useful database.   First, there will be a Yes/No Field that indicates if the Movie is Archived.   Second, there will be a Multi-Value Field that documents the status.   Third, we'll add a Long Text Field.   Create a Make Table Query The Archived Movies will be selected and copied into a new Table.    Create a Delete Query The last Action Query deletes the Archived Movies from tblMovies.   So, when you are ready... Microsoft Access: Example of the completed Make Table Query