Java Games: Flashcards, matching, concentration, and word search.

Tutorial 4 - Access

Creating Forms and Reports

AB
formused to maintain, view, or print records in a database
tabular and datasheet layoutsdisplay fields from multiple records
columnar and justified layoutsdisplay fields from one record at a time
AutoFormatpredesigned style for form
asterisk *wildcard character used to find values
main formdata from primary table
subformdata from related table
best fitmake column as wide as longest value
Form Design Viewused to modify a form
handlesblack boxes on selected item
detail recordset of field values for each record
landscape orientation11 by 8.5 inches
portrait orientation8.5 by 11 inches
controlitems displayed in form and report design views
label controlidentifies name of field
text box controldisplays actual field values
unassociated labellabel does not have corresponding text box
report headerdisplays info only on first page of report
New Record buttonadds a new record
Delete Record buttondeletes current record

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities