Download - CURS 6 - Create Forms S
-
7/29/2019 CURS 6 - Create Forms S
1/24
Access 2007 create forms
Prof. univ. dr. Pavel NASTASE
Bucharest Academy of Economic StudiesFaculty of Accounting and Management Information Systems
-
7/29/2019 CURS 6 - Create Forms S
2/24
Create forms
Course goals
Use the Form tool to create a simple form.
Use the Split Form tool to create a split form a form that
lets you work with single records and large amounts of
data.
Use the Form Wizard to create a form.
Use Layout view to change a form.
Use Design view to change a form.
2
-
7/29/2019 CURS 6 - Create Forms S
3/24
Create forms
Basic forms
Your new asset-
tracking database is
already saving timeand money, but some
coworkers dont like
using Datasheet view
to enter data a grid
of columns and rowsisnt that easy to use.
Not a problem: Forms to the rescue.
A form is a screen that allows you to enter, change, andview the data in a database. Think of forms as windows
into your data that help users understand and work with
that data.
3
-
7/29/2019 CURS 6 - Create Forms S
4/24
Create forms
Basic forms
Lets take a quick look
at what goes into a
form, using the pictureas a guide.
1 Forms are made up ofcontrols, such as text boxes,
buttons, document tabs, and drop-down lists, grouped in
a way that makes them easy to use and helps you getwork done.
4
-
7/29/2019 CURS 6 - Create Forms S
5/24
Create forms
Basic forms
Lets take a quick look
at what goes into a
form, using the pictureas a guide.
2 The controls in the form are usually bound, or
connected, to the tables or queries in your database
but not always.
5
-
7/29/2019 CURS 6 - Create Forms S
6/24
Create forms
A quick look at form design
You design forms in
much the same way
that you designed thetables for your asset-
tracking database.
1
2
Start by listing the data that you want to enter or view.
Then decide on the controls you need in order to captureand work with your data. For example, if you need to
enter or edit data, you use a text box. If you need to give
users a list of choices, you use a list control.
6
-
7/29/2019 CURS 6 - Create Forms S
7/24Create forms
A quick look at form design
You design forms in
much the same way
that you designed thetables for your asset-
tracking database.
3 If it helps, try sketching your form. If other users are
involved, you can have them review your sketch.
7
-
7/29/2019 CURS 6 - Create Forms S
8/24Create forms
Create a form with the Form tool
The Form tool
automatically creates
a form that is bound,or connected, to a
single data source,
either a table or a
query.
You select your data source, click a button, and Access
creates the form.
The new form displays all the fields in the data source,
but you can remove any fields that you dont want to
see.
8
-
7/29/2019 CURS 6 - Create Forms S
9/24Create forms
Create a form with the Form tool
The picture illustrates
the process.
1
2
In the Navigation Pane, select the table or query that you
want to use as the data source for the form.
Click the Create tab, and in the Forms group, click
Form. The new form opens in Layout view, which gives
you a chance to change it.
9
-
7/29/2019 CURS 6 - Create Forms S
10/24Create forms
Create a form with the Form tool
The picture illustrates
the process.
3 Optionally, change your form. For example, you can
easily remove a control that you dont need by right-
clicking the control and clicking Delete.
4 After you finish, save your work and theres your form.
10
-
7/29/2019 CURS 6 - Create Forms S
11/24Create forms
Create a split form with the Split Form tool
Split forms are a new
feature that can make
it easier to view, enter,and change single
records or large
amounts of data.
A split form combines a form with a datasheet. If you
only need to enter or change a single record, use the
form.
If you need to enter or view a lot of data, use the
datasheet.
11
-
7/29/2019 CURS 6 - Create Forms S
12/24Create forms
Create a split form with the Split Form tool
The picture shows
how to create a split
form.
1
2
In the Navigation Pane, select the table or query that you
want to use as the data source for the split form.
Click the Create tab, and in the Forms group, click Split
Form. Access creates the new form and opens it in
Layout view, which gives you a chance to change it.
12
-
7/29/2019 CURS 6 - Create Forms S
13/24Create forms
Create a split form with the Split Form tool
The picture shows
how to create a split
form.
3 Optionally, change your form. For example, you can
easily resize the controls by clicking and dragging.
13
-
7/29/2019 CURS 6 - Create Forms S
14/24
Create forms
Create a form with the Form Wizard
You use the Form
Wizard when you want
more control over aform than the other
tools provide.
For example, the Form Wizard allows you to group and
sort the fields in the form. It also allows you to use fields
from more than one table or query.
14
-
7/29/2019 CURS 6 - Create Forms S
15/24
Create forms
Create a form with the Form Wizard
Heres how to use the
Form Wizard.
1
2
On the Create tab, in the Forms group, click More
Forms, then click Form Wizard.
Use the first screen of the wizard to select the tables,
queries, and fields that serve as the data sources for
your form. Remember that if you use multiple data
sources, they must participate in a relationship.
15
-
7/29/2019 CURS 6 - Create Forms S
16/24
Create forms
Create a form with the Form Wizard
Heres how to use the
Form Wizard.
3 On the second screen of the wizard, select a layout,
such as tabular or stacked.
4 On the third screen, select a style. You can preview each
style by clicking it and seeing the results in the left-hand
pane.
16
-
7/29/2019 CURS 6 - Create Forms S
17/24
Create forms
Create a form with the Form Wizard
Heres how to use the
Form Wizard.
On the fourth screen, give your form a name and click
Finish.
5
17
-
7/29/2019 CURS 6 - Create Forms S
18/24
Create forms
Ways to change forms
Your new forms are
nice, but they arent
quite right. Youd liketo resize some fields,
rearrange some
others, and maybe
have your forms
display the currentdate and time.
No problem. Access provides two main tools for
changing a form Layout view and Design view.
You use Layout view to change the look and feel of a
form. Design view lets you do some tasks that Layout
view wont.
18
-
7/29/2019 CURS 6 - Create Forms S
19/24
Create forms
Ways to change forms
The picture shows
how to work with each
view.
1
2
To open a form in Layout view, go to the Navigation
Pane, right-click the form, and then click Layout View.
Use the commands on the Format and Arrange tabs.
For example, in the AutoFormat group, click a style to
apply it to the form.
19
-
7/29/2019 CURS 6 - Create Forms S
20/24
Create forms
Ways to change forms
The picture shows
how to work with each
view.
3 Follow the same steps to open a form in Design view.
4 Once youre there, you can do a number of things you
cant in Layout view, such as adding certain types of
controls to the form.
20
-
7/29/2019 CURS 6 - Create Forms S
21/24
Create forms
Suggestions for practice
1. Create a form by using the Form tool.
2. Use Layout view to change a form.
3. Change the text in, and the style of, a form.
4. Create a split form.
5. Create a form by using the Form Wizard.
6.Add a control to a form in Design view.
21
-
7/29/2019 CURS 6 - Create Forms S
22/24
Create forms
Test question 1
A split form offers the best way to do what? (Pick one
answer.)
1. View data from different sources.
2. Change the form without altering data in the underlying table.
3. Enter or view individual records and large amounts of data.
22
-
7/29/2019 CURS 6 - Create Forms S
23/24
Create forms
Test question 2
When you design a form, your goal is to do what? (Pick one
answer.)
1. Make the form logical and complete, meaning it captures all
the data you need.
2. Provide room for graphics, because they make your database
seem friendly.
3. Help users understand your data with just a glance.
23
-
7/29/2019 CURS 6 - Create Forms S
24/24
Create forms
Test question 3
What does binding a control do? (Pick one answer.)
1. Locks it so users cant enter text.
2. Connects it to an underlying table or query so users can enter
or change data.
3. Keeps it from moving when you resize the form.
24