MOS Acess Chapter 2 Vocab
Terms in this set (40)
Used to change the data in existing tables or make new tables based on the query's results.
Functions that summarize grouped data. These functions include sum, count, average, minimum, and maximum.
An alternative name for a field.
Adds records from one or more table to the end of an existing table.
From A to Z or 1 to 9.
A field that contains the result of a computation performed on one or more other fields.
When a record in a parent table is deleted, Access deletes all the related records from the child table. Related records are those for which the value in the foreign key matches the value in the primary key.
When the primary key field is updated in a parent table, all corresponding foreign key values in the child table automatically update.
The related field from the child table of the relationship.
The second table of a relationship. This is generally the "many" side of the relationship. One record from the parent table (such as clients) can be related to one or more records of the child table (such as sales).
A model where data and programs are stored on the Internet; users do not own the infrastructure and pay only for the level of services used.
A symbol or word that represents a comparison to be performed between values.
Filtering specifications that determine what records will be included in a query.
Using software tools to evaluate digital data so you can use the information in meaningful ways.
Using data analysis to find patterns in data.
From Z to A or 9 to 1.
Filter by Form
To use a form that enables you to enter criteria for the filter.
Filter by Selection
To filter based on the data in the selected record and field.
To display only certain records.
To locate text within a record that matches characters you type.
A field in the child table that is related to the primary key in the parent table.
Make table query
This type of query pulls information from one or more tables, and then creates a new table with this information.
The related field from the main (parent) table of the relationship.
To use more than one field to sort records. If there are duplicates for the first field, the second field is used to organize the records for each set of duplicated values in the first field.
A lack of an entry in a field.
A relationship in which the value of the linked field in the parent table is different for each record, but the value of the linked field in the child table can be the same in multiple records.
A value in the foreign key that does not have a corresponding primary key in the parent table.
A query that asks for input every time that you run it.
The main table of a relationship. This is the "one" side of the relationship and contains the primary key.
A defined set of operations to be performed on a table (or on the results from another query).
Query design grid
The lower half of the Query Design view that shows the field name, table name, sort order, show box, and criteria rows for selecting records.
Query design view
A view that enables you to choose the fields in a query, to select the sort order, and to set criteria.
A property of a relationship between two tables. When this is on, each foreign key value in the child table must have a corresponding primary key value in the parent table.
To substitute new text after finding a string of text.
A child table related to the main (parent) table.
A query that sorts and filters the records in a table or other query to extract certain fields and records based on criteria you specify. This is by far the most common type of query.
To arrange records alphabetically or numerically according to a specific field.
A query used to change existing data.
A variety of technologies that enable more efficient use of hardware and other resources.
A character (? or *) that signifies one or more unspecified characters when finding text.