Art Exhibitions            Index           Links           Home             Feedback

Last                                                                   Next

Community Tute 11 - Add a form

1. Start Access and open the database we created in the last tute, select the 'Queries' tab and 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'.


3. Double click on the '*' so that all fields are displayed in the query, sort by 'FirstName'.


4. Save the query as 'Main Table FormQuery'.


5. Go to the forms view, press the new button.


6. Select the source as the "Main Table FormQuery'.


7. Make sure the 'Field List' is visible.


8. Highlight all the field using the shift key, drag and drop on to the form.


9. Save the form as 'Main Form'.


10. Re-arrange the fields on the form and switch the view to 'Form View'.


11. Should look similar to the view below.





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