Access Queries

Access Queries - You must save each query you do with the page number or step number even when the book says to not save or it says to clear the grid. Here are the queries you need to save:

Access 2

To see what your database window should look like, click here.

Project (AlisaVendingServices database)

	PageA2-12
	PageA2-15 Note: For full credit you have to only have the Customer.* as shown in figure 2-17
	PageA2-17
	PageA2-18 Look at the wildcard. Gr* means all text that starts with Gr. Way would be all text that has Way anywhere in the text. It could be 123 4th Way. It could be Way Cool. It could be I like the way you think. You'll need to remember how this wildcard works for later assignments.
	PageA2-20
	PageA2-21
	PageA2-22
	PageA2-23
	PageA2-24
	PageA2-26
	PageA2-27
	PageA2-28
	PageA2-32
	PageA2-33
	PageA2-35
	PageA2-38
	PageA2-40
	AverageAmountPaidByDriver

Apply Your Knowledge (BeyondClean database)

	Step4
	Step8
	Step12
	Step15
	Step19

Lab 1 (WoodenCrafts database)

	Step2
	Step3 (See note on PageA2-18 above to put in all fields for full credit).
	Step4
	Step5
	Step6
	Step7
	Step8
	Step9
	Step10
	Step11
	Step13
	Step14
	Step15
	Step16