meets Tuesday and Thursday from 0800-0915
office hours in Manning 112
Class Schedule
10 Jan | intro
15 Jan | clients
17 Jan | servers
22 Jan | networks
24 Jan | basics lab
29 Jan | structural layer
31 Jan | presentational layer
05 Feb | working with layers
07 Feb | behavior layer |
12 Feb | images & design
14 Feb | website lab
19 Feb | document markup
21 Feb | graphics
26 Feb | document markup lab
28 Feb | spreadsheets
05 Mar | formulas & functions
07 Mar | data display
19 Mar | database tools
21 Mar | spreadsheets lab
26 Mar | relational databases
28 Mar | tables
02 Apr | relationships
04 Apr |
forms for input |
05.03 |
reports for output |
05.04 |
next session
09 Apr | SQL
11 Apr | complex queries
16 Apr | databases lab
18 Apr | presentation design
23 Apr | presentation delivery
25 Apr | presentation lab
30 Apr | 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