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
Macro conditions allow macros to be run
based on :
Choices in a
list box
Choices in a
combo box
Both
To compact a database you would go to :
File in the menu
Tools in the menu
Database in the
menu
The AUTOKEYS MACRO is to :
Control what actions a key pressed will do
Automatically key in data for the user when a key is pressed
Both
Customising the toolbar in an Access
database requires the Visual Basic for Applications command :
ShowToolbar
DoToolbar
DisplayToolbar
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