Filters
Question type

Study Flashcards

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

Correct Answer

verifed

verified

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Access reports are based on a selected ____________________ or ____________________.

Correct Answer

verifed

verified

A table is a predesigned database that includes professionally designed database objects.  _________________________

Correct Answer

verifed

verified

Each column in an Access table datasheet represents a ____.


A) query
B) record
C) field
D) primary key

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

When copying and pasting records from one table to another, the records must first be copied to the ____.


A) database
B) query
C) storage device
D) clipboard

Correct Answer

verifed

verified

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?


A) Tab, Insert
B) Enter, PgDn
C) Insert, PgUp
D) Tab, Enter

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition.

Premises
A status box that displays the number of the current record and the total number of records in a table.
Responses
primary key
Backstage view
Current Record Box
File tab
data type
Simple Query Wizard
query
Print Preview
field value
Create tab

Correct Answer

primary key
Backstage view
Current Record Box
File tab
data type
Simple Query Wizard
query
Print Preview
field value
Create tab

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 Answer

verifed

verified

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


A) Properties
B) Formatting
C) Field Validation
D) Add & Delete

Correct Answer

verifed

verified

When using a mouse while in an Access 2016 work session, access a shortcut menu for an object by performing this task.


A) scroll the vertical scroll bar
B) scroll the horizontal scroll bar
C) cllick on the Navigation Pane
D) right click

Correct Answer

verifed

verified

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


A) form
B) table
C) query
D) report

Correct Answer

verifed

verified

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n)____________________.

Correct Answer

verifed

verified

Records in separate tables may be connected through a(n)____________________ that appears in both tables.

Correct Answer

verifed

verified

A relationship between two tables in a database is formed using a  Backstage field.  _________________________

Correct Answer

verifed

verified

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


A) Query Wizard
B) Access Help
C) Form Wizard
D) Report Wizard

Correct Answer

verifed

verified

Which button is used to open and close the Navigation Pane?


A) Navigation Bar
B) Record
C) Shutter Bar Open/Close
D) Table View

Correct Answer

verifed

verified

Showing 21 - 40 of 75

Related Exams

Show Answer