Access Forms

1
Access Forms
2
Forms

• Provide an easy way to
• Enter data
• Modify data
• View data

3
Forms

• Forms can be sculpted to match any of a companys
  paper forms
• Can be structured to display large amount of data
  on one screen
• Entire customer record
• Forms can be designed to show multiple records
• Forms can be multi-page

4
Forms

• You can embed subforms into a form
• Allows you to work with data from two or more
  linked tables
• Forms do not store database information
• They display information from one or more tables
• Forms can contain code associated with form
  events
• Error trapping
• Automate certain types of data entry

5
Form Types

• Simple form
• Displays a single record
• A continuous form
• displays several records simultaneously on a form
• Multiple-page forms
• Forms with lots of information are designed as
  multiple-page forms
• information distributed across several form pages

6
Form Types

• Subform
• Multiple records (relationship table)
• Other
• Datasheet
• PivotTable
• PivotChart

7
Simple Data Entry Form
8
Simple form for customer table

• As form is filled in and the enter key is
  pressed or next record is clicked on, data will
  be written to the table.

9
Form Navigation

• Navigation buttons located in the Toolbar
  facilitate moving between records in Form view
• Click the master form Next record button to
  advance to the next (empty in this case) record
• Click the First record button to move to and
  display the first record in the database through
  the form

10
warning dialog box for form
Navigation buttons
11
Continuous Form
12
message dialog box for form
13
Form with subform
Main Form
Subform
Main Form
14
Creating a Simple Form

• AutoForm
• Form wizard helps you create various types of
  forms
• Modify to suit your needs in design view
• Design View
• This is completely from scratch

15
Altering form in design View

• You can select an object and then drag it to
  another location on a form
• An objects sizing handles allow you to click and
  alter the objects shape
• You can right click to view an objects property
  sheet and to alter various properties of an object

16
Auto Form in 2K7
Then, Click on form under the create tab
First, Highlight table that will be source
17
Initial Design
18
Wizard
19
(No Transcript)
20
Initial Design
21
Modify Layout in Design View
22
Highlight an item and right click to see property
sheet
23
Form Controls

• Controls can be incorporated into forms that can
  give users choices for data entry
• examples
• combo boxes,
• list boxes, and
• option buttons
• Tab Controls
• Other controls

24
option buttons
combo box
25
Form with Subform

• Many forms involve more than one table joined
  together
• Main Form displays one record
• Sub form contains multiple records from
  relationship table

26
Northwind Form with subform
Primary Key
Main Form
Subform
Main Form
27
(No Transcript)
28
Tables needed for Northwind order Form

• Customer table
• Read data from this table
• Products table
• Read data from this table
• Employee Table
• Read data from this table
• Order table
• Order data written to this table
• Order details table
• Order detail data written to this table

29
Creating a Form Containing a Subform

• The best way to create a main form and its
  subform is to use a Form Wizard
• After the Form Wizard creates a form, you can
  modify and customize it to suit your needs

30
Go to form wizard
31
Select attributes from Tables
32
(No Transcript)
33
(No Transcript)
34
(No Transcript)
35
View by Orders
36
Initial Layout
37
Name form subform
38
Initial form(modify in design view)
39
Final design
40
Auto form 2K3
Select Autoform
Tables Select table that autoform will use
41
Form Wizard 2K3
Forms Create form by using wizard Follow the
prompts