question

Add New Field Column

answer

A datasheet column in Access in which you create a new field for a table.

question

All Tables (view)

answer

The default view in the Navigation Pane in Access, which displays objects grouped according to the tables in the database.

question

AutoNumber

answer

An Access data type that automatically assigns a unique number to a record.

question

Backing up

answer

Making a copy of a database file to protect your database against loss or damage.

question

Column selector

answer

In a datasheet, the column heading (also called the field selector), which you click to select the entire column.

question

Common field

answer

A field that appears in more that one table, allowing you to connect the records in the separate tables.

question

Compacting

answer

A process that rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly.

question

Current Record box

answer

An Access text box that appears on the datasheet or form and indicates the current record and total number of records displayed.

question

Data type

answer

The field property that determines what field values you can enter for the field and what other properties the field will have.

question

Database

answer

A collection of related tables stored in the same file.

question

Database management system (DBMS)

answer

A software program that lets you create databases and then manipulate data in them.

question

Datasheet

answer

The display of a table's contents in rows and columns, similar to a table or spreadsheet; each row is a separate record in the table, and each column contains the field values for one field in the table.

question

Datasheet selector

answer

A box in the upper-left corner of a datasheet that lets you select the entire datasheet.

question

Datasheet view

answer

The Access view that shows a table's contents as a datasheet in rows and columns, similar to a table or spreadsheet.

question

Field

answer

A single characteristic or attribute of a person, place, object, event, or idea.

question

Field selector

answer

In a datasheet, the column heading (also known as the column selector), which you click to select the entire column.

question

Field value

answer

The specific value, or content, of a field in a record.

question

Foreign key

answer

A primary key field from one table that you include as a field in a second table to form a relationship between the two tables.

question

Form

answer

A database object you can create and customize to maintain, view, and print records in a database in different and useful ways.

question

Form tool

answer

An Access tool that creates a form containing all the fields in the table or other database object on which you are basing the form.

question

ID column

answer

The default field Access creates to serve as the primary key field for all new tables.

question

Microsoft Access Window

answer

The program window that appears when you start the Access program.

question

Microsoft Office Access 2007

answer

A database program you use to enter, organize, display, and retrieve related information.

question

Navigation buttons

answer

A set of buttons found at the bottom of a table datasheet or form that you use to move through the records in the table.

question

Navigation Pane

answer

In Access, the area on the left of the program window that lists all the objects in the database. In windows Vista, the left pane in a folder window.

question

Pencil symbol

answer

The symbol that appears in a row selector to indicate that the record is being edited.

question

Primary key

answer

A field, or a collect of fields, whose values uniquely and minimally identify each record in a database table and whose values do not change.

question

Print preview

answer

In Access, a view of a database report, form, or datasheet that shows you what the object will look like when printed.

question

Query

answer

A question you ask about the data stored in a database; in response, Access displays the specific records and fields that answer your question.

question

Record

answer

A complete set of field values for a specific person, place, object, event, or idea. Also known as a row.

question

Record selector

answer

In a datasheet, the small square at the beginning of a row (also known as the row selector), which you click to select the entire row.

question

Relational database

answer

A collection of related tables (relations) stored in the same file.

question

Relational database management system

answer

Also known as RDBMS, a system in which data is organized as a collection of tables, and relationships between the tables are formed through a common field.

question

Report

answer

A formatted printout (or screen display) of the contents of one or more tables in a database.

question

Report tool

answer

An Access tool that places all the fields from a table or query on a report.

question

Row selector

answer

In a datasheet, the small square at the beginning of a row (also called the record selector), which you click to select the entire row.

question

Simple Query Wizard

answer

An Access wizard that lets you quickly select the records and fields for a query.

question

Star symbol

answer

The symbol that appears in a row selector to indicate that the row is the next one available for a new record.

question

Table

answer

A collection of fields that describe a person, place, object, event or idea. Or, more technically, a two-dimensional structure made up of rows and columns of data in a relational database in which each row is unique, row order is unimportant, all entries are single-valued, column order is unimportant, each column has a unique field name, columns entries are from and same domain, and each row describes a dingle entity.

question

Template

answer

A predefined database that includes professionally designed tables, forms, reports, and other objects.

question

Text (data type)

answer

An Access data type that allows field values containing letters, digits, and other characters.

question

Best fit

answer

Sizing a column so the column is just wide enough to display the longest visible value in the column, including the field name.

