Access - Key Criteria Flashcards
1
Q
Date
A
> =#01/09/2018# And <=#30/09/2018#
What does this do? - Returns all orders made in Sepetember
2
Q
Records that begin with a certain letter
A
Like A*
What does this do? - Returns records for all fields that start with an A
3
Q
Parameters
A
[Which customer?]
What does this do? - When query is run, it will ask the user to input a customer
4
Q
How to multiply two fields together
A
Total_Price: [Item_Price]*[Qty]
What does this do? First part before the colon is the name of the new calculated field. Name of the fields to multiply are in brackets, asterisk used to multiply together.
