Microsoft Office 2003- Illustrated Introductory, Premium Edition - PowerPoint PPT Presentation

Loading...

PPT – Microsoft Office 2003- Illustrated Introductory, Premium Edition PowerPoint presentation | free to download - id: 4a4b32-ZmNmN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Microsoft Office 2003- Illustrated Introductory, Premium Edition

Description:

Microsoft Office 2003- Illustrated Introductory, Premium Edition Using Forms Objectives Plan a form Create a form Move and resize controls Modify labels Objectives ... – PowerPoint PPT presentation

Number of Views:73
Avg rating:3.0/5.0
Slides: 23
Provided by: LisaFrie8
Learn more at: http://ranger.uta.edu
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Microsoft Office 2003- Illustrated Introductory, Premium Edition


1
Microsoft Office 2003- Illustrated Introductory,
Premium Edition
Using Forms
2
Objectives
  • Plan a form
  • Create a form
  • Move and resize controls
  • Modify labels

3
Objectives
  • Use text boxes for calculations
  • Modify tab order
  • Enter, edit, and print records
  • Insert an image

4
Planning a Form
  • Gather the source documents used to design your
    form
  • Determine the best type of control to use for
    each item on the form
  • Determine the underlying record source
  • Name the form

5
Types of Controls
  • Bound display data from underlying record
    source and used to edit and enter data
  • Unbound do not change from record to record and
    exist only to clarify and enhance the form

6
Types of Controls
7
Types of Controls
Bound object frame
Tab control
Text box
Combo box
Label
Option group
Toggle button
Option button
8
Types of Controls
Command button
Check box
Unbound object frame
List box
Rectangle
9
Creating a Form
  • Methods
  • Form Design View
  • Form Wizard
  • AutoForm
  • Chart Wizard
  • PivotTable Wizard

10
Creating a Form
Text box
Label
Check box
11
Moving and Resizing Controls
12
Form Design View Elements
Toolbox button
Field List button
Object list box
Label
Vertical ruler
Toolbox toolbar
Field list
13
Modifying Labels
Caption property
Selected label
14
Selecting more than one control
  • Click, Shiftclick
  • Drag a selection box
  • Click in the ruler
  • Drag in the ruler

15
Using Text Boxes for Calculations
Text Box
  • Calculations start with an equal sign
  • Field names are surrounded by square brackets
  • Example
  • Retail-Wholesale

16
Modifying Tab Order
  • Use the View, Tab Order menu option

17
Form Sections
18
Entering, Editing, and Printing Records
Form View Toolbar
New Record
Undo
Print all records
Find Record
Delete Record
19
Entering, Editing, and Printing Records
Next record
Last record
Navigation Toolbar
First record
New record
Previous record
Current record number
20
Editing a Record
Edit record symbol
21
Inserting an Image
  • Graphic image
  • Logo
  • Picture
  • Clip Art

Image
Unbound object frame
Bound object frame
22
Summary
  • Build forms to enter and edit data
  • Use Form Design View to build and modify forms
  • Every item on a form is called a control
  • Bound controls display data
  • Unbound controls clarify information
About PowerShow.com