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)
 | Page3-25 (query to update Customer Type) |
 | Page3-27 (query to delete zip 36114) |
Lab 1 (WoodenCrafts database)
 | Step9 (delete query records start with R)
|
|