microsoft access 2010- illustrated unit c: using forms
TRANSCRIPT
![Page 1: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/1.jpg)
Microsoft Access 2010- Illustrated
Unit C:Using Forms
![Page 2: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/2.jpg)
Objectives
• Use the Form Wizard• Create a split form• Use Form Layout View• Add fields to a form
(continued)
Microsoft Office 2010-Illustrated 2
![Page 3: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/3.jpg)
Objectives (continued)
• Modify form controls• Create calculations• Modify tab order• Insert an image
Microsoft Office 2010-Illustrated 3
![Page 4: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/4.jpg)
Using the Form Wizard
• A form is an Access database object that allows you to arrange the fields of a record in any layout so you can enter, edit, and delete records
• One way to create a form is by using the Form Wizard
• The Wizard asks you questions to determine the information you want
•Microsoft Office 2010-Illustrated 4
![Page 5: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/5.jpg)
Form Views Page 51 Table C-1
Microsoft Office 2010-Illustrated 5
![Page 6: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/6.jpg)
Creating a Split Form
• The benefit of a split form is that the upper pane allows you to display the fields of one record in any arrangement, and the lower pane maintains a datasheet view of the first few records, which you can navigate very quickly
Microsoft Office 2010-Illustrated 6
![Page 7: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/7.jpg)
Form Creation Tools Page 52 Table C-2
Microsoft Office 2010-Illustrated 7
![Page 8: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/8.jpg)
Example of a table in a split form Page 53 Figure C-4
Microsoft Office 2010-Illustrated 8
![Page 9: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/9.jpg)
Using Form Layout View
• Allows some design changes to the form
• You can add and delete fields• You can change formatting such as
fonts and colors
Microsoft Office 2010-Illustrated 9
![Page 10: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/10.jpg)
Using Form Layout View Page 55 Figure C-5
Microsoft Office 2010-Illustrated 10
![Page 11: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/11.jpg)
Mouse Pointer Shapes in Form Layout View Page 54 Table C-3
Microsoft Office 2010-Illustrated 11
![Page 12: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/12.jpg)
Adding Fields to a Form
• Can be done in Layout View or Design View using Field List window
• To add a field: drag it from the Field List to the location you want
• When you add a new field, 2 controls are created: label and text box
• To delete a field: click to select the field, then press [Delete]
Microsoft Office 2010-Illustrated 12
![Page 13: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/13.jpg)
Field List in Form Layout View Page 57 Figure C-7
Microsoft Office 2010-Illustrated 13
![Page 14: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/14.jpg)
Bound vs. Unbound Controls
• Every item on a form is a control, such as text boxes and labels
• Bound controls display data• Unbound controls do not display data
Microsoft Office 2010-Illustrated 14
![Page 15: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/15.jpg)
Modifying Form Controls
• Many common properties can be modified in Form View or Layout View
• Some properties (such as Control Source) can only be viewed and changed on the Property Sheet
Microsoft Office 2010-Illustrated 15
![Page 16: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/16.jpg)
Using the Property Sheet Page 59 Figure C-9
Microsoft Office 2010-Illustrated 16
![Page 17: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/17.jpg)
Common Form Controls Page 59 Table C-4
Microsoft Office 2010-Illustrated 17
![Page 18: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/18.jpg)
Creating Calculations
• Calculations are used to add items such as subtotals and counts to a form
• Expressions are needed to create a calculation
Microsoft Office 2010-Illustrated 18
![Page 19: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/19.jpg)
Creating Calculations
• Expression: an equal sign and a combination of symbols
• Square brackets must surround a field name in an expression
• Field name must be typed exactly as it was in Table Design View (except for capitalization)
Microsoft Office 2010-Illustrated 19
![Page 20: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/20.jpg)
Adding a Text Box to Calculate a Value Page 61 Figure C-11
Microsoft Office 2010-Illustrated 20
![Page 21: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/21.jpg)
Sample Expressions Page 61 Table C-5
Microsoft Office 2010-Illustrated 21
![Page 22: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/22.jpg)
Modifying Tab Order
• Tab Stop: determines whether the field accepts the focus and therefore determines where the focus moves as you press [Tab]
• Tab Order: the order the focus moves as you press [Tab]
• All text boxes and combo boxes have a tab stop and are included in the tab order
Microsoft Office 2010-Illustrated 22
![Page 23: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/23.jpg)
Tab Order Dialog Box Page 63 Figure C-14
Microsoft Office 2010-Illustrated 23
![Page 24: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/24.jpg)
Inserting an Image
• Examples are pictures, logos, clip art• The form section you place it in
determines where it will appear on the form
• For example, determine whether you want the image at the top of the form or next to each record
Microsoft Office 2010-Illustrated 24
![Page 25: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/25.jpg)
Form Sections Page 64 Table C-6
Microsoft Office 2010-Illustrated 25
![Page 26: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/26.jpg)
Adding an Image to the Form Header Section Page 65 Figure C-15
Microsoft Office 2010-Illustrated 26
![Page 27: Microsoft Access 2010- Illustrated Unit C: Using Forms](https://reader036.vdocuments.us/reader036/viewer/2022062309/56649f1b5503460f94c3066a/html5/thumbnails/27.jpg)
Summary
• Using the Form Wizard• Creating a split form• Using Form Layout View• Adding fields to a form• Modifying form controls• Creating calculations• Modifying tab order• Inserting an image
Microsoft Office 2010-Illustrated 27