If you put a text field into a form page
header it will show:
On Screen
When Printed
Both
When faced with a Many to Many relationship
you :
Create two one to many relationships between two tables
Create a third intermediate table
Both
Which DLOOKUP function in a form is correct :
=DLOOKUP("[CustomerName]","tblCustomer","[CustomerID]=Forms![Orders].[CustomerID]")
=DLOOKUP([CustomerName],tblCustomer,[CustomerID]=Forms![Orders].[CustomerID])
=DLOOKUP([CustomerName],tblCustomer)
Which IF function in a form is correct :
=IF([AmountSpent]=0,[Discount]=0,[Discount]=10%)
=IF([AmountSpent]=0,0,0.10)
=IIF([AmountSpent]=0,0,0.10)
Which Average function in a report is correct:
=AVERAGE([Amount])
=AVG([Amount])
=AVERAGE("[Amount]")
To calculate the GST at 12.5% of Cost in a
query which formula is correct :
GST:[Cost]*12.5%
GST=[Cost]*12.5%
GST:[Cost]*0.125
The purpose of a parameter query is to :
Run a query for a variety of input
Run a query for control the parameters entered by the user
Import data
To automate and
schedule the importation of data create a :
Parameter Query
Linked table
Import
Specification
Which type of form gives you two views of the same
data:
Split Form
PivotTable Form
Multiple Items Form
To indicate that a macro is to run
when a field is altered use the event procedure:
OnChange
AfterUpdate
OnEnter