Exercise3_Access

Exercise3_Access - DCS5078-Database Systems Exercise 3 Microsoft Access In the Access Workbench Assignments in Sections One and Two we created a

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

View Full Document Right Arrow Icon
Exercise 3: Microsoft Access In the “Access Workbench Assignments” in Sections One and Two, we created a database for the Wedgewood Pacific Corporation (WPC) of Seattle, Washington. In this set of assignments, we will: create and run queries against the database using Access QBE Using Access QBE, create and run queries to answer the questions that follow. Save each query using the query name format QBEQuery-AWA-3-## where the ## sign is replaced by the letter designator of the question. For example, the first query will be saved as SQLQuery-AWA-3-A. A. What projects are in the PROJECT table? Show all information for each project. Sample Output: B. What are the ProjectID, Name, StartDate, and EndDate values of projects in the PROJECT table? Sample Output: C. What projects in the PROJECT table started before August 1, 2005? Show all the information for each project. Sample Output:
Background image of page 1

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

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

This note was uploaded on 01/23/2011 for the course QSIS 343 taught by Professor Pike during the Spring '10 term at Duke.

Page1 / 4

Exercise3_Access - DCS5078-Database Systems Exercise 3 Microsoft Access In the Access Workbench Assignments in Sections One and Two we created a

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

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