Class Schedule
22 AUG | intro
27 AUG | clients
29 AUG | servers
05 Sep | networks
10 Sep | basics lab
12 Sep | structural layer
17 Sep | presentational layer
19 Sep | working with layers
24 Sep | behavior layer
26 Sep | images & design
01 Oct | website lab
03 Oct | object layers
08 Oct | graphics
10 Oct | document markup lab
15 Oct | spreadsheets
17 Oct | formulas & functions
22 Oct | thoughts about data display
18 Oct | Fall Break
24 Oct | database tools
29 Oct | spreadsheets lab
31 Oct | relational databases
05 Nov | tables
07 Nov | relationships
12 Nov | forms for input |
Task 05.03 |
reports for output |
Task 05.04 |
next session
14 Nov | SQL
19 Nov | complex queries
26 Nov | databases lab
21 Nov | Thanksgiving
28 Nov | presentation design
03 Dec | presentation delivery
05 Dec | presentation lab
12 Dec | 0800-1100 | final in class presentation
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | class blog | syllabus | contact | grades
Forms can permit the database designer to create a front end input device
that allows data entry personnel to populate the database
without having to understand the database's inner workings.
Since we want to see forms at work in a healthy database, we'll use a set of well-related tables as a database for building forms (our completed task 05.02).
They give you a way to enter data into your database, display the data for review, and print it out.
Each of the objects in Access has certain specific advantages for viewing data
A form provides an efficient way to enter data because rather than typing values into each field in a table, you can create drop-down lists to select the value you want
Forms do not store the data they present - they keep only your design parameters, allowing you to tinker with it without affecting your data
Access Form Help
The Form tool creates a form tied to the table selected in the object window. Select Form and you get a form to work with, though it may not necessarily meet all your needs.
but it is powerful. If your table is related to one or more other objects, the Form tool will create a form that displays that relationship
Remember, forms are created for specific users, who have specific tasks to perform using the form.
In creating the form, include only the form elements that the users need,
and do not include elements that are extraneous to the users' needs.
If you wish to create a form that looks at data in several tables, use the wizard
It will ask you to select all of the fields that you want to include on the form, and then prompt you to choose the layout you think will work best
note that the wizard allows you to choose fields from more than one table or query
use a subform, a form within a form, to include information from more than one table in a form. The primary form is the main form while the form within the form is the subform.
Subforms are most effective when you want to show data from tables or queries with a one-to-many relationship, like one author with many books.
a Main/Subform form shows a one-to-many relationship between the data in the main form and the data in the subform
The easiest way to link a main form with a subform is to choose the Form Wizard when you create a new form
The main form is in a single-column format, and the subform is either in a datasheet or tabular layout.
Access - Understand Controls Help
Forms use graphical objects, called controls, to link the object back to the underlying table or query
There are three types of basic controls in Access: unbound, bound, and calculated