microsoft® access 2013. generate forms quickly 1 modify controls in layout view 2 work with form...
DESCRIPTION
3TRANSCRIPT
![Page 1: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/1.jpg)
Microsoft® Access 2013
Lesson 07
Adding and ModifyingForms
![Page 2: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/2.jpg)
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
![Page 3: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/3.jpg)
Objective 1
Generating Forms Quickly
3
![Page 4: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/4.jpg)
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
![Page 5: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/5.jpg)
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
![Page 6: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/6.jpg)
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
![Page 7: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/7.jpg)
Objective 2
Modifying Controls in Layout View
7
![Page 8: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/8.jpg)
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.
![Page 9: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/9.jpg)
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.
![Page 10: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/10.jpg)
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.
![Page 11: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/11.jpg)
Exercise 7-4
Modify a Control Layout
Figure 7-311
![Page 12: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/12.jpg)
Exercise 7-4
Resize a Text Box in Layout View
Figure 7-412
![Page 13: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/13.jpg)
Exercise 7-4
Resize and Move Control Layouts
Figure 7-413
![Page 14: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/14.jpg)
Exercise 7-4
Moving a Control Layout
Figure 7-514
![Page 15: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/15.jpg)
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
![Page 16: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/16.jpg)
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
![Page 17: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/17.jpg)
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
![Page 18: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/18.jpg)
Objective 3
Working with Form Sections
18
![Page 19: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/19.jpg)
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.
![Page 20: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/20.jpg)
Exercise 7-9
Open a Form Section
Figure 7-1220
![Page 21: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/21.jpg)
Exercise 7-9
Open a Form Section
Figure 7-1221
![Page 22: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/22.jpg)
Exercise 7-9
All Form Sections Expanded
Figure 7-1322
![Page 23: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/23.jpg)
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
![Page 24: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/24.jpg)
Objective 4
Modifying Controls in Design View
24
![Page 25: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/25.jpg)
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
![Page 26: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/26.jpg)
Exercise 7-11
Selecting Multiple Objects
Figure 7-1626
![Page 27: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/27.jpg)
Exercise 7-12
Resizing a Column
Figure 7-1827
![Page 28: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/28.jpg)
Exercise 7-12
New Layout
Figure 7-1928
![Page 29: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/29.jpg)
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.
![Page 30: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/30.jpg)
Objective 5
Adding Calculated Controls to a Form
30
![Page 31: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/31.jpg)
Exercise 7-15
New Unbound Text Box Added
Figure 7-2031
![Page 32: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/32.jpg)
Exercise 7-16
Add a Calculated Control
Figure 7-2132
![Page 33: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/33.jpg)
Exercise 7-16
Add a Calculated Control
Figure 7-2133
![Page 34: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/34.jpg)
Objective 6
Printing/Saving Forms
34
![Page 35: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/35.jpg)
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.
![Page 36: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/36.jpg)
Exercise 7-17
Print Dialog Box
Figure 7-2336
![Page 37: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/37.jpg)
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.
![Page 38: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/38.jpg)
Exercise 7-19
Print Multiple Records
Figure 7-2438
Multiple Records Selected
![Page 39: Microsoft® Access 2013. Generate forms quickly 1 Modify controls in Layout View 2 Work with form sections 3 Modify controls in Design View 4 Add calculated](https://reader034.vdocuments.us/reader034/viewer/2022051201/5a4d1b637f8b9ab0599ae94c/html5/thumbnails/39.jpg)
Exercise 7-20
Saving Selected Records as a PDF
Figure 7-2539