MISY 5325 COMPREHENSIVE QUESTIONS AND
ANSWERS SET A+
✔✔True or False
To make major changes to your form or report you can use Layout view. To make minor
changes you can use Design view - ✔✔False
Layout view - minor changes
Design view - major changes
✔✔What does the arrow with a yellow star do on the Record locator - ✔✔adds new one
✔✔When adding a combo box to look up data from another table what must be selected
- ✔✔the Primary Key
✔✔True or False
Two Buttons can have the same name - ✔✔False
No two buttons can have the same name
✔✔When a Primary key has more than one field this is called - ✔✔multi-attribute key
✔✔Any Macro that is automatically executed upon opening is named - ✔✔AutoExec
✔✔ accdb - ✔✔access database
✔✔True or False: By default the database will automatically create Report 1. - ✔✔False
It will automatically create Table 1
✔✔What are the objects in the Create Tab in Access? - ✔✔Table
Queries
, Forms
Reports
Macros & Code
✔✔Table object - ✔✔used to store data
✔✔Query object - ✔✔used to retrieve data from the table efficiently
✔✔Forms object - ✔✔used to interact with data in table to either add data, modify data,
or delete data
✔✔Report object - ✔✔used to present data neatly
✔✔Macros object - ✔✔is a series of programming that allows us to run or execute any
objects.
✔✔True or False:
Data Type Short Text can store any characters that are shorter than 245 characters -
✔✔False
shorter than 255 characters
✔✔True or False
Data Type Long Text can store an unlimited amount of characters - ✔✔True
✔✔True or False
Data Type Number can store only number data but can not be calculated - ✔✔False
stores only number and can be calculated
✔✔True or False
Data Type Date/Time can store data about time or date - ✔✔True
✔✔True or False
Data Type Currency is similar to number except that ti will be formatted with 2 decimal
place, dollar sign, and 1000 comma separator. - ✔✔True
✔✔True or False
Data Type Auto Number you will have to manually generate a number - ✔✔False
number will automatically generate
✔✔True or False:
ANSWERS SET A+
✔✔True or False
To make major changes to your form or report you can use Layout view. To make minor
changes you can use Design view - ✔✔False
Layout view - minor changes
Design view - major changes
✔✔What does the arrow with a yellow star do on the Record locator - ✔✔adds new one
✔✔When adding a combo box to look up data from another table what must be selected
- ✔✔the Primary Key
✔✔True or False
Two Buttons can have the same name - ✔✔False
No two buttons can have the same name
✔✔When a Primary key has more than one field this is called - ✔✔multi-attribute key
✔✔Any Macro that is automatically executed upon opening is named - ✔✔AutoExec
✔✔ accdb - ✔✔access database
✔✔True or False: By default the database will automatically create Report 1. - ✔✔False
It will automatically create Table 1
✔✔What are the objects in the Create Tab in Access? - ✔✔Table
Queries
, Forms
Reports
Macros & Code
✔✔Table object - ✔✔used to store data
✔✔Query object - ✔✔used to retrieve data from the table efficiently
✔✔Forms object - ✔✔used to interact with data in table to either add data, modify data,
or delete data
✔✔Report object - ✔✔used to present data neatly
✔✔Macros object - ✔✔is a series of programming that allows us to run or execute any
objects.
✔✔True or False:
Data Type Short Text can store any characters that are shorter than 245 characters -
✔✔False
shorter than 255 characters
✔✔True or False
Data Type Long Text can store an unlimited amount of characters - ✔✔True
✔✔True or False
Data Type Number can store only number data but can not be calculated - ✔✔False
stores only number and can be calculated
✔✔True or False
Data Type Date/Time can store data about time or date - ✔✔True
✔✔True or False
Data Type Currency is similar to number except that ti will be formatted with 2 decimal
place, dollar sign, and 1000 comma separator. - ✔✔True
✔✔True or False
Data Type Auto Number you will have to manually generate a number - ✔✔False
number will automatically generate
✔✔True or False:
