Do it now activity

1. Do it now activity Understand the purpose of append queries in terms of generating data Use buttons to generate queries Learning objectives If statement IsNull Message Box Security Password Data protection act

2. Understand the purpose of append queries in terms of generating data Use buttons to generate queries Learning Objectives

3. By the end of the lesson you will be able to … Create append queries to generate blank records Generate blank records at the click of a button

4. Generating new records using append queries Create a query based on the data required in the table you wish to append to. You will need to add all records that relate to the combination key of that table Then click to append it to the desired table – click to run the query

5. Running queries based on click of a button – pt 1 Select the button that you want the query to run from Go to: > Property sheet >Event >On Click > … > Macro Builder

6. Running queries based on click of a button – pt 2 Checks that two fields are not empty before running rest of macro Opens and runs the selected query (in this case I am running two queries one after another) Message box informs user what has been done You could add a second If statement that checks if the fields are empty using IsNull() and output an appropriate error message as a result.

7. Learning objectives Understand the purpose of append queries in terms of generating data Use buttons to generate queries