How To: Access Lab 7

R. Craig Collins > BCIS 1305/ITSC 1309 > How To: Access Lab 7

Project
Logical operators < + > like,
such as the criteria for Cost
>10 will show only records that are greater than $10
<20 will show only records that are less than $20
such as the criteria for State
="TX" will show only records where the State is TX
="N*" will show only records where the State name begins with N, such as NM

A parameter query might be for State
the criteria could be
[Which State are you looking for?]
and you would be prompted to provide a State name when you run the query

Calculated Fields is a field that can be added to a query to compute data in other fields.
   • Step 1 Place your insertion point in the first open column,
   • Step 2 right click, and choose Zoom.
   • Step 3 Type in what you want to call this new field, followed by a colon (;), and then the math to be performed
                   Item 4: If using a field for one of the values, place that field name in brackets, spelled exactly as the field name
   Example: to take the value in that record for Cost, and adding 1 to it would be
    NewFieldName:[Cost]+1
Calculated field