Working with Forms and Sub Forms

1. Create a form using the Form Wizard
2. Modify a form's design in Layout view.
3. Add a picture to a form
4. Change the color, line type, and position of items on a form.
5. Navigate a form and Find data using a form
6. Maintain table data using a form
7. Preview and print selected form records 
8. Create a form with a main form and a subform
9. Create a report using the Report Wizard
10. Modify a reports design in layout view.
11. Move and resize fields in a report
12. Insert a picture in a report
13. Change the font color of a report title.
14. Use conditional formatting in a report.
15. Preview and print a report

We will also review Tutorial 1, 2, 3, and 4 for Week 5 Level 1 exam.

Important Points:
1. When creating a form make sure the form is structured exactly like the source document from which the data is being taken.

2. Rules of Data Normalization 3rd Rule - Eliminate Columns not dependent of key. - If attributes do not contribute to a description of the key, remove them to a separate table.
3. The Form Wizard allows you to choose some or all of the fields in the selected tale or query, choose fields from other tables and queries, and display the selected fields in any order on the form.
4. Layout view allows you to modify manuy aspects of a form's layout and design.
5 AutoFormat Wizard has many predfined forms.
6. A control is an item on a form, report or other database object that you can manipulate.
7. Add picture to form: Click Logo button and the insert picture dialog box opens.
8. The Find command lets you search for data in a form or data sheet so you can display only those records you wasn't to view.
9. The Find and Replace dialog box allows you to find data and replace it with other data.
10. Wildcard Characters used with find.

Wildcard Character Purpose Example
* Match any number of characters th* or *ent or be*ter
? Match any single character a?t find art or ant or apt
[] Match any single character within brackets a[fr]t find aft and art
! Match any character not within brackets a[!fr]t finds act,ant, but not aft or art
- Match any of a range of characters must be A to Z. a[d-p]t finds aft,ant apt, but not act or art.
# Match any single numeric character #72 finds 072,172,272, etc.

11. You can check the spelling of table data using a table or query data sheet or a form that displays the table data.
12. To create a form based on two tables, you must first define a relationship between the two tables.
13. Based upon a one to many relationship between two tables, the main form will be used for the primary table and the subform for the related table.
14. The Report Wizard ask you a series of questions then creates the report.
15. The set of field values for each position is called a detail record.
16. Each item on a report in Design view is called a control.
17. A bound control is derived from the table directly or through a query.
18. A unbound control is not connected to the underlying table directly or through a query.
19. When printing selected records, select the record(s), file, print, selected records.
20. When printing a selected page of a report, file,print, page 1 to page 5 .
21. In the form or report design view the Error Checking Options button appears any then access identifies a possible error.
22. Inset Picture in a Report: Click Logo button which brings up the insert picture dialog box.
23. Conditional formatting in a report or form is special fomatting applied to certain field values depending on one or more conditions. Click the conditional button.
24. Print Preview allows you to see the report as it would be printed.

Best Practice:  Always make sure the forms you create match the input documents being used by the input data clerks.