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