Art Exhibitions            Index           Links           Home             Feedback

Last                                                                   Next

Community Tute 09 - Using the update Query

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

Insert a new field called 'CommunityMember', close and save changes to the 'Main Table'.


2. Create a new query.


3. Add the 'Importdata' table and the 'Main Table', change to query to an update query.


4. Create a link between 'Name' and first name.


5. Save the query as 'Update member join dates on the Main Table'


6. Preview the output of the query, when you move from 'Design View' to 'Datasheet View' the query displays the output but does not actually run the update.


7. Close the query and reopen it - you are now about to execute the update query.


8. Select 'Yes' to run the query.


9. Press 'Yes' to update the records.


10. View the changes 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