Access Chapters 1, 2 and Concepts Chapter 11 Test Review

When saving a new database in Access 2007-2016 databases, the file extension should be

.accdb

When no comparison operator is displayed, Access will use the default _______ comparison operator for numeric data types.

=

A user can create a(n) ________ condition by placing criteria for more than one field on the same Criteria row.

AND

When a user saves a new database with the default .accdb extension, any user can open the file EXCEPT user who has

Access 2002

Microsoft Access 2016 is a ________ that controls how related collections of data are stored, organized, retrieved and secured.

DBMS

Which of the following is NOT a way method to create a new database?

Database wizard

Results of a Select Query are displayed in the ________ View for the query.

Datasheet

Query criteria must be set in the ________ View of a query.

Design

To make changes to a query, the user must open the query in ________ View.

Design

A street address field is an example of a field that should have a default value?

False

A user will need to double-click on the field from field list one and then double-click on the field from field list two to establish a relationship between the two tables?

False

Data redundancy ensures that the data contained in the database is accurate and reliable?

False

In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink?

False

In the Datasheet view, a user will see the underlying structure of the table?

False

Normalization means that there are no data entry errors in a database?

False

Once users select a data type for a field and enter data, they cannot change the data type?

False

The Short Text data type will allow a user to store up to 512 characters in that field?

False

When a user is creating a relationship between two fields within two tables, both fields must have the same name?

False

Within an Access table, each row is a field and each column is called a record?

False

When creating a new table, Access creates the first field and names it _______ which Access assigns a unique sequential number.

ID

If a user double-clicks on a query name in the ________, Access will run the query and display the results.

Navigation Pane

____ is used to ensure that data is organized most efficiently in a database.

Normalization

The ________ condition is used to display records that meet one or more parts of the specified criteria.

OR

______ databases are better than relational databases at handling unstructured data such as audio clips, video clips, and pictures.

Object oriented

what are the four main points of access ?

Table, form, report, query, data

After users enter critical information and click Create, they will be directed immediately to Table 1 after creating a new database from Blank desktop database?

True

It is common that a database may have several tables where a user will need to establish relationships?

True

Users can print and save the relationship report to reference outside of the application?

True

When a user is creating a relationship between two fields within two tables, one of the fields is typically the primary key for that table?

True

A user can set the security and privacy settings on what is displayed in the Message Bar from the ________ within the options menu.

Trust Center

When designing a new database, the first question users should ask themselves is

What questions should this database be able to answer?

Database designers typically do not add spaces in field names (LName), but can add details in the ________ field of the field properties to provide additional context to the field that is not displayed (Last Name).

caption

A database that allows data to be maintained in a single location provides data _______.

centralization

Data ________ helps to ensure data integrity by maintaining information in only one place.

centralization

When linking two tables in a relational database, a user will use a ________ to create the link.

common field

When a user specifies more than one condition in a query, it is called a ________ criteria.

compound

The table(s) from which a query selects its data is referred to as the ________

data source

A _____ is a collection of related data that can be stored, sorted, organized, and queried.

database

A ________ is an organized collection of data.

database

In a database, another term for a table is a(n) ___

defile

When creating a table, a user should keep a record to a single instance of each set data that is broken down into its smallest usable parts called ____

fields

Databases that are not related or linked to other data are called ________ databases.

flat

Referential integrity means that for each value in the ________ field of a table, there is a corresponding value in the primary key of the related table.

former key

When considering to use the Currency data type, a user should understand that they can store data with one to ________ decimal places.

four

In a Microsoft Access database, an active web page, e-mail address, or existing file is stored as a(n) ________ field.

hyperlink

_____ is data that is accurate, organized and adds meaning.

information

Data ______ means that the data contained in a database is accurate and reliable.

integrity

If a query has multiple sorts, it will evaluate them from ________ within the Query Design Grid.

left to right

Data that describes other data is called _____

metadata

A(n) ________ database stores data in more than two dimensions, as opposed to relational databases, which store data in two-dimensional tables.

multidimensional

The process of applying good design rules such as organizing data so that the same information is not stored in multiple locations and forcing users to enter data in a consistent and accurate manner is called _____

normalization

When the Cascade options are enabled, a user can only update and delete records automatically by making changes to the ________ side of the one-to-many relationship.

one

In a relational database, a(n) ________ relationship indicates that a record that appears only one time in a table, may appear multiple times in a related table.

one to many

When working with a relational database, each record must have a(n) ________ key field, which has a value unique to that record.

primary key

If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ______.

redundancy

To connect two or more tables that have common fields, a user will need to establish and define the table

relationships

To quickly rename a table, a user can ________ on the table name from the Navigation Pane and select Rename.

right-click

A data dictionary is also referred to as a(n) _____

schema

When appending or creating a new table from an Import, the file that is being imported is called the ________ file

source

A group of related records is called a(n) _____

table

___ are similar in structure to an Excel worksheet and are the foundation for all Access databases.

tables