Quiz 5

Which of the following is the file extension used for Access 2016 database files?

.accdb

Which Access feature provides information about Access commands and features and instructions about how to use them?

Access Help

Which Ribbon group allows you to add fields to an Access table with defined data types?

Add & Delete

Which Access 2016 view shows the contents the records in a table on the screen at the same time?

Datasheet view

A one-to-1 relationship means that each parent record many have more than one child.

False

A query is used to enter, edit, and view records in a database.

False

A single piece of data describing a person, place, object, event, or idea is a record.

False

Each record in a table is uniquely identified by a foreign key

False

Which data type allows field values to contain letters, digits, and other characters?

Short Text

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

Tab, Enter

A collection of related records is called a(n) ____________.

Table

Field values that may be entered into a field are determined by the data type of the field.

True

The default primary key for an Access database is the ID field.

True

The default sort order for records in an Access table is based on the values in the primary key field.

True

A ____________ allows data to be displayed or entered one record at a time.

form

The default __________ __________ provided by Access is the ID field.

primary key

A _____________ allows users to ask questions and select pertinent data from a database.

query

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

query

A collection of related fields is called a(n) _______________.

record

RDBMS stands for __________________.

relational database management system

What function does compacting an Access database perform other than reducing the file size?

repairing the database

A ___________ _____________ contains all of the detail for major asset and liability accounts in a balance sheet.

subsidiary ledger

All of the data in a relational database are contained in ____________________.

tables

The three basic components of the Access ribbon are______,______, and______. .

tabs, groups, commands

What is the purpose of the primary key?

to uniquely identify each record in a table

The _________ key opens the Access Help function

F1

A relational database is a collection of related tables (or files).

True