Mastering Forms in Database Design

1. Lesson 6 Adding Forms to aDatabase

2. Objectives 1. Create AutoForms. 2. Create a form using the Form Wizard. 3. Work with form sections. 4. Work with controls on a form. After completing this lesson, you will be able to: Objectives continued

3. Objectives (Objectives continued from previous slide) 5. Add a calculated control to a form. 6. Modify format properties. 7. Use the Web to display data.

4. New Object drop-down menu Figure 6-1

5. Figure 6-2 AutoForm with fields displayed in a single column

6. Show Table dialog box in Query Design window Figure 6-3

7. Drop-down list displaying existing tables and queries Figure 6-4

8. AutoForm with fields in columns Figure 6-5

9. Selected fields to be included on the form Figure 6-6

10. Form Design View Figure 6-7

11. Opening the Form Header Figure 6-8

12. Form Header property sheet Figure 6-9

13. Adding a label to the Form Header Figure 6-10

14. Sizing the label box Figure 6-11

15. Changing the font color Figure 6-12

16. Moving a control Figure 6-13

17. Multiple selections of controls Figure 6-14

18. Selecting multiple controls in a column Figure 6-15

19. Text Box property sheet for ProductName Figure 6-16

20. Bound Object Frame property sheet Figure 6-17

21. Tab Order dialog box Figure 6-18

22. Adding a text box Figure 6-19

23. Control Source row Figure 6-20

24. Expression Builder with an expression Figure 6-21

25. Multiple-table query in Design View Figure 6-22

26. Labels positioned closer to text boxes and resized Figure 6-23

27. Selecting a row of controls Figure 6-24

28. AutoFormat dialog box Figure 6-25

29. AutoFormat options Figure 6-26

30. Exporting a form as a Web document Figure 6-27

31. Viewing the Web document in Word Figure 6-28

32. Data Access Page in Page View Figure 6-29