Access.05 - COMPREHENSIVE Access Tutor ial 5 Creating...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: COMPREHENSIVE Access Tutor ial 5 Creating Advanced Quer ies and Enhancing Table Design New Per spectives on M icr osoft Office Access 2007 2 Objectives • Review table and object naming standards • Use the Like, I n, Not, and & operators in queries • Filter data using an AutoFilter • Use the I I f function to assign a conditional value to a calculated field in a query • Create a parameter query New Per spectives on M icr osoft Office Access 2007 3 Objectives • Use query wizards to create a crosstab query, a find duplicates query, and a find unmatched query • Create a top values query • Modify table designs using lookup fields, input masks, and data validation rules • I dentify object dependencies • Review a Memo field’s properties • Designate a trusted folder New Per spectives on M icr osoft Office Access 2007 4 Reviewing the Panorama Database New Per spectives on M icr osoft Office Access 2007 5 Using a Pattern Match in a Query • A patter n match selects records with a value for the designated field that matches the pattern of the simple condition value • The Like compar ison oper ator selects records by matching field values to a specific pattern that includes one or more of these wildcard characters: asterisk (*), question mark (?), and number symbol (#) New Per spectives on M icr osoft Office Access 2007 6 Using a List-of-Values Match in a Query • A list-of-values match selects records whose value for the designated field matches one of two or more simple condition values • The I n compar ison oper ator lets you define a condition with a list of two or more values for a field New Per spectives on M icr osoft Office Access 2007 7 Using the Not Operator in a Query • The Not logical oper ator negates a criterion or selects records for which the designated field does not match the criterion New Per spectives on M icr osoft Office Access 2007 8 Using an AutoFilter to Filter Data New Per spectives on M icr osoft Office Access 2007 9 Assigning a Conditional Value to a Calculated Field • The & (amper sand) oper ator is a concatenation...
View Full Document

This note was uploaded on 06/15/2011 for the course TSTM E264 taught by Professor Crews during the Fall '09 term at South Carolina.

Page1 / 32

Access.05 - COMPREHENSIVE Access Tutor ial 5 Creating...

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

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