Module 6
Specifies the table or query that provides the fields for the form
What is Record Source property?
Provides an interactive view of a report
What is Report view?
Contains data that is no longer needed for current processing; but you might need to reference in the future
What is a history table?
A recorded sequence of commands or keystrokes that can be saved and then executed, or run, in a single action by the user
What is a macro?
A text file in which commas separate values
What is a CSV (comma-separated values) file?
A control that lets users type an entry
What is a text box?
Appears once at the beginning of a report
What is the Report Header section?
Adds records from existing tables or queries to the end of another table
What is an append query?
A special dialog box that contains a message and a command button but no options
What is a message box?
Analyzes a single table and splits it into two or more tables
What is the Table Analyzer?
A control that combines the features of a text box and a list box
What is a combo box?
Appears at the top of each page of a report
What is the Page Header section?
Creates a new table by copying records from one or more existing tables
What is a make-table query?
A macro is executed one action at a time with a pause between actions
What is single step mode?
The programming language provided with Access and other Office Programs
What is Visual Basic for Applications (VBA)?
Creates detailed documentation of all, or selected, objects in a database
What is the Documenter?
Contains the bound controls to display the field values for each record
What is the Detail section?
A query that adds, changes, or deletes multiple table records at a time
What is an action query?
Specifies how an object responds when an event occurs
What is an event property?
Executes instructions and accepts input values but does not return a value and cannot be used in expressions
What is a sub procedure?
Creates a form in a datasheet format that contains all the fields in the source table or query
What is a datasheet tool?
Appears once at the end of a report and is used for report totals
What is the Report Footer section?
Delets a group of records from one or more tables if the records match the specified criteria
What is a delete query?
The group of statements that are executed when an event occurs
What is a procedure?
An object where you can store a group of related procedures together
What is a module?