question

Byte

answer

A Field Size property that stores whole numbers from 0 - 255 in one byte.

question

Cascade deletes option

answer

A referential integrity rule that permits a record in the primary table to be deleted and also deletes all records in the related tables that have matching foreign key values.

question

Cascade updates option

answer

A referential integrity rule that permits a change in value to the primary key and changes the appropriate foreign key values in related tables.

question

Composite key

answer

A primary key that consists of two or more fields. Also known as a concatenated key.

question

Ctrl + '

answer

The keyboard shortcut for inserting the value from the same field in the previous record into the current record

question

Data redundancy

answer

A condition that occurs when you store the same data in more than one place; it wastes storage space and can cause inconsistencies.

question

Decimal

answer

A Field Size property that stores positive and negative numbers precisely 28 decimal placed and uses 12 bytes.

question

Decimal places property

answer

The property that specifies the number of decimal places that will be displayed to the right of the decimal point.

question

Delimited

answer

A type of text file in which fields of data are separated by a character such as a comma or tab.

question

Description property

answer

The optional property you can use to enter a description for a field to explain its purpose or usage.

question

Design view

answer

The Access view you use to define or modify a table structure or the properties of the fields in a table.

question

Double

answer

A Field Size property that stores positive and negative number to precisely 15 decimal places and uses eight bytes.

question

Entity integrity

answer

The condition that exists when a primary key has been specified for a table, whereby Access forces you to enter a value for the primary key field in every record in the table.

question

F1 key

answer

The function key you press to display Help information, such as for the current property in Table Design view.

question

F6 key

answer

The function key you press to move between Table Design grid and the Field Properties pane of the Table window in Design view.

question

Field list

answer

A small window listing the fields contained in a table.

question

Field properties pane

answer

The part of the Table window in Design view that contains the properties for the selected field.

question

Field size property

answer

The property that defines a field's maximum storage size for text, number, and AutoNumber fields.

question

Importing

answer

Including the contents of a file in a new table or appending the contents of an existing table, or including the contents of the file in a form, report, or field.

question

Integer

answer

The Field Size that stores whole number from -32,768 to 32,767 in two bytes.

question

Join

answer

To relate tables through a common field

question

Join line

answer

In the Relationships window, the line that connects the common field that joins two tables.

question

Long integer

answer

The Field Size property that stores whole numbers from -2,147,483,648 to 2,147,483,647 in four bytes.

question

Null value

answer

The value that results from not entering a value for a field; a null value is not permitting for a primary key.

question

One-to-many relationship (1:M)

answer

A relationship between two tables in which each record in the primary table matches zero, one or many records in the related table, and in which each record in the related table matched at most one record in the primary table.

question

Orphaned record

answer

A record whose matching record in either the primary or related table has been deleted.

question

Primary table

answer

The "one" table in a one-to-many relationship.

question

Propagate

answer

To update field property changes made in Design view to the corresponding property on forms and reports that include the modified field.

question

Properties

answer

The characteristics of each field in a table.

question

Referential integrity

answer

The rule that requires each non-null foreign key value to match a primary key value in the primary table.

question

Related table

answer

The "many" table in the one-to-many relationships.

question

Relationships window

answer

The Access window in which you define the view and the relationships among a database's tables.

question

Replication ID

answer

A Field Size property that establishes a unique identifier for replication of tables, records, and other objects in databases created using Access 2003 and earlier versions and uses 16 bytes.

question

Set (a property)

answer

To select or enter a property for a field.

question

Single

answer

A Field Size property that stores positive and negative numbers to precisely seven decimal places and uses four bytes.

question

Table Design grid

answer

The part of the Table window in Design view that contains the values for the Field Name, Data Type, and Description field properties.

question

Aggregate function

answer

A function that performs an arithmetic operation on selected records in a database.

question

All Table

answer

The default group of objects in the Access Navigation Pane.

question

Alternate Fill/Back Color button

answer

The Access button that lets you change the alternating background color of a datasheet.

question

And logical operator

answer

The logical operator you use in a query when you want a record selected only if two or more conditions are met.

question

AutoFilter

answer

An Access feature that enables you to quickly sort and display field values in various ways.

question

Calculated field

answer

A fields that displays the results of an expression in a query datasheet or a form or report, but does not exists as a field in the database.

question

Comparison operator

answer

