Microsoft® Access 2013
Lesson 07
Adding and ModifyingForms
Objectives• Generate forms quickly1• Modify controls in Layout
View2• Work with form sections3• Modify controls in Design
View4• Add calculated controls to
a form5• Print/save forms6
2
Objective 1
Generating Forms Quickly
3
4
Advantages of a Form Forms can be designed to display an
entire record on a single screen A form can be designed in an attractive
format with fonts, colors, shading and images
You can design a form to match paper documents
A form can include calculations, functions, and totals
A form can display data from more than one table
Exercise 7-1
Create a Form with a Wizard
The quickest was to create a form is to use the Form Wizard
When using the Wizard: You select the dynaset(s) Select the fields Select the layout Select the style
Note: The fields may be from multiple tables or queries as long as a relationship exists
5
Exercise 7-2
Generate a Form with One Click
You can create a Form using the Forms Tool
Forms Tool Types:Simple FormSplit FormMultiple Items Form
6
Objective 2
Modifying Controls in Layout View
7
Exercise 7-3
Generate a Form with One Click
8
• A control is a database object that displays data, performs actions, and allows you view and work with information.
• A control enhances the visual appearance of the interface, such as labels and images.
• Controls can be bound, unbound, or calculated.
Generate a Form with One Click
9
• A bound control is a control whose data source is a field in a table or query. You use bound controls to display values from the source recordset.
• The values can be text, dates, numbers, Yes/No values, pictures, and even graphs.
• An unbound control is a control without a source recordset.
• You use unbound controls to insert lines, symbols, or static pictures onto the form.
• A calculated control is a control whose data source is an expression rather than a field.
Exercise 7-3
Modify a Control Layout
10
• A control layout is similar to a table in which each cell is a control. A control layout has two controllable features: padding and a margin.
• Control padding is the space between the gridline of the form and the control.
• Control margin is the specified location of information inside a control.
Exercise 7-4
Modify a Control Layout
Figure 7-311
Exercise 7-4
Resize a Text Box in Layout View
Figure 7-412
Exercise 7-4
Resize and Move Control Layouts
Figure 7-413
Exercise 7-4
Moving a Control Layout
Figure 7-514
Exercise 7-5
Add Cells to a Control Layout
Figure 7-615
• Control layouts are like Tables in Word and PPT
• You can insert columns and split and merge cells
Exercise 7-6
Add, Delete, & Move Controls in a Control Layout
A form can have multiple control layoutsTabular layout
Arranged in rows and columns like a spreadsheet
Stacked LayoutArranged vertically like you might on a paper form
16Figure 7-7
Exercise 7-7
Set Tab Order Dialog Box
Figure 7-1017
• You can set the tab order to determine the movement of the insertion pointthrough a form
Objective 3
Working with Form Sections
18
Exercise 7-9
Working with Form Sections
19
The five form sections are:• Detail Section is part of a form or report
that displays data once for every row in the record source.
• Form Header Section is a section of a form that displays once at the beginning of a form.
• Form Footer Section is a section of a form that appears once at the end of a form.
• Page Header Section is a section of a form that displays at the top of each printed page.
• Page Footer Section is a section of a form that displays at the bottom of each printed page.
Exercise 7-9
Open a Form Section
Figure 7-1220
Exercise 7-9
Open a Form Section
Figure 7-1221
Exercise 7-9
All Form Sections Expanded
Figure 7-1322
Exercise 7-10
Add Labels and View Form Sections
Figure 7-1423
• You can use the label tool to enter text or titles in a form
Objective 4
Modifying Controls in Design View
24
Exercise 7-11
Format a Form in Design View
25 Figure 7-15
• Design View provides a more detailed view of the form’s structure
• You can view the Header, Detail, and Footer Sections
• Records do NOT display in Design View
Exercise 7-11
Selecting Multiple Objects
Figure 7-1626
Exercise 7-12
Resizing a Column
Figure 7-1827
Exercise 7-12
New Layout
Figure 7-1928
Exercise 7-13
New Layout
29
The Picture Size Mode settings for an image include the following:• Clip Mode sizes an image to its
original size.• Stretch Mode sizes an image to fit
the control without regard to the proportions of the original image.
• Zoom mode sizes an image to fit the control while maintaining the proportions of the original image.
Objective 5
Adding Calculated Controls to a Form
30
Exercise 7-15
New Unbound Text Box Added
Figure 7-2031
Exercise 7-16
Add a Calculated Control
Figure 7-2132
Exercise 7-16
Add a Calculated Control
Figure 7-2133
Objective 6
Printing/Saving Forms
34
Exercise 7-16Add a Calculated Control
35
When printing a form, the Page Header section and Page Footer section will print on each vertical page. If a form is wider than the paper width, a single page of the form may print on two or more pages of paper. You can change the width of the form and the margins of the page to optimize the print quality of a form.
Exercise 7-17
Print Dialog Box
Figure 7-2336
Exercise 7-18
Print One Record
37
When printing a single record, you must first select the record through the form.
You cannot select to print a single record through the Options in the Print or Print Preview commands.
Exercise 7-19
Print Multiple Records
Figure 7-2438
Multiple Records Selected
Exercise 7-20
Saving Selected Records as a PDF
Figure 7-2539