ACCESS TEST QUESTIONS &
ANSWERS PASSED ALREADY
GRADED A+
Hard copy - Correct Answer ✔✔ Information that exists on a physical medium
Data sheet - Correct Answer ✔✔ A table represented as a collection of rows and
columns
Row selector - Correct Answer ✔✔ Small box that precedes the field
Detail - Correct Answer ✔✔ In a query, this options shows all the records and fields.
Single - Correct Answer ✔✔ Numeric values with decimal places to seven significant
digits.
Database - Correct Answer ✔✔ Collection of organized data
_________ the column changes its size. - Correct Answer ✔✔ Resizing
List - Correct Answer ✔✔ Excel data in rows with headings in top row.
Criterion - Correct Answer ✔✔ Condition that the records to be included must satisfy.
Datasheet view - Correct Answer ✔✔ View where data in the table is presented in rows
and columns.
Portrait Orientation - Correct Answer ✔✔ Printout is across the width of the page
Data type - Correct Answer ✔✔ Indicates the type of data that can be stored in the field.
One-to-many relationship - Correct Answer ✔✔ The most common type of relationship
between tables.
Click to Add - Correct Answer ✔✔ To define an additional field, click this heading
System analysis - Correct Answer ✔✔ Determination of database requirements is part
of this process.
Relational database - Correct Answer ✔✔ Database of table with information on a
specific subject.
, Records - Correct Answer ✔✔ Rows in the table
Queries - Correct Answer ✔✔ Questions the database can answer
Byte - Correct Answer ✔✔ Integer value in the range of 0-225.
Autocorrect - Correct Answer ✔✔ Corrects common mistakes when entering text in a
cell.
Double - Correct Answer ✔✔ Numeric values with decimals places to move accuracy
than Single
Fields - Correct Answer ✔✔ Columns in the table
Status bar - Correct Answer ✔✔ Presents info about the database object
Reserved words - Correct Answer ✔✔ Words that have a special meaning to Access
Landscape Orientation - Correct Answer ✔✔ Printout is across the height of the page.
Tables are the __________ you use to store and manipulate data. - Correct Answer ✔✔
Objects
Primary key - Correct Answer ✔✔ Another term for unique identifier.
Database properties - Correct Answer ✔✔ Details about a file
Keywords - Correct Answer ✔✔ Words or phrases that further describe the database
Navigation Pane - Correct Answer ✔✔ Contain a list of all the objects in the database.
______________ for open objects appear at the top of the work area - Correct Answer
✔✔ Object Tabs.
Summary - Correct Answer ✔✔ In a query, this option only shows computations.
Decimal - Correct Answer ✔✔ Numeric values with decimal places beyond Single and
Double
Long Integer - Correct Answer ✔✔ Integer values in the range of -2,147,483,648 to
2,147,483,647.
DBDL - Correct Answer ✔✔ Shorthand representation of the structure of a relational
database.
ANSWERS PASSED ALREADY
GRADED A+
Hard copy - Correct Answer ✔✔ Information that exists on a physical medium
Data sheet - Correct Answer ✔✔ A table represented as a collection of rows and
columns
Row selector - Correct Answer ✔✔ Small box that precedes the field
Detail - Correct Answer ✔✔ In a query, this options shows all the records and fields.
Single - Correct Answer ✔✔ Numeric values with decimal places to seven significant
digits.
Database - Correct Answer ✔✔ Collection of organized data
_________ the column changes its size. - Correct Answer ✔✔ Resizing
List - Correct Answer ✔✔ Excel data in rows with headings in top row.
Criterion - Correct Answer ✔✔ Condition that the records to be included must satisfy.
Datasheet view - Correct Answer ✔✔ View where data in the table is presented in rows
and columns.
Portrait Orientation - Correct Answer ✔✔ Printout is across the width of the page
Data type - Correct Answer ✔✔ Indicates the type of data that can be stored in the field.
One-to-many relationship - Correct Answer ✔✔ The most common type of relationship
between tables.
Click to Add - Correct Answer ✔✔ To define an additional field, click this heading
System analysis - Correct Answer ✔✔ Determination of database requirements is part
of this process.
Relational database - Correct Answer ✔✔ Database of table with information on a
specific subject.
, Records - Correct Answer ✔✔ Rows in the table
Queries - Correct Answer ✔✔ Questions the database can answer
Byte - Correct Answer ✔✔ Integer value in the range of 0-225.
Autocorrect - Correct Answer ✔✔ Corrects common mistakes when entering text in a
cell.
Double - Correct Answer ✔✔ Numeric values with decimals places to move accuracy
than Single
Fields - Correct Answer ✔✔ Columns in the table
Status bar - Correct Answer ✔✔ Presents info about the database object
Reserved words - Correct Answer ✔✔ Words that have a special meaning to Access
Landscape Orientation - Correct Answer ✔✔ Printout is across the height of the page.
Tables are the __________ you use to store and manipulate data. - Correct Answer ✔✔
Objects
Primary key - Correct Answer ✔✔ Another term for unique identifier.
Database properties - Correct Answer ✔✔ Details about a file
Keywords - Correct Answer ✔✔ Words or phrases that further describe the database
Navigation Pane - Correct Answer ✔✔ Contain a list of all the objects in the database.
______________ for open objects appear at the top of the work area - Correct Answer
✔✔ Object Tabs.
Summary - Correct Answer ✔✔ In a query, this option only shows computations.
Decimal - Correct Answer ✔✔ Numeric values with decimal places beyond Single and
Double
Long Integer - Correct Answer ✔✔ Integer values in the range of -2,147,483,648 to
2,147,483,647.
DBDL - Correct Answer ✔✔ Shorthand representation of the structure of a relational
database.
