Art Exhibitions            Index           Links           Home             Feedback

Last                                                                   Next

Community Tute 10 - Build a new database

1. Start Access and create a new database, see tute01 for help on creating a new database. Make a new table called 'Main Table' and add fields and edit field types until the table design looks like the screen shot below.


2. Create a new query and save it as 'Main Table FormQuery'. Design the query so that all the table fields are included.


3. Now make a form that gets its data form the query we created above.


4. Add the fields to the main form by dragging and dropping the names off the field list onto the form. Make sure the field list is visible, if its not switch it on by selecting 'Field List' under the 'View' menu.


5. Add an option group box, the button on the toolbox is highlighted


6. Insert 5 label names as shown in the image below, press the 'Next >' button.


7. Select 'No, i don't want a default' and press the 'Next >' button.


8. Leave the defaults, press the 'Next >' button.


9. Select 'Store the value in this field' and choose 'FoodQuality' from the drop list.


10. Choose 'Check boxes' for the type of option group and select 'Sunken' for the style.


11. Set the caption for the option group to 'FoodQualityOp' and press the 'Finish' button.


12. Layout the option group so that it looks like the image below.


13. Just copy and paste the sections as shown.


14. You need to change the properties for each of the objects so that they are linked to the correct field in the table (through the query)


15. Ok the option groups are finished time to make a combo box (drop list).


16. Select 'l will type in the values that I want' and press the 'Next >' button.


17. Copy the 3 values form the image below (these are the values in the drop list), press the 'Next >' button.


18. Select 'Store that value in this field' and choose 'Expectations' from the drop list, press the 'Finish' button.


19. A bit of playing with the layout of the form and it should look something like the image below. Download load the database here.






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