Microsoft Access 2003 Specialist

1
Microsoft Access 2003 - Specialist
Chapter 8
CREATING WEB PAGES AND USING DATABASE WIZARDS
2
Performance Objectives

• Save a table as a Web page
• Apply a theme to a Web page
• Create hyperlinks in a Web page
• Create a database with sample data using a
  Database Wizard
• Manipulate data within the database file

3
Saving a Table as a Web Page
open database file
double-click
click Pages
4
Saving a Table as a Web Page/2
select fields
click
5
Saving a Table as a Web Page/3
select grouping levels
click
6
Saving a Table as a Web Page/4
select sort order
click
7
Saving a Table as a Web Page/5
type a title
click
8
Applying a Theme to a Web Page
Format, Theme
select a theme
preview
9
Previewing a Web Page
File, Web Page Preview
10
Creating Hyperlinks
display Web page in Design view
OR
Insert, Hyperlink (Ctrl K)
click Hyperlink button
drag in the window to create a box
11
Creating Hyperlinks/2
type the text you want to display in the page
type the Web site URL
If you type a URL in a label, Access converts the
URL to a hyperlink.
12
Creating a Database with a Wizard
File, New (Ctrl N)
OR
click
13
Creating a Database with a Wizard/2
double-click the desired wizard
Database Wizards available for creating database
files
14
Creating a Database with a Wizard/3
select drive/folder
press Enter or click Create
type a name
15
Creating a Database with a Wizard/4
displays information on what the database will
store
click
16
Creating a Database with a Wizard/5
provides predesigned tables and fields
click
17
Creating a Database with a Wizard/6
select the desired screen display
click
18
Creating a Database with a Wizard/7
select the desired style for printed reports
click
19
Creating a Database with a Wizard/8
type a title
click
20
Creating a Database with a Wizard/9
click
21
Manipulating Data
When the database is completed, a Main
Switchboard displays.
You can choose to enter or view products, enter
or view other information in the database,
preview reports, change the switchboard items, or
exit the database.
22
Features Summary
How do you display the New File task pane?
OR
File, New (Ctrl N)
23
Features Summary
How do you display the Templates dialog box?
OR
File, New (Ctrl N)
click
24
Features Summary
How do you display the Theme dialog box?
Format, Theme
25
Features Summary
How do you preview a Web page?
File, Web Page Preview
26
Features Summary
How do you display the Hyperlink dialog box?
OR
Insert, Hyperlink (Ctrl K)
click Hyperlink button
27
Coming Next
Workplace Ready
ASSESSING PROFICIENCY