1
65,535
A Long Text field can hold up to _______ characters.
255
A Short Text field can hold up to _______ characters.
Source
A new report does not have a record
relational
A(n) _______ database is a group of tables related to one another by common fields.
Attachment
A(n) _______ field can include images, Word documents, or almost any other type of data file.
AutoNumber
A(n) _______ field is automatically assigned its value by Access. Database users cannot edit or enter data in this field.
Hyperlink
A(n) _______ field stores a Web address or email address.
Yes/No
A(n) _______ field stores a true/false value as a ¿1 or 0.
tables
Access _______ are the essential building blocks of the database.
Backstage view
Access opens to _______ where you can select an existing database to open or begin a new one.
deleting
Access will prevent you from _______ records if it would violate the integrity of the database.
Two
Adding a field to blank form places
Objects
Although you create and woraccess database file
Toggle Filter
Button on the home tab will quickly apply or clear filters
Expressions
Can reference fields, mathematical operators
Clear
Click the filter option to remove the filter from the field
Save
Clicking the _______ button on the Quick Access Toolbar will prompt you to name and save a newly-created table.
Label
Control displays the field name on the left
Calculated field
Displays a value returned by an expression
true
Duplicates of the primary key field are not allowed.
field
Each column in a table represents a specific data value called a(n) _______.
record
Each row in a table contains all the data for a single _______.
Default Value property
Entering a value in the _______ can save time during data entry.
data
Fields can be inserted at the end of the field list in Design View by typing a new field name, and selecting a ________ type.
Temporary
Filtering with auto filter
Layout view
Forms and Reports also offer _______ where you can modify some (but not all) structural elements.
Form view
Forms open in _______, which provides a user-friendly interface for entering data.
Find
If you need to find multiple records that match your search parameters, not just the first one, use the _______ command.
Asterick
If you want to include all fields from a tab in your query
reports
In Access, normally _______ are the only database objects that are printed.
paperclip
In Datasheet view, attachment fields are designated by a(n) _______ icon.
No
In a new form record
Detail
In the simple query wizard the option shows every field you selected for every record
Template
Is a file with pre defined settings
Specific list of items
Look up fields are useful to use for fields that reference
Grouping
Organizes a report into sections by values of a specific field
From A to Z
Sorting query results in ascending order sorts them
errors
Storing each unique piece of data in a single table helps prevent data entry _______.
two
The Design view window is divided into _______ panes.
Controls
The expression is used to create calculated
Create
The form button is located in the ribbon
Cursor
To make a control wider or narrower
Clear filter
To remove a filter from a database object
Theme
Unified color and font scheme
Datasheet
You can review the results of a query by switching to
Print Dialogue
You can specify which pages to print
Filter
You display subset of records that meet your criteria
bound
a control that displays data a
report
displays data in a format suitable for printing
Right click/Insert Field
one method you can use to insert field is to
Find duplicates
query will find all the records that have duplicate values
