Access 2 - Queries

Some, but not all, of the results of the queries are shown here.

Project (AlisaVendingServices Database)

Page A2-12

Page A2-15

Page A2-17


 

Page A2-18


 

Page A2-20


 

Page A2-21


 

Page A2-22


 

Page A2-23


 

Page A2-24


 

Page A2-26


 

Page A2-27


 

Page A2-28


 

Page A2-32


 

Page A2-33


 

Page A2-35


 

Page A2-38


 

Page A2-40


 

Page A2-41 (AverageAmountPaidByDriver)


Apply Your Knowledge (BeyondClean database)


Step4


 

Step8


 

Step12


 

Step15


 

Step19


Lab 1 (WoodenCrafts database)

Step2


 

Step3


Step4

Step5

Step6

 

Step7

 

Step8

 

Step9

 

Step10

 

Step11

 

Step13

 

Step14

 

Step15

Step16 (Suppliers and Products)

Access 3

Project (AlisaVendingServices database)

bulletPage3-25 (query to update Customer Type)
bulletPage3-27 (query to delete zip 36114)

Lab 1 (WoodenCrafts database)

bulletStep9 (delete query records start with R)