Building a User Interface
with Forms
Creating Simple Forms

Creates a readymade form based on a table or
query:
−
In the navigation pane, select the table or
query use to generate the form.
−
Choose Create Forms Form. ➝ ➝
Using Forms

Finding and Editing a Record

Adding a Record

Deleting a Record

Printing Records

Sorting and Filtering in a Form
−
Quick filter
−
Filter by selection
−
Filter by condition
−
Advanced filters
More Useful Form Properties

−
Datasheet creates a datasheet form. It’s similar
to selecting Create Forms More Forms ➝ ➝ ➝
Datasheet in the ribbon.
Designing Advanced Forms

Customizing Forms in Design View:
−
Create a form in Layout view: Choose Create
Forms  Blank Form.
−
Drag the fields from the Field List pane into
form.
−
Create a form in Design view. Choose Create
 Forms Form Design. Start with a blank
form in the design window.
−
Drag fields from the Field List pane into form.
Form Sections

Newly created forms start with only one section:
the Details section, which defines the content for
each record.
Form Sections

To add a title or logo at the top of form, or some
sort of summary information or message at the
bottom, must include a header and footer
section.

property.
−
Format your control.

Form controls (reference Table 13-1. Page 407)
Arranging Controls on Form

Working with controls in Design view:
−
Create a control: Select the control you want, and
then draw it in the right place.
−
Move a control: Just click and drag it. You can also
move several controls at Once.
−
Resize a control: Drag the edges of the rectangle
that surrounds it.
−
Modify a control: Select control and set property in
the Property Sheet.
−
Delete a control: Select it  press Delete
Arranging Controls on Form

Aligning controls:
−
Select the control, right-click
−
Choose an option in the Align submenu
−

Decrease Horizontal and Decrease Vertical.
Anchoring: Automatically Resizing
Controls

Normally, the controls have a fixed, unchanging
size. Fixed size controls make for easy design, but
they’re inflexible.

Anchoring lets you create controls that can grow
to fill extra space when the Access window is
resized.
Anchoring: Automatically Resizing
Controls

Making controls as wide as the form
−
In Design view, shrink the width of the Details
section so it’s just wide enough to fit controls.
−
Choose the controls that you want to expand
along with the window’s size.
−
Choose Form Design Tools Arrange  Position
 Anchoring  Stretch Across Top.
Taking Control of Controls

Locking Down Fields: Every bound control
provides the following two properties that you
can use to control editing by using the Property
Sheet in Design view.

−
Optionally, apply formatting.
Organizing with Tab Controls

Tab control is used:
−
Present large amounts of content in a limited
space. Organize this content into separate
pages. At a time, can see only one page.
−
In forms that are primarily designed for editing
or reviewing data, data can be subdivided into
logical groups, and editing tasks often involve
just one group.
Organizing with Tab Controls

To use a tab control, follow these steps:

In the ribbon’s Form Design Tools  Design Controls
section , click the Tab Control.

Draw the tab control onto form

Every new tab control starts with two pages.
−
To create a new page, right-click any tab and choose
Insert Page.
−
To remove an existing page, right-click it and choose
Delete Page.

Choose the field you want to use for the lookup 
Next.
−
Enter a caption for list  Finish
Command Buttons

Command buttons let you trigger just about any
action, like opening a new form, printing a
report…

Crate Button by using wizard:
−
In the ribbon’s Form Design Tools Design 
Controls section, click the Button.
−
Draw the button into form.