Module_J_for_Office_2003

Module_J_for_Office_2003 - EX TEND ED L E ARN IN G MOD UL E...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
EXTENDED LEARNING MODULE J IMPLEMENTING A DATABASE WITH MICROSOFT ACCESS Student Learning Outcomes Identify the steps necessary to implement the structure of a relational database using the data deF nition language provided by Microsoft Access. Demonstrate how to use the data manipulation subsystem in Access to enter and change information in a database and how to query that information. Explain the use of the application generation subsystem in Access to create reports and data entry screens. 1. 2. 3.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
J.2 Extended Learning Module J Introduction In Chapter 3, we discussed the important role that databases play in an organization. We followed that with Extended Learning Module C, in which you learned how to design the correct structure of a relational database. That module includes four primary steps. They are: DeF ne entity classes and primary keys. DeF ne relationships among the entity classes. DeF ne information (F elds) for each relation (the terms relation and table are often used to refer to a F le in the context of a database). Use a data deF nition language to create your database. In Extended Learning Module C, you followed the process through the F rst three steps above. In this module, we’ll take you through the fourth step—using a data deF - nition language to create your database—by exploring the use of Microsoft Access, to- day’s most popular personal database management system package (it comes as part of Microsoft’s OfF ce suite). We’ll also show you how to use Microsoft Access’s data manipulation subsystem, in- cluding how to enter and change information and build queries; and how to use the ap- plication generation subsystem to create reports and input forms. In ±igure J.1 (on this page and the next) we’ve recreated the complete Solomon Enterprises database structure we deF ned in Extended Learning Module C. If it has been a while since you covered that module, we suggest that you review it before creating the database. 1. 2. 3. 4. Figure J.1 The Database Structure We’ll Be Implementing ( continued on the next page ) CONCRETE TYPE RELATION CUSTOMER RELATION 1234 2345 3456 4567 5678 6789 Smelding Homes Home Builders Superior Mark Akey Triple A Homes Sheryl Williamson Home Makers Customer Phone 3333333333 3334444444 3335555555 3336666666 3337777777 3338888888 Customer Primary Contact Bill Johnson Marcus Connolly Mark Akey Janielle Smith Sheryl Williamson John Yu Concrete Type Type Description 1 2 3 4 5 Home foundation and walkways Commercial foundation and walkways Premier speckled (with smooth gravel aggregate) Premier marble (with crushed marble aggregate) Premier shell (with shell aggregate) Customer Number Customer Name EMPLOYEE RELATION 123456789 435296657 785934444 984568756 Johnson Evaraz Robertson Smithson Employee First Name Emilio Antonio John Allison Date of Hire 2/1/1985 3/3/1992 6/1/1999 4/1/1997 Employee ID Employee Last Name haa02915_modJ cd.indd 2 haa02915_modJ cd.indd 2 9/14/07 6:55:36 PM 9/14/07 6:55:36 PM
Background image of page 2
Introduction J.3 Raw Material ID B C A B C A B C A D B C A E B C A F Unit 1 2 1.5 1 2 1 1 2 1.5 3 1 2 1.5 2 1 2 1.5 2.5 BILL OF MATERIAL RELATION Concrete Type 1 1 1 2 2 2 3 3 3 3 4 4
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 35

Module_J_for_Office_2003 - EX TEND ED L E ARN IN G MOD UL E...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online