In a query, an operator that asks Access to compare the value in a database field to a condition value and to select all the records for which the relationship is true.

question

Condition

answer

A criterion, or rule, that determines which records are selected in a query.

question

Design grid

answer

The portion of the Query window in Design view in which you specify the fields and record selection criteria for the query you are creating.

question

Editing mode

answer

The mode in which you can insert or delete characters in a field value based on the location of the insertion point.

question

Exact match

answer

A type of query in which the value in the specified field must match the condition exactly in order for the record to be included in the query results.

question

Expand indicator

answer

In a datasheet, the plus sign that lets you display the related records in the subdatasheet.

question

Expression

answer

A statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation.

question

Expression builder

answer

An Access tool that makes it easy for you to create an expression in a query by providing boxes for entering the expression, buttons for common operators, and lists of expression elements, such as tables and field names.

question

F2 key

answer

The function key you press to switch between navigation mode and editing mode.

question

Filter

answer

A set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of records.

question

Filter By Form

answer

A filtering technique that changes the datasheet to display empty fields, allowing you to select a value from a list in any blank field to apply a filter that selects only those records containing that value.

question

Filter By Selection

answer

A filtering technique that lets you select all or part of a field value in a datasheet or form, and then display only those records that contain the selected value in the field.

question

Find command

answer

A command you use to search for data in a form or datasheet so that you can display only those records you want to view.

question

Group by Operator

answer

In a query, an operator that divides the selected records into groups based on the values in the specified field.

question

Logical operator

answer

In a query, an operator that allows you to combine two or more conditions.

question

Maintain (a database)

answer

To add, change, and delete records in database tables to keep them current and accurate.

question

Navigation mode

answer

The mode in which Access selects an entire field value, and your typed entry replaces the highlighted field value.

question

Nonunique sort field

answer

A sort field for which more than one records can have the same value.

question

Or logical operator

answer

The logical operator you use in a query when you want a record selected if at least one of the specified conditions is met.

question

Plus sign

answer

In a datasheet, a symbol indicating that records have related records in another table.

question

Primary sort field

answer

The first sort field specified that determines the order of records in a datasheet.

question

Query by example (QBE)

answer

An example of the information you are requesting from Access in a query.

question

Query Wizard

answer

An Access tool that asks you a series of questions, and then creates a query based on your answers.

question

Recordset

answer

The set of records that results from running a query.

question

Run (a query)

answer

To answer a query and display the results.

question

Secondary sort field

answer

A second field that determines the order of records that are already sorted by the primary sort field.

question

Select query

answer

A query in which you specify the fields and records you want Access to select, and the results are returned in the form of a datasheet.

question

Sort

answer

To rearrange records in a specified order or sequence.

question

Sort field

answer

The field used to determine the order or records in a datasheet.

question

Subdatasheet

answer

A datasheet that displays the records related to the current record.

question

Tables and Related Views

answer

The default category of objects in the Access Navigation Pane.

question

Unique sort field

answer

A sort field whose value is different for each record.

question

Update (a database)

answer

To add, change, and delete records in database tables to keep them current and accurate.

question

Zoom box

answer

A large text box you can use to enter text, expressions, or other values when working with queries.

question

AutoFormat

answer

A predefined style that you can apply to a form or report.

question

Conditional formatting

answer

Special formatting applies to afield values that meet specified conditions.

question

Control

answer

An item on a form or report, such as a text box or a command button, that you can manipulate to modify the form's or report's appearance.

question

Detail record

answer

In a report based on two tables, the set of field values displayed for each field in the related table.

question

Form Wizard

answer

An Access tool that asks you a series of questions, and then created a form based on your answers.

question

Grouped report

answer

A report in which the data from a record in the primary table appears as a group, followed on subsequent lines of the report by the joined records from the related table.

question

Layout view

answer

An Access view in which you can make design changes to a form or report while it is displaying data so that you can immediately see the effects of changing the design.

question

Main form

answer

In a form based on two tables, the form that contains data from the primary table.

question

Move handle

answer

The larger square in a selected control's upper-left corner that you use to move the control.

question

Report Wizard

answer

An Access tool that asks you a series of questions, and then creates a report based on your answers.

question

Subform

answer

In a form based on two tables, the form that contains data from the related table.

question

Wildcard Character

answer

A placeholder you use when you know only part of a search value or when you want the search value to start or end with a specific character or match a certain pattern.

question

