Microsoft Access Database: Archive System in Access using Queries

There are four ACTION Queries that can be used in your Microsoft Access database; Make-Table, Append, Update and Delete.

    This video tutorial covers two of them; Append and Delete wrapped with a macro to similuate how to delete a record but first archive the record elsewhere.

    Microsfoft Access Video Tutorial: Archive System in Access using Queries

    Access Database Tutorial – My Additional Points

    As the author of this video correctly points out, it’s not a perfect way to archive record as there is room for mis-use and errors and coupled in a macro only highlights the inperfections.

    This example also uses a Parameter query which is a very popular query in Microsoft Access and makes this more flexible but again the discipline is with the user making sure they enter a valid and correct ID or code value as it has no error checking functionality.

    The ultimate solution in Microsoft Access?

    Learn to use VBA code – a programming language which is not difficult but requires a little effort. Here, you can control logical workflows and handle unknown records and errors.

    What else do you need to know in your Access Database?

    How to build queries whether it’s a collection of ACTION queries or other powerful and essential queries that is required for your Microsoft Access database application.

    My two eBooks; “How to Access Database Queries” and “More Access Database queries” covers all the queries you will need to know. The added benefit with my eBooks (which there are more!) is that they come with a 30 day free email support to help you as you learn Microsoft Access plus, there’s a money back guarantee too!

    This entry was posted in Database Theory, Macros, MS Access, Queries and tagged , , , , . Bookmark the permalink.

    2 Responses to Microsoft Access Database: Archive System in Access using Queries

    1. Marguerite says:

      I absolutely love your blog and find nearly all of your
      post’s to be just what I’m looking for. Do you offer guest writers to write
      content for you? I wouldn’t mind producing a post or elaborating on a lot of the subjects you write with regards to here. Again, awesome website!

    2. Ben Beitler says:

      Don’t forget, the author also mentioned using a Parameter query which uses the convention of square brackets. For example, [Enter your code:] would display a prompt as shown inside the brackets.

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

    Confirm you are human.