Test02_review

Test02_review - Gabelli School of Business Roger Williams...

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

View Full Document Right Arrow Icon
CIS102 Database and the Web McKenzie Gabelli School of Business – Roger Williams University, Bristol RI PA02 Review – Queries (Cha 7) 21 st Century
Background image of page 1

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

View Full DocumentRight Arrow Icon
CIS102 Database and the Web McKenzie Gabelli School of Business – Roger Williams University, Bristol RI Queries Queries build using Design View Provides a grid Above the grid is the sketch of the tables with fields and relationships Select fields by “double-clicking”
Background image of page 2
CIS102 Database and the Web McKenzie Gabelli School of Business – Roger Williams University, Bristol RI Simple Query Select Fields Determine sort fields and sort order Determine criteria Run Click the ! Go to datasheet view
Background image of page 3

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

View Full DocumentRight Arrow Icon
CIS102 Database and the Web McKenzie Gabelli School of Business – Roger Williams University, Bristol RI AND Query AND is restrictive – all criteria must be met. Select fields and multiple criteria Alternatively use AND
Background image of page 4
CIS102 Database and the Web McKenzie Gabelli School of Business – Roger Williams University, Bristol RI
Background image of page 5

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

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

Page1 / 11

Test02_review - Gabelli School of Business Roger Williams...

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

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