Access Test UPDATED Exam Questions and
CORRECT Answers
A relationship between two tables in a database is formed using an backstage field? - CORRECT
ANSWER - False
Which Access feature provides information about Access commands, features, and instructions -
CORRECT ANSWER - Access Help
Which Ribbon group allows you to add fields to an Access table with defined data types -
CORRECT ANSWER - Add & Delete
Files created with Access 2013 may be used with which previous version of Access - CORRECT
ANSWER - Access 2010
The accompanying figure shows the first dialog box for the - CORRECT ANSWER -
Simple Query Wizard
The appearance of non-theme fonts, colors, and effects remains unchanged no matter which
theme is applied to the workbook - CORRECT ANSWER - True
What is the maximum character length of a field name? - CORRECT ANSWER - 64
Which data type would be the best logical data type for a field named PaidDate? - CORRECT
ANSWER - Date/Time
Formatting Date/Time fields changes only the way data is displayed, not the field __________ -
CORRECT ANSWER - values
In the accompanying figure the field size is set to - CORRECT ANSWER -5
, A database or a relational database is a collection of related tables - CORRECT
ANSWER - True
Which Access 2013 view shows the contents of a table as a datasheet? - CORRECT
ANSWER - Datasheet View
The appearance of non theme fonts colors and effects remains unchanged no matter which theme
- CORRECT ANSWER - True
The format painter does not copy formatting applied to selected text within a cell and it does not
copy data - CORRECT ANSWER - True
In the accompanying figure the top portion of the table window indicated by the red bracket is
the - CORRECT ANSWER - Table Design Grid
The accompanying figure illustrates the design view which allows the user to modify a table
structure - CORRECT ANSWER - Design View
Which of the following would be a likely reason that an import process from excel to access
might fail? - CORRECT ANSWER - The access field names and the excel worksheet
column headings do not match
A value set in the Field Properties pane that appears in a field automatically is the default value
for the field - CORRECT ANSWER - default value
Each record in a table is uniquely identified by a foreign key? - CORRECT ANSWER -
False
A software program that lets the user create databases and then manipulate the data in the
databases is called a database management system ? - CORRECT ANSWER - True
CORRECT Answers
A relationship between two tables in a database is formed using an backstage field? - CORRECT
ANSWER - False
Which Access feature provides information about Access commands, features, and instructions -
CORRECT ANSWER - Access Help
Which Ribbon group allows you to add fields to an Access table with defined data types -
CORRECT ANSWER - Add & Delete
Files created with Access 2013 may be used with which previous version of Access - CORRECT
ANSWER - Access 2010
The accompanying figure shows the first dialog box for the - CORRECT ANSWER -
Simple Query Wizard
The appearance of non-theme fonts, colors, and effects remains unchanged no matter which
theme is applied to the workbook - CORRECT ANSWER - True
What is the maximum character length of a field name? - CORRECT ANSWER - 64
Which data type would be the best logical data type for a field named PaidDate? - CORRECT
ANSWER - Date/Time
Formatting Date/Time fields changes only the way data is displayed, not the field __________ -
CORRECT ANSWER - values
In the accompanying figure the field size is set to - CORRECT ANSWER -5
, A database or a relational database is a collection of related tables - CORRECT
ANSWER - True
Which Access 2013 view shows the contents of a table as a datasheet? - CORRECT
ANSWER - Datasheet View
The appearance of non theme fonts colors and effects remains unchanged no matter which theme
- CORRECT ANSWER - True
The format painter does not copy formatting applied to selected text within a cell and it does not
copy data - CORRECT ANSWER - True
In the accompanying figure the top portion of the table window indicated by the red bracket is
the - CORRECT ANSWER - Table Design Grid
The accompanying figure illustrates the design view which allows the user to modify a table
structure - CORRECT ANSWER - Design View
Which of the following would be a likely reason that an import process from excel to access
might fail? - CORRECT ANSWER - The access field names and the excel worksheet
column headings do not match
A value set in the Field Properties pane that appears in a field automatically is the default value
for the field - CORRECT ANSWER - default value
Each record in a table is uniquely identified by a foreign key? - CORRECT ANSWER -
False
A software program that lets the user create databases and then manipulate the data in the
databases is called a database management system ? - CORRECT ANSWER - True
