MISY - Final Exam question n answers 2023/2024 verified to pass

MISY - Final Exam A field which allows a user to choose a value from a drop down list while entering in data in a table is referred to as a ________________ A. combo field B. lookup field C. multi-attribute field D. composite field E. None of the Above - correct answer B Descending is a sorting order that arranges text in alphabetical order (A to Z) or numbers from lowest to highest. True False - correct answer F In a report, a Text Box icon under the Control object group can be used to add a calculated field. True False - correct answer T If it is expected that the data in one field will contain the same data, it will be helpful to set a ______________ for that field. A. validation B. indexing C. autofill D. default value E. None of the above - correct answer D When creating a Lookup field in the table, developers must choose only one value for a Lookup field. True False - correct answer F Once a report was created, a user can click on _________ icon to add more fields to a report. A. Add existing fields B. Property Sheet C. Additional field D. Text box E. None of the above - correct answer A Combo boxes can be used for all of the following except? A. Allows a user to type in values B. Gets values from a table C. Stores data into a table D. Finds a record based on a value E. None of the above - correct answer E All changes made to the Design View of a table will be automatically saved. True False - correct answer F To make changes directly into the subform, the main form should be closed. True False - correct answer T Developers can create a command button which is linked to a macro and runs the macro when that button is clicked. True False - correct answer T A query can be created to ______________________________ A. retrieve the data B. calculate the data C. create a new field D. A and B E. All of the above - correct answer E To run a macro from the left navigation pane, users can: A. Double click B. Right-click and click Perform C. Right-click and click Execute D. A and C E. All of the above - correct answer A The data type of a field used to store an image file has to be __________ A. Picture object B. Image object C. Photo object D. OLE Object E. None of the above - correct answer D To expand a section of a report, developers can do it in Design View by grabbing the bottom border of the section and drag it down. True False - correct answer T Users can increase or decrease column width and row height in a report under ___________ . A. Report View