Upgrade to remove ads
Only $2.99/month

JWCC: CSC 116 - Database Core Level (Access 2013 Level 1) Unit 1 Chapters 1-4 Concept Checks

Terms in this set (53)

Blank desktop database template
Click this template at the Access 2013 opening screen to create a new database.
Quick Access Toolbar
This toolbar contains buttons for commonly used commands.
Navigation Pane
This displays the names of objects within a database grouped by categories.
Datasheet view
When you open a table, it displays in this view.
Record Navigation bar
Use buttons on this bar to navigate in a table.
Records
To add a new record, click the New button in this group on the HOME tab.
Quick Print
At the Print backstage area, click this button to send the table directly to the printer.
Page Layout
The Landscape button is located in this group on the PRINT PREVIEW tab.
Record
All fields for one unit, such as an employee or customer, are considered to be this.
Currency
Assign this data type to values that involve money.
Data type
Click this button in the Properties group on the TABLE TOOLS FIELDS tab to display the Enter Field Properties dialog box.
Quick Start
With options in this category in the More Fields button drop-down list, you can define a data type and also assign a field name.
Name & Caption button
If you want to assign the same field value to a column, click this button to display the Expression Builder dialog box and then type the desired value.
Join
In Access, one table can be related to another, which is generally referred to as performing this.
Primary Key
A database table can contain a foreign key field and this type of key field.
Design
Open a table, click the View button on the HOME tab, and the table displays in this view.
Primary
In a one-to-many relationship, the table containing the "one" is referred to as this.
Related
In a one-to-many relationship, the table containing the "many" is referred to as this.
Referential Integrity
In a one-to-many relationship, Access follows a set of rules that enforces consistency between related tables and is referred to as this.
Infinity
In related tables, this symbol displays near the black line next to the field list box of the related table.
Join Line
The black line that connects the field list boxes of related tables is referred to as this.
One-to-One
Establish this type of relationship between tables in which each record in the first table matches only one record in the second table and only one record in the second table matches each record in the first table.
Expand Indicator
The plus symbol that displays at the beginning of a record in a related table with a Subdatasheet displayed is referred to as this.
Collapse Indicator
The minus symbol that displays at the beginning of a record in a related table with a Subdatasheet displayed is referred to as this.
Expand All
Display subdatasheets for all records by clicking the More button, pointing to Subdatasheet, and then clicking this option.
Create
The Query Design button is located in the Queries group on this tab.
Show Table
Click the Query Design button and the query window displays with this dialog box open.
Criteria
To establish a criterion for a query, click in this row in the column containing the desired field name and then type the criterion.
Return
This is the term used for the results of the query.
#
This is the symbol Access automatically inserts before and after a date when writing a criterion for the query.
*
Use this symbol to indicate a wildcard character when writing a query criterion.
>500
This is the criterion you would type to return filed values greater than $500.
"L*"
This is the criterion you would type to return field values that begin with the letter L.
Not "Oregon"
This is the criterion you would type to return field values that are not in Oregon.
Descending
You can sort a field in a query in ascending order or in this order.
And
Multiple criteria entered in the Criteria row in the query design grid become this type of statement.
Simple Query Wizard
This wizard guides you through the steps for preparing a query.
Crosstab Query
This type of query calculates aggregate functions, in which field values are grouped by two fields.
Find Unmatched Query
Use this type of query to compare two tables and produce a list of the records in one table that have no matching records in the other table.
Field Properties Section
The lower half of the work area in Design view that displays the properties for the active field is referred to as this.
Autonumber
When you create a new table in Design view, Access automatically assigns the first field the name ID and assigns this data type.
Status Bar
The description you type in the Description field displays in this location when the field is active in the table in Datasheet view.
Input Mask
Use this field property to set a pattern for how data is entered in a field.
Validation rule
Use this property box in Design view to enter a statement containing a conditional test that is checked each time data is entered into a field.
Look-up wizard
Use this wizard to confine the data entered in a field to a specific list of items.
Insert rows
To insert a new field in a table in Design view, click this button.
Records
To insert a Total row in a table, click the Totals button in this group on the HOME tab.
Sort & Filter
The Ascending and Descending sort buttons are located in this group on the HOME tab.
Font size
Click this button to change the text size of data in a table.
Center
Click this button to align all text in the active column in the center of the fields.
Alternate Row Color
Click this button to specify a color for alternating rows in a table.
Replace
Use options at the Find and Replace dialog box with this tab selected to search for specific data and replace it with other data.
F1
This is the keyboard shortcut to display the Access Help window.
THIS SET IS OFTEN IN FOLDERS WITH...