BCIS Exam #3
A Short Text field can hold up to _______ characters.
255
A Long Text field can hold up to _______ characters.
65,535
A(n) _______ field is automatically assigned its value by Access. D
AutoNumber
Click the _______ filter option to remove the filter from the field.
Clear
To remove a filter from a database object, click the _______ option.
Clear Filter
A(n) _______ field stores a true/false value as a ¿1 or 0.
Yes/No
A control that displays data from a table or query is called a(n) _______ control.
bound
Click and drag the _______ to make a control wider or narrower.
cursor
Access will prevent you from _______ records if it would violate the integrity of the database.
deleting
By applying a(n) ________ to a database object, you display a subset of records that meet your criteria.
filter
Sorting query results in ascending order sorts them _______.
from A to Z
Adding _______ organizes a report into sections by the value of a specific field.
grouping
A(n) _______ control displays the field name on the left.
label
In a new form there is(are) _______ record(s).
no
Although you create and worAccess database file, inside the file, there are multiple _______.
objects
Each row in a table contains all the data for a single _______.
record
A(n) _______ database is a group of tables related to one another by common fields.
relational
A new blank report does not have a record _______ defined until controls are added.
source
Access _______ are the essential building blocks of the database.
tables
A(n) _______ is a file with predefined settings that you can use as a base to create a new database of your own.
template
A(n) _______ is a unified color and font scheme.
theme
Adding a field to a blank form places _______ control(s) in a stacked layout.
two
A(n) _______ field can include images, Word documents, or almost any other type of data file.
Attachment
Access opens to _______ where you can select an existing database to open or begin a new one.
Backstage view
The Form button is located in the _______ tab of the Ribbon.
Create
You can view the results of a query by switching to _______ view.
Datasheet
Entering a value in the _______ can save time during data entry.
Default Value property
In the Simple Query Wizard, the _______ option shows every field you selected for every record.
Detail
If you need to find multiple records that match your search parameters, not just the first one, use the _______ command.
Find
A _______ Query will find all the records that have duplicate values in one or more fields.
Find Duplicates
Forms open in _______, which provides a user-friendly interface for entering data.
Form view
A(n) _______ field stores a Web address or email address.
Hyperlink
Forms and Reports also offer _______ where you can modify some (but not all) structural elements.
Layout view
In the _______ you can specify which pages to print and how many copies to print.
Print dialog
In Access, normally _______ are the only database objects that are printed.
Reports
Clicking the _______ button on the Quick Access Toolbar will prompt you to name and save a newly-created table.
Save
The _______ button on the Home tab will quickly apply or clear filters.
Toggle Filter
Duplicates of the primary key field are not allowed.
True
If you want to include all the fields from a table in your query, click and drag the _______ from the top of the table to the field row.
asterick (*)
In a query, a _______ displays a value returned by an expression (a formula).
calculated field
The Expression Builder is used to create calculated _______ in forms and reports.
controls
Fields can be inserted at the end of the field list in Design View by typing a new field name, and selecting a ________ type.
data
Microsoft Access is a powerful _______ program that allows you to enter, store, and organize large amounts of data.
database
Each column in a table represents a specific data value called a(n) _______.
field
In Datasheet view, attachment fields are designated by a(n) _______ icon.
paperclip
A(n) _______ displays data from a table or query in a format suitable for printing.
report
One method you can use to insert a new field is to _______ any field name and select _______.
right-click; Insert Field
Lookup fields are useful to use for fields that reference a _______.
specific list of items
Filtering with AutoFilter is _______
temporary
The Design view window is divided into _______ panes.
two