Misy final excel access Study guides, Class notes & Summaries

MISY Final Excel AccessWhat is primary key? - correct answer field or set of fields with values that are unique throughout a table What data type is the most appropriate for the field? - correct answer Each record is unique (auto number?, short text) How do you connect tables? - correct answer Find a common field Structure of IIf function - correct answer =IIf([AirportCode]="ORD","Chicago",IIf([AirportCode]="ATL","Atlanta",IIf([AirportCode]="SEA","Seattle","Other"))) St...

MISY Final Excel Access questions with complete solutions 2024

MISY Final Excel AccessWhat is primary key? - correct answer field or set of fields with values that are unique throughout a table What data type is the most appropriate for the field? - correct answer Each record is unique (auto number?, short text) How do you connect tables? - correct answer Find a common field Structure of IIf function - correct answer =IIf([AirportCode]="ORD","Chicago",IIf([AirportCode]="ATL","Atlanta",IIf([AirportCode]="SEA","Seattle","Other"))) St...

MISY 5325 Final 1-70 Questions and Answers Graded A 1. To combine criteria with ———— place the criteria on the same row. AND 2. To compact and repair a database, tap or click ———— button in the Info gallery in the Backstage view. Compact & Repair 3. To create a crosstab, click the———— button on the CREATE tab. crosstab, Query Wizard 4. To create a lookup field, select ————- from the menu of available data types. Lookup Wizard 5. To create a multivalued field, ...