Examples Of Questions On The Access Test For College – Flashcards
173 test answers
Unlock all answers in this set
Unlock answers 173question
Column selector
answer
In a datasheet, the column heading (also called the field selector), which you click to select the entire column.
Unlock the answer
question
Common field
answer
A field that appears in more that one table, allowing you to connect the records in the separate tables.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Database
answer
A collection of related tables stored in the same file.
Unlock the answer
question
Database management system (DBMS)
answer
A software program that lets you create databases and then manipulate data in them.
Unlock the answer
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.
Unlock the answer
question
Datasheet selector
answer
A box in the upper-left corner of a datasheet that lets you select the entire datasheet.
Unlock the answer
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.
Unlock the answer
question
Field
answer
A single characteristic or attribute of a person, place, object, event, or idea.
Unlock the answer
question
Field selector
answer
In a datasheet, the column heading (also known as the column selector), which you click to select the entire column.
Unlock the answer
question
Field value
answer
The specific value, or content, of a field in a record.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
ID column
answer
The default field Access creates to serve as the primary key field for all new tables.
Unlock the answer
question
Microsoft Access Window
answer
The program window that appears when you start the Access program.
Unlock the answer
question
Microsoft Office Access 2007
answer
A database program you use to enter, organize, display, and retrieve related information.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Pencil symbol
answer
The symbol that appears in a row selector to indicate that the record is being edited.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Record
answer
A complete set of field values for a specific person, place, object, event, or idea. Also known as a row.
Unlock the answer
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.
Unlock the answer
question
Relational database
answer
A collection of related tables (relations) stored in the same file.
Unlock the answer
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.
Unlock the answer
question
Report
answer
A formatted printout (or screen display) of the contents of one or more tables in a database.
Unlock the answer
question
Report tool
answer
An Access tool that places all the fields from a table or query on a report.
Unlock the answer
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.
Unlock the answer
question
Simple Query Wizard
answer
An Access wizard that lets you quickly select the records and fields for a query.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Template
answer
A predefined database that includes professionally designed tables, forms, reports, and other objects.
Unlock the answer
question
Text (data type)
answer
An Access data type that allows field values containing letters, digits, and other characters.
Unlock the answer
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.
Unlock the answer
question
Byte
answer
A Field Size property that stores whole numbers from 0 - 255 in one byte.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Composite key
answer
A primary key that consists of two or more fields. Also known as a concatenated key.
Unlock the answer
question
Ctrl + '
answer
The keyboard shortcut for inserting the value from the same field in the previous record into the current record
Unlock the answer
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.
Unlock the answer
question
Decimal
answer
A Field Size property that stores positive and negative numbers precisely 28 decimal placed and uses 12 bytes.
Unlock the answer
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.
Unlock the answer
question
Delimited
answer
A type of text file in which fields of data are separated by a character such as a comma or tab.
Unlock the answer
question
Description property
answer
The optional property you can use to enter a description for a field to explain its purpose or usage.
Unlock the answer
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.
Unlock the answer
question
Double
answer
A Field Size property that stores positive and negative number to precisely 15 decimal places and uses eight bytes.
Unlock the answer
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.
Unlock the answer
question
F1 key
answer
The function key you press to display Help information, such as for the current property in Table Design view.
Unlock the answer
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.
Unlock the answer
question
Field list
answer
A small window listing the fields contained in a table.
Unlock the answer
question
Field properties pane
answer
The part of the Table window in Design view that contains the properties for the selected field.
Unlock the answer
question
Field size property
answer
The property that defines a field's maximum storage size for text, number, and AutoNumber fields.
Unlock the answer
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.
Unlock the answer
question
Integer
answer
The Field Size that stores whole number from -32,768 to 32,767 in two bytes.
Unlock the answer
question
Join
answer
To relate tables through a common field
Unlock the answer
question
Join line
answer
In the Relationships window, the line that connects the common field that joins two tables.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Orphaned record
answer
A record whose matching record in either the primary or related table has been deleted.
Unlock the answer
question
Primary table
answer
The "one" table in a one-to-many relationship.
Unlock the answer
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.
Unlock the answer
question
Properties
answer
The characteristics of each field in a table.
Unlock the answer
question
Referential integrity
answer
The rule that requires each non-null foreign key value to match a primary key value in the primary table.
Unlock the answer
question
Related table
answer
The "many" table in the one-to-many relationships.
Unlock the answer
question
Relationships window
answer
The Access window in which you define the view and the relationships among a database's tables.
Unlock the answer
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.
Unlock the answer
question
Set (a property)
answer
To select or enter a property for a field.
Unlock the answer
question
Single
answer
A Field Size property that stores positive and negative numbers to precisely seven decimal places and uses four bytes.
Unlock the answer
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.
Unlock the answer
question
Aggregate function
answer
A function that performs an arithmetic operation on selected records in a database.
Unlock the answer
question
All Table
answer
The default group of objects in the Access Navigation Pane.
Unlock the answer
question
Alternate Fill/Back Color button
answer
The Access button that lets you change the alternating background color of a datasheet.
Unlock the answer
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.
Unlock the answer
question
AutoFilter
answer
An Access feature that enables you to quickly sort and display field values in various ways.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Condition
answer
A criterion, or rule, that determines which records are selected in a query.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Expand indicator
answer
In a datasheet, the plus sign that lets you display the related records in the subdatasheet.
Unlock the answer
question
Expression
answer
A statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation.
Unlock the answer
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.
Unlock the answer
question
F2 key
answer
The function key you press to switch between navigation mode and editing mode.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Logical operator
answer
In a query, an operator that allows you to combine two or more conditions.
Unlock the answer
question
Maintain (a database)
answer
To add, change, and delete records in database tables to keep them current and accurate.
Unlock the answer
question
Navigation mode
answer
The mode in which Access selects an entire field value, and your typed entry replaces the highlighted field value.
Unlock the answer
question
Nonunique sort field
answer
A sort field for which more than one records can have the same value.
Unlock the answer
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.
Unlock the answer
question
Plus sign
answer
In a datasheet, a symbol indicating that records have related records in another table.
Unlock the answer
question
Primary sort field
answer
The first sort field specified that determines the order of records in a datasheet.
Unlock the answer
question
Query by example (QBE)
answer
An example of the information you are requesting from Access in a query.
Unlock the answer
question
Query Wizard
answer
An Access tool that asks you a series of questions, and then creates a query based on your answers.
Unlock the answer
question
Recordset
answer
The set of records that results from running a query.
Unlock the answer
question
Run (a query)
answer
To answer a query and display the results.
Unlock the answer
question
Secondary sort field
answer
A second field that determines the order of records that are already sorted by the primary sort field.
Unlock the answer
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.
Unlock the answer
question
Sort
answer
To rearrange records in a specified order or sequence.
Unlock the answer
question
Sort field
answer
The field used to determine the order or records in a datasheet.
Unlock the answer
question
Subdatasheet
answer
A datasheet that displays the records related to the current record.
Unlock the answer
question
Tables and Related Views
answer
The default category of objects in the Access Navigation Pane.
Unlock the answer
question
Unique sort field
answer
A sort field whose value is different for each record.
Unlock the answer
question
Update (a database)
answer
To add, change, and delete records in database tables to keep them current and accurate.
Unlock the answer
question
Zoom box
answer
A large text box you can use to enter text, expressions, or other values when working with queries.
Unlock the answer
question
AutoFormat
answer
A predefined style that you can apply to a form or report.
Unlock the answer
question
Conditional formatting
answer
Special formatting applies to afield values that meet specified conditions.
Unlock the answer
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.
Unlock the answer
question
Detail record
answer
In a report based on two tables, the set of field values displayed for each field in the related table.
Unlock the answer
question
Form Wizard
answer
An Access tool that asks you a series of questions, and then created a form based on your answers.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Main form
answer
In a form based on two tables, the form that contains data from the primary table.
Unlock the answer
question
Move handle
answer
The larger square in a selected control's upper-left corner that you use to move the control.
Unlock the answer
question
Report Wizard
answer
An Access tool that asks you a series of questions, and then creates a report based on your answers.
Unlock the answer
question
Subform
answer
In a form based on two tables, the form that contains data from the related table.
Unlock the answer
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.
Unlock the answer
question
& (ampersand) operator
answer
A concatenation operator that joins text expressions.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Input mask
answer
A field property to define a predefined format used to enter and display data in a field.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
List-of-values match
answer
A selection of records whose value for the designated field matches one of two or more simple conditions.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Pattern match
answer
A selection of records with a value for the designated field that matches the pattern of the simple condition value.
Unlock the answer
question
Property propagation
answer
An Access feature that updates control properties in objects when you modify a table field property.
Unlock the answer
question
SQL (Structured Query Language)
answer
A standard language used in a querying, updating, and managing relational database.
Unlock the answer
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.
Unlock the answer
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).
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
Validation rule property
answer
A field property value that specifies the valid values that users can enter in a field.
Unlock the answer
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.
Unlock the answer
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.
Unlock the answer
question
?
answer
Wildcard character to match any single ALPHABETIC character.
Unlock the answer
question
[ ]
answer
Wildcard character to match any single character within the brackets.
Unlock the answer
question
!
answer
Wildcard character to match any character not within brackets.
Unlock the answer
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).
Unlock the answer
question
#
answer
Wildcard character to match any single NUMERIC character.
Unlock the answer
question
=
answer
Operator for equal to (optional; default operator)
Unlock the answer
question
;
answer
Operator for less than
Unlock the answer
question
;=
answer
Operator for less than or equal to
Unlock the answer
question
;
answer
Operator for greater than
Unlock the answer
question
;=
answer
Operator for greater than or equal to
Unlock the answer
question
;;
answer
Operator for not equal to
Unlock the answer
question
Between...And...
answer
Operator for between two values (inclusive)
Unlock the answer
question
In ()
answer
Operator for in a list of values
Unlock the answer
question
Like
answer
Operator that matches a pattern that include wildcards
Unlock the answer
