Null Fields are fields in a record does not contain any information at all A field in a record that contains any data at all-even a single space-is nonnull To combine nonnull LastName and FirstName fields, you can use the expression LastName & “, “ & FirstName The & (ampersand) operator is a concatenation operator that joins text expressions Concatenation refers to joining two or more text fields or characters encapsulated in quotes New Perspectives on Microsoft Access 2013ġ6 Assigning a Conditional Value to a Calculated Field (Cont.) You can use the AutoFilter feature to choose restrictions faster and with more flexibility than using the condition and Or logical operator New Perspectives on Microsoft Access 2013ġ4 Using an AutoFilter to Filter Data (Cont.)ġ5 Assigning a Conditional Value to a Calculated Field The Not logical operator negates a criterion or selects records for which the designated field does not match the criterion New Perspectives on Microsoft Access 2013 The word immediately after the three-character prefix begins with an upper case letter Using object prefix tags, you can readily identify the object type, even when the objects have the same base name Object names have no spaces, because other database management systems do not permit making it easy during conversions to those systems New Perspectives on Microsoft Access 2013Ī pattern match selects records with a value for the designated field that matches the pattern of a simple condition value The Like comparison operator 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 (#) The asterisk represents any string of characters, the question mark represents any single character, and the number symbol represents any single digit New Perspectives on Microsoft Access 2013ġ0 Using Pattern Match in a Query (Cont.)ġ1 Using a List-of-Values Match in a QueryĪ list-of-values match selects records whose value for the designated field matches one of two or more simple condition values Could include several Or conditions in the design grid, but there is an easier and clearer way to do this The In comparison operator lets you define a condition with a list of two or more values for a field that select and include those record in the query results New Perspectives on Microsoft Access 2013ġ2 Using the Not Logical Operator in a Query The Navigation Pane displays the objects grouped by object type Each object name has a prefix tag-a tbl prefix tag for tables, a qry prefix tag for queries, a frm prefix tag for forms, and a rpt prefix tag for reports All three characters in each prefix tag are lower case. New Perspectives on Microsoft Access 2013ħ Creating Advanced Queries and Enhancing Table Design (Cont.) Modify table designs using lookup fields, input masks, and data validation rules Identify object dependencies Review a Long Text field’s properties Designate a trusted folder New Perspectives on Microsoft Access 2013ĥ Creating Advanced Queries and Enhancing Table DesignĬase - Chatham Community Health Services Making the Clinic Database Easier to Use User is interested in taking better advantage of the power of Access to make the database easier to use and to create more sophisticated queries User also needs a summarized list of invoice amounts by city New Perspectives on Microsoft Access 2013Ħ Creating Advanced Queries and Enhancing Table Design (Cont.)
Use query wizards to create a crosstab query, a find duplicates query, and a find unmatched query Create a top values query New Perspectives on Microsoft Access 2013 Use the Like, In, Not, and & operators in queries Filter data using an AutoFilter Use the IIf function to assign a conditional value to a calculated field in a query Create a parameter query New Perspectives on Microsoft Access 2013
1 Tutorial 5 Creating Advanced Queries and Enhancing Table DesignĢ Objectives Session 5.1 Review object naming standards
0 kommentar(er)
