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?