Art Exhibitions            Index           Links           Home             Feedback

Last                                                                   Next

Community Tute 21 - Make a query to append data to a table

1. Start Access and open the database we created in the last tute, select the 'Queries' tab and hit the 'New' button. If you did not compete the last tute you can download the database click here to download.


2. Choose 'Design View' (the default) and press OK.


3. Select the 'importdata' table and press the add button, then close the 'Show Table' dialogue box (Close Button).


4. Your screen should look like the image below.


5. Change the query type to an append query by selecting 'Query' > 'Append Query'.


6. The append to dialogue box should appear, select 'Participants' as the target table. This means when the query is run new records will be added to the 'Participants' table.


7. Using the shift key select all the fields as shown in the image below, click and drag them to the lower portion of the screen (just to the right of the Field, Table, Sort labels)


8. Your screen should now look like the screen shot below, the screen reads append records to the 'Participants' table (as we know from above) the 'Field' and 'Table' labels indicate the source data, the Append to are fields on the 'Participants' table.


9. Save the table as 'Append records to Participants', and switch to


10. Switch to datasheet view and preview the output of the append query, select 'View' > 'Datasheet View'. Note that this does not actually cause the query to append records to the table, to actually run the append query you have to close the query and open it straight into 'Datasheet View'. Close the query.


11. Select the query and press the 'Open' button (or double click on the name).


12. Select 'Yes' to run the append query.


13. Select 'Yes' to append the records form the 'importdata' table to the 'Participants' table.


14. Open the 'Participants' table and view the new records we added, close the table.





Copyright © 1999 R&D Robotics Pty Ltd, All rights reserved.
Any copyright subsisting in the above code and or literary works including source files vests with R&D Robotics Pty Ltd. ACN 086 345 137


Last                                                                   Next