Class Schedule
21 Aug | intro
23 Aug | clients
28 Aug | servers
30 Aug | networks
04 Sep | basics lab
06 Sep | structural layer
11 Sep | presentational layer
18 Sep | working with layers
20 Sep | behavior layer
25 Sep | images & design
27 Sep | website lab
02 Oct | object layers
02 Oct | graphics
09 Oct | document markup lab
11 Oct | spreadsheets, formulas & functions
16 Oct | thoughts about data display
18 Oct | Fall Break
23 Oct | database tools
25 Oct | spreadsheets lab
30 Oct | relational databases
01 Nov | tables
06 Nov | relationships
08 Nov | forms for input |
Task 05.03 |
reports for output |
Task 05.04 |
next session
13 Nov | SQL
15 Nov | complex queries
20 Nov | databases lab
22 Nov | Thanksgiving
27 Nov | presentation design
29 Nov | presentation delivery
04 Dec | presentation lab
13 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