Student Objectives: Create and use forms.; Modify forms.; Create a calculated control on a form.; Compact and repair a database.

What is a more convenient way to enter and view records?
1) Creating and using forms. Forms provide an attractive layout for the fields.
2) Forms can be created manually by placing fields on a blank form, or they can be created using the Form Wizard (the easier process).

What is the process of creating a form?
1) Click the Forms button from the Objects bar. Then click the New button.
2) Choose either Form Wizard, Design View (used to design the form manually), or any AutoForm.
3) Then choose the Table or Query where the object's data will come from.

What is the difference between Columnar and Tabular layout for a form designed by Form Wizard.
1) Columnar:  Most common type and as data is entered, the insertion point moves down the fields.
2) Tabular: Layout similar to Datasheet View.

What options or features does a user have when creating a form using Form Wizard?
1) The user can decide:
a) What table or query to base the Form on;
b) Which fields they want to appear on the form;
c) The layout of the form;
d) The style of the form; and the title of the form.

Once the form is created, how does the user move through the records?
1) By using the navigation buttons at the bottom of the form. 
2) They will move you to the 1st record, next record, last record, previous record, or new record.

How can forms be modified manually once they've been created?
1) You can make changes to any form in Design View.  This view shows the structure of the form, where fields can be moved, resized, deleted, etc.
2) How do I do it? Select the form in the Database Window and choose the Design button.

A form is divided into 3 sections, what are they?
1) Form header: Displays information that remains the same for every record such as the Form Title.
2) Detail: Section that displays records.
3) Form Footer: Displays information that remains the same for every record such as instructions for using the form.

What is the Form toolbox used for?
1) It is used to modify and enhance the sections and objects on a form.
2) Labels and text boxes can be drawn on the form using this Toolbox.  Also, changes in fonts, size, style, and other attributes of labels and text data is done in the Form toolbox.

What are the 3 types of controls in a form?
1) Bound control: Connected to a field in a table and is used to display, enter, and update data. (Note: All of your fields in the database are bound.)
2) Unbound control:  Not connected to a field and is used to display information, lines, rectangles, and pictures.  (Note: When a label is unbound, it allows you to add text such as a title or instructions)
3) Calculated control: Uses an expression to generate the data value for a field. (Ex. =Units Ordered*Units Ordered, to determine the value in the Total Cost field.)

How can hyperlinks be used in a database?
1) Hyperlinks can be used in a form to link you to another object in the database, another file, or a Web site.
2) How do I do it? Place pointer in the section of the form, then click the Insert, Hyperlink button, then select the file or Web page you want to link to.

What is the purpose of Compacting and Repairing a database?
1) Because deleted data or database objects can cause the database to become fragmented and use disk space inefficiently, compacting the database is necessary.
2) Compacting rearranges how the database is stored on disk and optimizes the performance of the database. Compacting and repairing is combined into one process.
2) How do I do it? Choose Tools, Database Utilities, then click on Compact and Repair Database.