Recitation9-Access_queries-part1

Recitation9-Access_queries-part1 - ITM 309 Spring 2011...

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

View Full Document Right Arrow Icon
ITM 309 Spring 2011 Database: Access In-Class Practice II Recitation #9: Queries in Microsoft Access March 16/17 Objective: Be able to create queries to extract information from an Access database Instructions: a) Download the practice database: ANGEL Lessons Recitation Info Recitation #9 Queries File b) Save it in your P: Drive c) Launch Access ; File Open Select “inclassquery.accdb” from your P: Drive Before you start creating the queries, familiarize yourself with the tables - take note of the fields in each of them and the relationships between the tables. As we discussed in class, before you can do queries that involve multiple tables, you’ll need todefine foreign keys which, in access, is done by mapping the table relationships visually Hint: These queries will be a “map” to guide you in your work on Assignment #3 Part One: Table relationships are how we define foreign keys in MS Access. Without foreign keys, we
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.

Page1 / 2

Recitation9-Access_queries-part1 - ITM 309 Spring 2011...

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