What is the purpose of the AUTOEXEC macro:
To automatically execute a certain macro when the user clicks a button
To perform specified actions when the database is opened
To automatically execute the quitting of the database
A crosstab query is used to :
Cross
reference tables
Provide a pivot or summary snapshot of data in a matrix format
Cross off old data in a table for archiving purposes
An action query can:
Update data in a table, make a table, delete data in a table, append data to a
table
Update data in a table, delete data in a table, append data to a table
Update data in a table, append data to a table
A Subreport is :
A report pasted into another report
A report embedded and linked into the design of another report
A report that you can jump to from another report via a command button
To show matching data between a main form
and a sub form they must have matching fields in which two properties :
Main
form and sub form properties
Master and
Child properties
Form and
sub form properties
An IF block in
a
macro is used to :
Calculate different results
Present varying formula results for different conditions
Run different macros for different conditions
To compact a database you not go to :
The File Tab
The Developer Tab
The Database
Tools Tab
The AUTOKEYS SUBMACRO is to :
Control what actions a key pressed will do
Automatically key in data for the user when a key is pressed
Both
The default
join type is :
Inner
Outer
Combined
To make a table including information from
other tables and calculations you would :
Create a
Select query
Create an
Action query
Create a
Crosstab query