Comp&Apps Bus

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

In Datasheet view, clicking the (+) displays the related records in this format

Subdatasheet

A wildcard character that serves as a placeholder for one or more unknown character is the

*

A relationship between between two tables where one record in the first table corresponds to many in the second table

One-to-many relationship

An associate that you establish between two tables based on common fields.

Relationship

A sorting order that arranges text in reverse alphabetical order (Z to A) and numbers from the highest number to the lowest number.

descending

In the query design window, in the table area, the list of field names in a table

field list

Characteristics of a field that control how the field displays and how data is entered are:

field properties

The primary key field is connected to this field in the related table to create a relationship

foreign key

In datasheet view, when sorting using multiple fields, the field that is used for the last level of sorting

innermost

The visual cue in the relationships window that indicates tables are related by connecting common fields

join line

In datasheet view, when sorting using multiple fields, the field that is used for the first level of sorting

outermost

A query that prompts you for criteria when it is run is a:

parameter query

The field that uniquely identifies a record in a table is known as the:

primary key

A set of rules that ensures that the data between related tables is valid

referential integrity

The process of arranging data in a specific order based on the data in a field

sorting

The process in which Access looks for records in a table based on the fields and criteria in the query design, finds those records, and then displays the records in a datasheet

to run

They symbols =, >, and < are known as:

comparison operators

Conditions in a query that identify the specific data for which you are looking are known as:

criteria

A single piece of information that is stored in every record and represented by a column in a table.

data

The characteristic that defines the kind of data you can store in a field is the:

data type

An organized collection of facts about people, events, things, or ideas related to a specific topic.

database

A query that uses an aggregate function and displays data grouped by two types of information is:

An aggregate query

The Access view that displays data in columns and rows like an Excel worksheet is:

Datasheet view

Min, Max, Avg, and Sum are examples of:

aggregate functions

A field that stores the value of a mathematical operation is:

an expression

The logical operator that requires all criteria to be met to return a result is:

and

A sorting order that arranges text alphabetically (A to Z) and numbers from the lowest number to the highest number.

ascending

A comparison operator that searches for values within a range is:

between... and...

Relationship options that enable you to update records in related tables when referential integrity is enforced are known as:

cascade options

For a calculated field, the new field name must be followed by:

colon


Kaugnay na mga set ng pag-aaral

Security Strategies in Linux Platforms and Applications - Practice Test 03

View Set

patho quiz 7 check for understanding

View Set

aghsfr1 leçon 17 porter/ne pas porter

View Set

WEB WOC Ostomy Care: Quiz Questions

View Set