Transcript Chapter 4 PowerPoint Slides

DAVID M. KROENKE and DAVID J. AUER
DATABASE CONCEPTS, 3rd Edition
The Access Workbench: Section Four
Prototyping with Microsoft Access
Section Objectives
 Illustrate how to use Microsoft Access
as a prototyping tool
KROENKE and AUER - DATABASE CONCEPTS (3rd Edition)
© 2008 Pearson Prentice Hall
AW-4-2
Access as a Prototyping Tool
• Since it is relatively easy to create mockups of forms and reports using Microsoft
Access wizards, such mock-ups are often
developed even in situations where
Access is not going to be used as the
operational DBMS
• The mock-ups are used as a prototyping
tool to demonstrate the consequences of
data modeling decisions
KROENKE and AUER - DATABASE CONCEPTS (3rd Edition)
© 2008 Pearson Prentice Hall
AW-4-3
The WMCRM Database as a Data Model
KROENKE and AUER - DATABASE CONCEPTS (3rd Edition)
© 2008 Pearson Prentice Hall
AW-4-4
The Modified WMCRM Data Model
KROENKE and AUER - DATABASE CONCEPTS (3rd Edition)
© 2008 Pearson Prentice Hall
AW-4-5
The Original WMCRM Database:
Relationships Window
NickName is a foreign key
linking to SALEPERSON
1:N relationship between
SALESPERSON and
CUSTOMER
KROENKE and AUER - DATABASE CONCEPTS (3rd Edition)
© 2008 Pearson Prentice Hall
AW-4-6
The Original WMCRM Database:
The WMCRM Salesperson Contacts Form
SALESPERSON data
CUSTOMER data—use the
record buttons to move
between CUSTOMERs
associated with the current
SALESPERSON
CONTACT data—only the
data for the current
CUSTOMER is shown
SALESPERSON record
buttons—use these to
move between
SALESPERSON records
KROENKE and AUER - DATABASE CONCEPTS (3rd Edition)
© 2008 Pearson Prentice Hall
AW-4-7
The Modified WMCRM Database:
Relationships Window
1:N relationship between
SALESPERSON and
CONTACT
KROENKE and AUER - DATABASE CONCEPTS (3rd Edition)
© 2008 Pearson Prentice Hall
NickName is a foreign key
linking to SALEPERSON
AW-4-8
The Modified WMCRM Database:
The WMCRM Salesperson Contacts Form
SALESPERSON data
CONTACT data area now
includes CUSTOMER data
as well as CONTACT
data— each CONTACT
shows which CUSTOMER
was contacted
CONTACT record
buttons—use these to
move between CONTACT
records
SALESPERSON record
buttons—use these to
move between
SALESPERSON records
KROENKE and AUER - DATABASE CONCEPTS (3rd Edition)
© 2008 Pearson Prentice Hall
AW-4-9
The Access Banded Form and Report Editors
• Access uses banded form and report editors
– Each element of the form or report is displayed in its
own band such as Header, Detail, or Footer, which
makes such rearranging very easy to do.
– These can be resized as necessary, as can the size of
the entire form or report itself
– The size and position of any subform area within the
report can also be resized
– The labels and text boxes that display the data can be
moved or resized using standard windows drag-anddrop actions
– Label text can be edited, and additional labels or other
text added
KROENKE and AUER - DATABASE CONCEPTS (3rd Edition)
© 2008 Pearson Prentice Hall
AW-4-10
The Access Banded Form Editor
SALESPERSON portion of
the form–note the Form
Header, Detail and Form
Footer bands
CONTACT subform—again
note the Form Header,
Detail and Form Footer
bands
Labels and data text boxes
can be moved and resized
as necessary to arrange the
form as desired
The size of the form itself
and the size of the
subform within the form
can be adjusted as
needed
KROENKE and AUER - DATABASE CONCEPTS (3rd Edition)
© 2008 Pearson Prentice Hall
AW-4-11
DAVID M. KROENKE and DAVID J. AUER
DATABASE CONCEPTS, 3rd Edition
End of Presentation on The Access Workbench: Section Four
Prototyping with Microsoft Access