Art Exhibitions            Index           Links           Home             Feedback

Last                                                                   Next

Community Tute 06 - Make a query and move data

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


2. Select 'Design View' and press 'OK'


3. This is the query design view, Select the 'ImportData' table and press 'Add' then the 'Close' button.


4. Add the field names shown below by double clicking in the 'ImportDate' window (Table). Set the sort order of the field 'name' to ascending.


5. Time to save the query.


6. Set the query name to...


7. To view the output of the query, under the 'View' menu choose 'Datasheet View' or close the query and press the 'Open' button.


8. Back to the design view of the query, now modify the query so that it only includes records of those people who joined the community before 1/5/99 (Australian date format).


9. Now view the output.


10. Change the query type so that it appends the records to the 'Main Table'.


11. Choose the 'Main Table' as the target for the append query.


12. Use the 'Save As' command to save the query as another name (leaves the original the same', choose 'Update MainTable' as the query name.


13. Run/Open the query, close it then select it (high light blue) and press open. Select 'Yes' to run the query.


14. Click 'Yes' to append the records to the 'Main Table'.


15. View the new records in the 'Main 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