CIT 105 EXAM REVIEW QUESTIONS AND
100% CORRECT ANSWERS!!
Another term used for the column selector feature is ____.
A. row selector
B. record selector
C. name selector
D. field selector
D. field selector
Clicking on the Close option from the Backstage view in Access 2016 performs which of the
following tasks?
A. closes the current database
B. closes the current database and exits Access 2016
C. closes only the current database object
D. copies the current database and exits Access 2016
A. closes the current database
Data organized as a collection of tables creates this type of data system.
A. database
B. database management system (DBMS)
,C. primary key system
D. relational database management system
D. relational database management system
Each column in an Access table datasheet represents a ____.
A. query
B. record
C. field
D. primary key
C. field
Each row in an Access table datasheet displays which of the following?
A. a query
B. a record
C. a field
D. a data type
B. a record
Experienced database developers avoid using spaces in field names and object names
because names with spaces might cause errors if the objects are involved in ____.
A. creating reports using Access
, B. related databases
C. programming tasks
D. queries
C. programming tasks
Files created with Access 2016 may be used with which previous version of Access?
A. Access 2010
B. Access 2000
C. Access 2005
D. Access 2003
A. Access 2010
How many characters may a field name in Access contain including numbers, letters,
spaces, and special characters?
A. 255
B. 36
C. 64
D. 146
C. 64
In a relational DBMS, a user may create a database structure that contains which of the
following?
100% CORRECT ANSWERS!!
Another term used for the column selector feature is ____.
A. row selector
B. record selector
C. name selector
D. field selector
D. field selector
Clicking on the Close option from the Backstage view in Access 2016 performs which of the
following tasks?
A. closes the current database
B. closes the current database and exits Access 2016
C. closes only the current database object
D. copies the current database and exits Access 2016
A. closes the current database
Data organized as a collection of tables creates this type of data system.
A. database
B. database management system (DBMS)
,C. primary key system
D. relational database management system
D. relational database management system
Each column in an Access table datasheet represents a ____.
A. query
B. record
C. field
D. primary key
C. field
Each row in an Access table datasheet displays which of the following?
A. a query
B. a record
C. a field
D. a data type
B. a record
Experienced database developers avoid using spaces in field names and object names
because names with spaces might cause errors if the objects are involved in ____.
A. creating reports using Access
, B. related databases
C. programming tasks
D. queries
C. programming tasks
Files created with Access 2016 may be used with which previous version of Access?
A. Access 2010
B. Access 2000
C. Access 2005
D. Access 2003
A. Access 2010
How many characters may a field name in Access contain including numbers, letters,
spaces, and special characters?
A. 255
B. 36
C. 64
D. 146
C. 64
In a relational DBMS, a user may create a database structure that contains which of the
following?
