Access Final

Logical operators must be used in order to combine two or more conditions in a query. ____________________

true

The process of rearranging records in a specified order or sequence is referred to as sorting. ____________________

true

Formatting Date/Time fields changes only the way data is displayed, not the field ____.

values

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

yes/no

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

yes/no

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

.accdb

The default Field Size for the Short Text data type is ____________________ characters.

255

The default character length for the Short Text data type is ____ characters.

255

How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?

64

Which data type allows the designer to define the Field Size property?

AutoNumber

Which data type would be the best logical data type for a field named PaidDate?

Date/Time

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

Decimal Places

The ____ property allows the database designer to explain the purpose of a field or how a field is used.

Description

A formatted printout (or screen display) of the contents of one or more tables or queries is a form

False

A primary key that consists of two or more fields is called a(n) redundant key

False

A question asked about the data stored in a database is called a primary key. __________

False

A single characteristic or attribute of a person, place, object, event, or idea is a table

False

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

False

Access automatically assigns the Number data type to all new fields.

False

Access does not allow data to be imported from sources other than another Access database.

False

Access report printing options may be changed using the Navigation dialog box

False

All fields in a database should be contained in one table.

False

Field names in a table may only be changed in Design view.

False

In the Database Design grid, press the Enter key to move from one property to the next property

False

It is not possible to create a query from more than one table. ____________________

False

Relationship integrity is a set of rules used by Access to maintain consistency between related tables when data in either table is updated.

False

Results of a query are narrowed by using the Or logical operator. ____________________

False

The contents of query datasheet are permanent. ____________________

False

The default query type for Access is the Crosstab query. ____________________

False

The only option available for creating tables in Access is to use the data sheet view

False

The query results are stored in the database in which the query has been created.

False

It is more efficient to use the Query Wizard for common, informational queries than to design your own query. ____________________

Fasle

____ is the default name for a new table in an Access database.

Table 1

A Software program that lets the user create and then manipulate the data in the databases is called a database management system (DBSM)

True

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut.

True

Access does not require a field description for every field included in a table.

True

Access does not require a table to have a(n) primary key. _____________

True

Changes made to a field in a query datasheet updates the same field in the table on which the query is based. ___________________

True

Compacting a database rearranges the data and objects in a database to decrease its file size.

True

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.

True

Database or a relational database is a collection of related tables

True

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.

True

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

True

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

True

Fields included in a query may be modified after the query is saved. ____________________

True

In order to define table relationships, each table being joined must contain a common field

True

It is possible to view all Access objects in the Navigation Pane

True

The Currency data type is accurate up to 4 digits on the right side of the decimal point.

True

The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view.

True

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane.

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

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet. ________________

True

To toggle between navigation mode and editing mode press the F2 keyboard shortcut. ____________________

True

When a question is asked of a database using a select query, the answer is returned as a data sheet. ____________________

True

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data.

True

When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message

True

Each row in an Access table datasheet displays which of the following?

a record

An important reference tool available in Access 2016, which may be used to assist a user with problems that might occur, is the ____________________ system.

access help

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

access help

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

best fit

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

clipboard

Clicking on the Close option from the Backstage view in Access 2016 performs which of the following tasks?

closes the current database

A field used to connect one table logically with another table is called a ____ field.

common

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

common field

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

common field

The ____________________ option is available to compact and repair a database file automatically every time the database is closed.

compact on close

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

compacting

The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.

currency

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.

delimited

____________________ view allows the database designer to enter both the field names and define the field properties.

design

____________________ values are never allowed by Access in the primary key field.

duplicate

To begin importing data from an Excel spreadsheet, click on the ____ tab on the ribbon.

external data

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

false

Each column in an Access table datasheet represents a

field

In a single table, all ____________________ must be unique within that table.

field names

A database system determines how to store, display, and process field values based on which of the following?

field properties

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) _________

foreign key

Data can be presented in customized and useful ways different from tables and queries by using a Simple ___________

form

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

infinity symbol

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

join

The common field between two tables in the Relationship window is indicated by a(n) ____.

join line

Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table

last record

Which view is used to make design changes to a form while the form is displaying data?

layout view

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

m/dd/yy

A database management system is a useful tool only if it meets which of the following criteria?

meets the needs of its users

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ________

navigation buttons

Which data type allows both positive and negative numbers as field values?

number

The "one" table in a one-to-many relationship is the ____________________ table.

primary

The default ____________________ provided by Access is the ID field.

primary key

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

print preview

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

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

referential integrity

Data organized as a collection of tables creates this type of data system.

relational database management system

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

repairing the database

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

short text

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

single

Changing the order of fields in a database table is an example of changing a table's ____.

structure

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

Access reports are based on a selected ____________________ or ____________________

table, query