ACCESS TEST FINAL
Which of the following may be used as a wildcard character when searching for a value in Access?
#
A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.
*
Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?
-
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 keyboard shortcut selects the first field value in the first record when in Navigation Mode?
Ctrl+Home
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
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
Statistical information such as totals and averages is calculated using ____.
aggregate functions
To resize an image without changing its proportions, simply drag ____ of the image.
any corner
The + symbol is an example of a(n) ____ operator.
arithmetic
Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.
arrow
Which data type allows the designer to define the Field Size property?
autonumber
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
Queries based on more than one table, must have 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
A criterion, or rule, that determines which records are selected when a query is run is called a(n) ____.
condition
A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n) ____________________.
control layout
Which aggregate function supports the Yes/No field data type?
count
The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.
currency
____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.
custom
Which view must be used to delete an entire record?
datasheet
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
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
The ____ property allows the database designer to explain the purpose of a field or how a field is used.
description
____________________ view allows the database designer to enter both the field names and define the field properties.
design
A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.
detail record
The less precise way to move objects in report Layout view is to ____.
drag objects
____________________ 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 form layout is a set of controls grouped together in a form or report that can be manipulated as a single control. _________________
false
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 query is used to enter, edit, and view records in a database. ______________
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 sort field is unique if more than one record can have the same value for the sort field. ____________
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
Arithmetic operations are performed on selected records in a database using Statistical functions. ____________
false
Each record in a table is uniquely identified by a foreign key. ___________________
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 more efficient to use the Query Wizard for common, informational queries than to design your own query. ___________
false
It is not possible to create a query from more than one table. __________
false
Query elements may be added to a form to improve its appearance or add visual appeal.___________
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 Form Wizard limits fields to be used in a form to one table or one query. ___________________
false
The Tabular and Justified form report layouts display the fields from multiple records at one time. ___________
false
The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon. _______________
false
The contents of query datasheet are permanent. _______
false
The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field. ________________
false
The default query type for Access is the Crosstab query. _______________
false
The most detailed view of a form's structure is available the Layout view. ____________
false
The only option available for creating tables in Access is to use the datasheet view. _______________
false
The query results are stored in the database in which the query has been created.______________
false
When a form is created based on two or more tables, a relationship must be defined between queries. ____________
false
When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option. __________
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
The way field values are stored, displayed, and processed in an Access database is determined by the ____________________
field properties
Before applying a conditional format in a report, the ____ box must be selected.
field value
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
A form must be displayed in ____________________ view to navigate, view, and edit data.
form
Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.
form
Data in a form may only be modified in ____ view.
form
Alignment of text in a field value may be changed using the ____________________ tab in the REPORT LAYOUT TOOLS contextual tabs when designing a report
format
____ is the default entry for each field in the Total row of the query design grid.
group by
The ____ command removes the display of one or more fields in Datasheet view.
hide fields
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
A report formatted in _____________________ is wider than it is tall.
landscape orientation
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
In a query, Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.
leftmost
In the criterion, <=250, the operator will return values for the specified field that are ____.
less than or equal to 250
Which comparison operator matches a pattern that includes wildcards?
like
Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?
m/dd/yy
Data in a form created from the primary table is contained in the ____.
main form
The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.
maintaining
A database management system is a useful tool only if it meets which of the following criteria?
meets the needs of its users
query based on more than one table is a(n) ____query.
multitable
The first, last, next, or previous page in a report may be displayed using the ____________________ buttons.
navigation
Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.
navigation
There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________
navigation buttons
After a conditional formatting rule is created using the ____ dialog box, the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.
new formatting rule
The comparison operator, < >, is used to insert a condition that means ____
not equal to
Which data type allows both positive and negative numbers as field values?
number
Date criteria are automatically enclosed in ____ when entered in a query design.
number signs
When using the Report Wizard, the report title entered in the Wizard is also the name of the report ____________________.
object
The default theme for a new form that is created is the ____________________ theme.
office
The ascending sort order for the Date/Time data type sorts dates from ____________________.
oldest to most recent date
A form created from two tables that have a ____ relationship creates a main form and a subform.
one-to-many
A report formatted where the page is taller than it is wide is formatted in ____.
portrait orientation
The "one" table in a one-to-many relationship is the ____________________ table.
primary
The primary key of a table must be unique for each record; however, the ____ sort field does not have to be unique.
primary
The default ____________________ provided by Access is the ID field.
primary key
The first field specified in the sorting process is called the ____________________ field.
primary sort
A report layout may be changed using options on the ____________________ tab.
print preview
Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.
print preview
A calculated field is formatted using the ____ for the field.
property sheet
To generate a report with exact results based on specific criteria it is best to base the report on a(n) ____________________ created in the database.
query
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
Data may be sorted in a table datasheet, a form, and a ____.
query datasheet
The default name for a new Access query is ____________________.
query1
A ____________________ is a set of records that answers the question resulting from a query.
recordset
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
To use an existing query as the basis for a new query, it is necessary to ____ the query before designing the new query.
rename
What function does compacting an Access database perform other than reducing the file size?
repairing the database
Data in Date/Time fields are automatically ____-aligned.
right
One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."
rule type
Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.
run
Records printed in Form view are distinguished from one another in Print Preview by ____________________.
shading
To select both a field label and field value to move in a report design, after selecting the field label press the ____ key to select the field value box.
shift
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
____ is the default name for a new table in an Access database.
table 1
Access reports are based on a selected ____________________ or ____________________.
table, query
A database or a relational database is a collection of related tables. _______________________
true
A form created from more than one table uses the primary table for the main form. ___________________
true
A form's object name appears on the tab for the form in the Access window. ____________________
true
A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut. ________________
true
A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS). __________________
true
Access allows all pages, a range of pages, or a currently selected record to be printed from Form view. ______________
true
Access database objects are divided into categories on the Navigation Pane. ________________
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
Access may base queries on one or more tables or queries. ________
true
Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table. __________________
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
Design changes cannot be made to a form in Form view. ____
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
Field values edited in Form view are also changed in the form's underlying table. ________________
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
Layout view shows both the form and its data while allowing the form to be modified. ________________
true
Logical operators must be used in order to combine two or more conditions in a query. _____________
true
Report fields and field value boxes may be repositioned while viewing the report in Layout view. _________________
true
The Columnar form layout displays the fields from one record at a time. _______________
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 Report Wizard allows detail records to be sorted by up to four fields. ________________The Report Wizard allows detail records to be sorted by up to four fields. ________________
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
The process of rearranging records in a specified order or sequence is referred to as sorting. ______________
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
The ___________________ command allows hidden fields to be redisplayed.
unhide fields
When the sort field data for each record in a database is different, the sort field is ____.
unique
Formatting Date/Time fields changes only the way data is displayed, not the field ____.
values
A calculated field created in a query generates results when ____.
when the query is run
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