& (ampersand) operator

answer

A concatenation operator that joins text expressions.

question

Append Only property

answer

A field property for a Memo field that lets you edit the field value and, when set to Yes, causes Access to keep a historical record of all versions of the field value. You can view each version of the field value, along with a date and time stamp of when each version change occurred.

question

Caption property

answer

A property that specifies the text that appears in a label in a form or report, or that appears in the column heading in a datasheet.

question

Crosstab query

answer

A query that performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format.

question

Field validation rule

answer

Setting the Validation Rule and Validation Text properties for a field to verify its values by comparing them to a constant or a set of constants.

question

Find duplicates query

answer

A select query that finds duplicate records in a table or query. You specify the fields in the query or table you want to compare and, if two or more records have the same values for those fields, those records appear in the query recordset.

question

Find unmatched query

answer

A select query that finds all records in a table or query that have no related records in a second table or query.

question

IIf (Immediate If) function

answer

A function that returns one of two values based on whether the condition being tested is true or false.

question

In comparison operator

answer

A comparison operator that defines a condition with a list of two or more values for a field. If a record's field value matches one value from the list of defined values, then Access selects and includes that record in the query results.

question

Input mask

answer

A field property to define a predefined format used to enter and display data in a field.

question

IsNull function

answer

A function that tests a field value or an expression for a null value; if the field value or expression is null, the result is true; otherwise, the result is false.

question

Like comparison operator

answer

A comparison operator that selects records by matching filed values to a specific pattern that includes one or more wildcard characters.

question

List-of-values match

answer

A selection of records whose value for the designated field matches one of two or more simple conditions.

question

Literal display character

answer

A special character that automatically appears in specific positions of a field value, usually associated with the field's input mask.

question

Lookup field

answer

A foreign key field that lets you optionally display the foreign key value and other field values from the related record in the primary table. Also known as the Lookup Wizard field.

question

Not logical operator

answer

A logical operator that negates a criterion or selects records for which the designated field does not match the criterion.

question

Object dependencies task pane

answer

A task pane that displays a collapsible list of the dependencies among the objects in an Access database; you click the list's expand indicators to show or hide different levels of dependencies.

question

Object dependency

answer

A relationship that exists between two objects when a change to the properties of data in one object affects the properties of data in the other object.

question

Parameter query

answer

A query that displays a dialog box to prompt you to enter one or more criteria values when you run the query.

question

Pattern match

answer

A selection of records with a value for the designated field that matches the pattern of the simple condition value.

question

Property propagation

answer

An Access feature that updates control properties in objects when you modify a table field property.

question

SQL (Structured Query Language)

answer

A standard language used in a querying, updating, and managing relational database.

question

Table validation rule

answer

A rule that compares one field value in a table record to another field value in the same record to verify their relative accuracy.

question

Text Format property

answer

A field property for a Memo field that determines whether you can format the field contents (Rich Text setting) or cannot format the field contents (Plain Text setting).

question

Top values property

answer

A query property that lets you limit the number of records in the query results to a specific number or a percentage.

question

Trusted folder

answer

A folder on a drive or network that you designate as trusted and where you place databases you know are safe. When you open a database located in a trusted folder, Access no longer displays a security warning.

question

Validation rule property

answer

A field property value that specifies the valid values that users can enter in a field.

question

Validation text property

answer

A field property value that will be displayed in a dialog box if a user enters an invalid value for the field.

question

*

answer

Wildcard character to match any number of characters. It can be used as the first and/or last character in the character string.

question

?

answer

Wildcard character to match any single ALPHABETIC character.

question

[ ]

answer

Wildcard character to match any single character within the brackets.

question

!

answer

Wildcard character to match any character not within brackets.

question

-

answer

Wildcard character to match any one of a range of characters. The range must be in ascending order (a - z, NOT z - a).

question

#

answer

Wildcard character to match any single NUMERIC character.

question

=

answer

Operator for equal to (optional; default operator)

question

;

answer

Operator for less than

question

;=

answer

Operator for less than or equal to

question

;

answer

Operator for greater than

question

;=

answer

Operator for greater than or equal to

question

;;

answer

Operator for not equal to

question

Between...And...

answer

Operator for between two values (inclusive)

question

In ()

answer

Operator for in a list of values

question

Like

answer

Operator that matches a pattern that include wildcards

Examples Of Questions On The Access Test For College – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards