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)
