Module_5_Exercises_-_MS_Office_2007

Module_5_Exercises_-_MS_Office_2007 - Module 5 Exercises...

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

View Full Document Right Arrow Icon
115.107 Management Information Systems Module 5 Exercises Page 1 Module 5 Exercises 1 Topic Query relational databases using Query by Example and SQL query languages. Create database reports in MS Access. 2 Relevance to Assignments These exercises will prepare you for completing Part 3 of the Assignment. 3 Exercises Queries are used to describe which data is to be retrieved from the database. Queries are used to realize business requirements for retrieving data needed in transaction processing or decision support. Database reports format and style data obtained via queries for presentation purposes. The exercises to follow use the RealEstate.mdb database you downloaded with this document. The ER model and the relational model for this database are given below. You will find that ER diagrams are quite useful when you need to join data of several entity types. House Offer Client Agency 1 0..* 1 0..* 1 0..* 0..* 1..* makes for via listed with
Background image of page 1

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

View Full DocumentRight Arrow Icon
115.107 Management Information Systems Module 5 Exercises Page 2 Table Columns Primary Key Comments ClientTbl name, phoneNumber, id id HouseTbl address, id id AgencyTbl name, phoneNumber name listedWithTbl houseId, agencyName houseId, agencyName houseId is a foreign key into HouseTbl, while agencyName is a foreign key into AgencyTbl OfferTbl date, id, amount, clientId, houseId, agencyName id clientId is a foreign key into ClientTbl, houseId is a foreign key into HouseTbl, and agencyName is a foreign key into AgencyTbl. 3.1 Creating a select query You can create a select query by using the Query Wizard or by working in Design view. Some design elements are not available when you use the wizard, but you can add these elements later by using Design view. Although the two methods are somewhat different from each other, the basic steps are essentially the same: 1) Choose the tables or queries that you want to use as sources of data. 2) Specify the fields that you want to include from the data sources. 3) Optionally, specify criteria to limit the records that the query returns. After you have created a select query, you run it to see the results. To run a select query, you open it in
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/01/2010 for the course PN 178.328 taught by Professor Sue during the Spring '10 term at Massey Palmerston North.

Page1 / 9

Module_5_Exercises_-_MS_Office_2007 - Module 5 Exercises...

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

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