ACCESS EXAM WITH CORRECT
QUESTIONS AND ANSWERS 2025
A database or a relational database is a collection of related tables - CORRECT-ANSWERSTrue
Each record in a table is uniquely identified by a foreign key. - CORRECT-ANSWERSFalse
A software program that lets the user create databases and then manipulate the data in the
databases is called a database management system (DBMS) - CORRECT-ANSWERSTrue
The only option available for creating tables in Access is to use the datasheet view - CORRECT-
ANSWERSFalse
A query is used to enter, edit, and view records in a database - CORRECT-ANSWERSFalse
Compacting a database rearranges the data and objects in a database to decrease its file size -
CORRECT-ANSWERSTrue
,A single characteristic or attribute of a person, place, object, event, or idea is a table -
CORRECT-ANSWERSFalse
Each Access database may be as large as two gigabytes in size and may have up to 255 people
using the database at the same time. - CORRECT-ANSWERSTrue
The default primary key for an Access database is the ID field - CORRECT-ANSWERSTrue
Field values that may be entered into a field are determined by the data type of the field. -
CORRECT-ANSWERSTrue
The query results are stored in the database in which the query has been created. - CORRECT-
ANSWERSFalse
The default sort order for records in an Access table is based on the values in the primary key
field. - CORRECT-ANSWERSTrue
, Access report printing options may be changed using the Navigation dialog box - CORRECT-
ANSWERSFalse
Each row in an Access table datasheet displays which of the following? - CORRECT-ANSWERSA
record
Each column in an Access table datasheet represents a - CORRECT-ANSWERSField
Which term identifies a field that appears in two separate tables and may be used to connect
records in the separate tables? - CORRECT-ANSWERScommon field
Data organized as a collection of tables creates this type of data system. - CORRECT-
ANSWERSrelational database management system
How many characters may a field name in Access contain including numbers, letters, spaces,
and special characters? - CORRECT-ANSWERS64
QUESTIONS AND ANSWERS 2025
A database or a relational database is a collection of related tables - CORRECT-ANSWERSTrue
Each record in a table is uniquely identified by a foreign key. - CORRECT-ANSWERSFalse
A software program that lets the user create databases and then manipulate the data in the
databases is called a database management system (DBMS) - CORRECT-ANSWERSTrue
The only option available for creating tables in Access is to use the datasheet view - CORRECT-
ANSWERSFalse
A query is used to enter, edit, and view records in a database - CORRECT-ANSWERSFalse
Compacting a database rearranges the data and objects in a database to decrease its file size -
CORRECT-ANSWERSTrue
,A single characteristic or attribute of a person, place, object, event, or idea is a table -
CORRECT-ANSWERSFalse
Each Access database may be as large as two gigabytes in size and may have up to 255 people
using the database at the same time. - CORRECT-ANSWERSTrue
The default primary key for an Access database is the ID field - CORRECT-ANSWERSTrue
Field values that may be entered into a field are determined by the data type of the field. -
CORRECT-ANSWERSTrue
The query results are stored in the database in which the query has been created. - CORRECT-
ANSWERSFalse
The default sort order for records in an Access table is based on the values in the primary key
field. - CORRECT-ANSWERSTrue
, Access report printing options may be changed using the Navigation dialog box - CORRECT-
ANSWERSFalse
Each row in an Access table datasheet displays which of the following? - CORRECT-ANSWERSA
record
Each column in an Access table datasheet represents a - CORRECT-ANSWERSField
Which term identifies a field that appears in two separate tables and may be used to connect
records in the separate tables? - CORRECT-ANSWERScommon field
Data organized as a collection of tables creates this type of data system. - CORRECT-
ANSWERSrelational database management system
How many characters may a field name in Access contain including numbers, letters, spaces,
and special characters? - CORRECT-ANSWERS64
