Simnet Chapter 10

Simnet Chapter 10 - Simnet Chapter 10 Query: Quick and easy...

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

View Full Document Right Arrow Icon
Simnet Chapter 10 Query: Quick and easy way to produce output; allows you to produce a list of all your data or just a subset of your data. o A Set of instructions that specifies: which data items will appear in the output What the order of those items should be Any calculations performed on the data Formatting to be applied to the selected data. o Instructions for producing the output rather than the output itself. When creating a query it is important that you know: o Which fields should be included in the output o Which tables do those fields come from o Which records should be included in the output o What order should the records be in Query Grid: bottom portion of the query design view; where you specify all the instructions to select the proper columns and rows for your output, the order of the rows, and any calculations you may need. Sorting simply puts the rows, also called records, in some order. Primary sort key:
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 11/29/2011 for the course ACIS 1504 taught by Professor Jmlacoste during the Fall '07 term at Virginia Tech.

Page1 / 2

Simnet Chapter 10 - Simnet Chapter 10 Query: Quick and easy...

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