Simplify Data Entry with Forms in MIS - Chapter 3 Overview
I
n
t
r
o
t
o
M
I
S
-
M
G
S
3
5
1
Simplify Data Entry with Forms
Chapter 3
C
h
a
p
t
e
r
O
v
e
r
v
i
e
w
Designing Forms
Working with Forms
Form, Layout and Design View
Form Controls
Form Wizard Example
Form Controls and Properties
Forms are used for displaying
data, entering data or used as part
of a menu system
Basic, Multiple Item and Split Forms
Built upon tables or queries
F
o
r
m
s
F
o
r
m
V
i
e
w
Displays data on the form and allows
updates and edits of the form data.
Cannot make updates to the form
layout and design. Database end
user uses this view.
F
o
r
m
V
i
e
w
L
a
y
o
u
t
V
i
e
w
Most flexible way to work with and
modify a form. Displays the data
while allowing you to modify the form
design. Cannot update form data.
L
a
y
o
u
t
V
i
e
w
D
e
s
i
g
n
V
i
e
w
Most powerful view used to modify the
layout, design and content of a form.
Cannot view or edit data in this view.
D
e
s
i
g
n
V
i
e
w
Combo Box
Command
Button
Checkbox
Textboxes
Labels
C
o
n
t
r
o
l
s
Combo Box
Command
Button
Checkbox
Textboxes
Labels
C
o
n
t
r
o
l
s
B
o
u
n
d
C
o
n
t
r
o
l
s
(
H
i
g
h
l
i
g
h
t
e
d
)
U
n
b
o
u
n
d
C
o
n
t
r
o
l
s
C
a
l
c
u
l
a
t
e
d
C
o
n
t
r
o
l
s
F
o
r
m
W
i
z
a
r
d
Use it! Very useful as a starting
point for building a form. Provides
a framework you can customize
and build upon.
Consistent look and feel
Easy to read
Pleasant to look at
Displays all relevant information
Intuitive navigation
D
e
s
i
g
n
i
n
g
F
o
r
m
s
Form Wizard Example
Design View
Field List, Property Sheet, Controls
Tool Box
Adding Controls
Combo Boxes
Tab Stops
M
o
d
i
f
y
i
n
g
F
o
r
m
s
Click upper left corner to view properties for entire
report. Record source property is in the Data tab. Click
build button to view the report record source.
I
d
e
n
t
i
f
y
i
n
g
t
h
e
R
e
c
o
r
d
S
o
u
r
c
e
F
o
r
m
a
t
t
i
n
g
F
o
r
m
s
Selecting bound controls & labels
Sizing a control
Moving a control and its label
Changing properties of a control
Selecting multiple controls
A
d
d
i
t
i
o
n
a
l
F
o
r
m
C
o
n
t
r
o
l
s
Drop down list boxes
Check Boxes
Option Groups
Command Buttons
Q
u
i
c
k
R
e
v
i
e
w
A(n) ________ control on a form
has an expression or formula as
its data source.
Q
u
i
c
k
R
e
v
i
e
w
Using the Lookup Wizard for a field
in a table, will result in a
________ ________ displaying
on a form based off of that field.
Q
u
i
c
k
R
e
v
i
e
w
True / False
Updating form data will update the
associated data record in the
corresponding table.
H
o
m
e
w
o
r
k
2
Chapter 3 Guided Exercise
Chapter 3 Applied Exercise
Explore the world of forms in Management Information Systems (MIS) to streamline data entry processes. Learn about designing and utilizing forms effectively, including different form types, form views, controls, and the form wizard. Discover how form views, layout views, and design views contribute to efficient data management in MIS. Dive into the details of labels, textboxes, combo boxes, checkboxes, command buttons, bound and unbound controls, as well as calculated controls. Enhance your understanding of form creation by utilizing the Form Wizard as a valuable starting point for developing customized forms.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Intro to MIS - MGS351 Simplify Data Entry with Forms Chapter 3
Chapter Overview Designing Forms Working with Forms Form, Layout and Design View Form Controls Form Wizard Example Form Controls and Properties
Forms Forms are used for displaying data, entering data or used as part of a menu system Basic, Multiple Item and Split Forms Built upon tables or queries
Form View Displays data on the form and allows updates and edits of the form data. Cannot make updates to the form layout and design. Database end user uses this view.
Layout View Most flexible way to work with and modify a form. Displays the data while allowing you to modify the form design. Cannot update form data.
Design View Most powerful view used to modify the layout, design and content of a form. Cannot view or edit data in this view.
Controls Labels Textboxes Combo Box Checkbox Command Button
Controls Labels Textboxes Combo Box Checkbox Command Button
Form Wizard Use it! Very useful as a starting point for building a form. Provides a framework you can customize and build upon.
Designing Forms Consistent look and feel Easy to read Pleasant to look at Displays all relevant information Intuitive navigation
Modifying Forms Design View Field List, Property Sheet, Controls Tool Box Adding Controls Combo Boxes Tab Stops
Identifying the Record Source Click upper left corner to view properties for entire report. Record source property is in the Data tab. Click build button to view the report record source.
Formatting Forms Selecting bound controls & labels Sizing a control Moving a control and its label Changing properties of a control Selecting multiple controls
Additional Form Controls Drop down list boxes Check Boxes Option Groups Command Buttons
Quick Review A(n) ________ control on a form has an expression or formula as its data source.
Quick Review Using the Lookup Wizard for a field in a table, will result in a ________ ________ displaying on a form based off of that field.
Quick Review True / False Updating form data will update the associated data record in the corresponding table.
Homework 2 Chapter 3 Guided Exercise Chapter 3 Applied Exercise
