Access Chapters 1,2, and Concepts Chapter 11 Test

when saving a new database in Access 2007-2016 databases, the file extension should be_______

.accdb

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

when creating a new table, Access created the first field and names it______ which Access assigns a unique sequential number

ID

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

OR

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 link

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

______is a collection of related data that can be stored, sorted, organized, and queried

database

a_______ is an organized collection of data

database

a data dictionary is also referred to as a(n)______

database schema

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

when no comparison operator is displayed, Access will use the default__________ comparison operator for numeric data types

equal

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

in a database, another term for a table is a(n)______

file

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

foreign key

when considering to use the currency data type, a user should understand that they can store data with one to______ decimal places

four (4)

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 stored data in more than two dimensions, as opposed to relational databases, which store data in two-dimensional tables

multidimensional

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

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

object-oriented

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 indicated that a record that appears only 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

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

when appending or creating a new table from a 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

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?