How can we help?

You can also find more resources in our Help Center.

57 terms

Access

Blah Blah Blahhh
STUDY
PLAY
Exact Match
The condition that requires a value in a specified field to be identical to the specified condition is called a(n)
Show
You can tell if a field will appear in the query datasheet if there is a check mark in the field's ________check box in the design grid.
Drag
To include a field in a query, you can click and _______the field from the field list to the design grid.
Navigation
In a form with a main form and a subform, there will be two sets of _________________ buttons for use in selecting records from each of the tables.
Report Wizard
The Access feature that can guide you through the creation of a report by asking questions is called the _____________.
Related
When creating a form based on two tables, you create a subform for data from the _____ table.
Common Field
When you create a form containing data from two tables that have a one-to-many relationship, Access uses the defined relationship between the two tables to automatically join the tables through the _______________that exists in both tables.
Home
To open the Find and Replace dialog box, click the Find button on the ________tab.
External Data and Import
You can import a table from another Access database into your current database using the ____________ tab of the ________ group on the Ribbon.
Navigation Pane
A defined query for an open database can be selected by double-clicking in the _______________ of the Database window.
Primary
When creating a form based on two tables, you create a form for data from the ________ table.
Main
Forms for tables that have a one-to-many relationship will have a(n) _________form and a subform
Relationship
To create a form based on two tables, you must first define a(n) ___________ between the two tables.
Query1
The default query name is __________.
Icon
Each object in the Navigation Pane has a unique_____to indicate the type of object.
Number
If you have a Customer ID field with values like 1234, you should use the _________data type.
Primary Key
In a given table, a field is defined as a(n) ____________ when its values uniquely identify each record in the table.
External Data
You use the ____________________ tab if you want to import data from an Excel worksheet.
Count
The aggregate function, _______, returns the number of the non null field values in a selection of records.
Wildcard
A pattern match uses _________ characters.
Related Table
If a form shows two forms of two different tables, the bottom form is for the _________.
#
If you only know the first or last part of a numeric value, use the ___ character when searching.
?
The _____ character will match any single alphabetic character
Object
A form is a(n) _______ that you can use to maintain, view, and print records in a database.
Johns*
To find the names of Johnson, Johnston, and Johnstone in form records, use _____.
Datasheet
To delete a record, select the record in ________ view
Join
You can use a common field to create relationships between tables by performing a(n) ____.
Design Grid
The fields and selection criteria for a query are included in the __________.
Between..And
A range of values may be specified as selection criteria by using the __________ operator.
Comparison
Operators used in selection criteria in a query, such as equal, not equal, or greater than, are known as ___________ operators.
Descending
When you sort a field with a Yes/No data type in _________ sort order, the no values display first, followed by the yes values.
Integrity
Reference _______ is a feature built in to Access to prevent data inconsistency in related tables.
One-to-many
The ____________ relationship exists between two tables when one record in the first table matches zero, one, or many records in the second table.
And
The ____ operator will cause a record to be selected only if two or more conditions are satisfied.
Logo
To add a picture to a form, click the ____ button.
Layout
To just modify a form's style, you would first change to _____ view
None of the above
An example of a relational Database is
________________.
Run
To see the results of a query, you must ____ it.
Temporary
When a query is run, the datasheet contents are ________.
Wizard
Access can guide you through the steps to create a query by using the Query ____.
255
The maximum size of a Text data type is ___ characters.
Must contain a unique value for each record within a table
A primary key ____.
None of the above
A relational database management system is a collection of ____________
Aggregate Function
Statistical information, such as totals and averages, can be calculated in a query by using a(n) ________________.
Infinity
The join line for a one-to-many relationship will show the ________ symbol on the "many" end of the line.
False
You cannot update data while viewing a query datasheet
False
In a one-to-many relationship, the primary table is the "many" table.
False
Multiple selection conditions can be specified in a query by using relational operators.
False
The F5 key is a toggle that you use to switch between the Table Design grid and the Field Properties pane
False
Access allows you to change a field size in Datasheet view.
False
You can import a table from another Access database into your current database using the Import button on the Ribbon.
True
Aggregate functions perform arithmetic and statistical operations on selected records.
True
The Navigation Pane divides database objects into categories, and each category contains groups
True
A single set of field values within a table is a record.
True
A database is a collection of related tables.
False
Access allows you to modify a table structure in Datasheet view
True
Access can determine what data type to assign to each field based on the values you enter for the field. If the values entered do not provide enough information for Access to guess& the data type, the default type assigned is the Text data type.