An Introduction to Forms

1. An Introduction to Forms

2. TheMajorSteps of a MicroSoft Access Database • Tables • Queries • Forms • Macros • Reports • Modules On our road map, we are here!

3. SESSION 4.1 This section covers creating a form using a form wizard, changing a form’s autoformat, navigating a form, preview and printing selected form records and maintaining table data using a form. Creating Forms & Reports Microsoft Access 2000 Class #7

4. Figure 4-5 Completed Order Data Form As shown in Tutorial 1, a form is an object you use to maintain and view records from a table or query.

5. Forms are primarily used for Viewing Data on Screen.

6. Forms are usually designed for visual appeal, using colors and graphics that are sometimes hard to print or slow to print.

7. Reports on the other hand are generally designed for, but not limited to, hard copy output. We will explore reports later.

8. Forms generally come in two flavors. Bound and Un-Bound

9. A Bound Form is a form that is used on a Table or Query.

10. This means that it will show all or selected data on the form that is stored in the table or query.

11. You would use this kind of from to view, edit add or delete data or entire records that reside in the underlying table.

12. You can also use a bound form to show only selected fields in a table, hiding or masking out fields that you don’t want the user to view.

13. The other type of form that you will frequently encounter is an Un-Bound Form

14. An unbound form is a form that is not based on a table or query. It does not contain data. Can anyone tell us what an unbound form would be used for?

15. An Unbound Form is generally used for a Menu that contains buttons or options that are available to the user. Since version 1.0 of Access a menu has been referred to as a switchboard

16. This kind of form can also be used to contain text only in labels that can provide instructions or help to the user.

17. We will be looking at these uses for forms later in the course.

18. For today we will be using a bound form only that is based on a table.

19. With Access, you can design your own forms or use one of the Form Wizards to create them for you automatically.

20. Many times when a form is created with a wizard, you will find that either you forgot something during the wizard process or the wizard didn’t create a form that exactly meets you needs.

21. In this case Access will allow you to refine or modify the form that a wizard creates, to any degree needed.

22. Because of your ability to modify forms after the fact, the form wizard is usually a quick way to get started on a form.

23. Sometimes, if your demands are not to great, the wizard might even be able to create the form you need.

24. Forms and reports are usually very easy to create and with the many available tools are easy to modify.

25. However, don’t confuse the terms “Easy” and “Quick”

26. Depending on your desires, forms and reports can be easy, but take quite a bit of time and patience.

27. We will be exploring ways of creating our own custom forms and ways to modify existing forms later in the course.

28. In this session we will be exploring the process of creating a form using the Form Wizard. Tutorial 1 used the AutoForm Wizard which created a form automatically using all the fields in the selected table or query to create the customer data form.

29. The Form Wizard allows you to chose some or all of the fields in the selected table or query, choose fields from other tables and queries and display the selected fields in any order on the form. You can also choose a style for the form.

30. 2000 Figure 4-7 AutoFormat Dialog Box During the Form Wizard process, we will be asked to select a pre-defined format for our form. Page AC 4.06 The format choices we will be given are called AutoFormats.

31. ‘97 Figure 4-7a Access 97’s AutoFormat Dialog Box

32. An AutoFormat is a predefined style for a form or Report. An AutoFormat can be changed later, at anytime, after the Form Wizard has been completed.

33. Before you change any part of the design of a form you first must be in the design view of that form.

34. To toggle between the form view and design view you can click on the View button found on the design view’s toolbar.

35. The “Find Command” allows you to search the data in a form and to display the records that you are searching for.

36. You choose a field to serve as the basis for the search by making that field the current field. You can make a field current by either tabing into the field or clicking in the field.

37. Once the field is selected you can then activate the “Find in Field Dialog Box”. This is done by selecting Edit on the MenuBar and then Find or by clicking on the Find Button on the tool bar. on the Keyboard will also accomplish this.

38. 2000 ‘97 There has been a change in this procedure in Access 2000. Let’s look at both ‘97 and 2000 procedures. First, Access 97.

39. When the Find in What Field Dialog Box is activated, you can quickly check to see if you have selected the correct field by looking at the title bar. ‘97

40. You type the data you are looking for in the “Find What” field. ‘97

41. You then choose how you want Access to search ‘97 Up will search from the current record back to the 1st record. Down will search from the current record down to the last record.

42. You then choose how you want Access to search ‘97 All will do a loop, starting at the current record to last record and then start at the top and continue down to the record just before the current record.

43. You can choose to have a case sensitive search by clicking in the “Match Case” check box. ‘97

44. 2000 Figure 4-9 Find and Replace Dialog Box In Access 2000, when the Find and Replace Dialog Box is activated, you can quickly check to see if you have selected the correct field by looking at the Look In Field. Page AC 4.09

45. 2000 You type the data you are looking for in the “Find What” field.

46. 2000 You can type the field name that you wish to look in if you did not select it before activating the Find and Replace box or use the lookup arrow on the right of the box.

47. 2000 You then choose how to match the “Find What:” to the data you are looking for.

48. 2000 Clicking the “More >>” button will provide us with more “Find” options.

49. 2000 Clicking the “More >>” button will provide us with more “Find” options.

50. 2000 You then choose how you want Access to search