Rick Winter - Teacher at JA Back Door, Author, School Board, and Life Long Student
Links | References | Resume | My Students Whiteboard | School Board | Other

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.

bulletProject (AlisaVendingServices database)
bullet

PageA2-12

bullet

PageA2-15 Note: For full credit you have to only have the Customer.* as shown in figure 2-17

bullet

PageA2-17

bullet

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.

bullet

PageA2-20

bullet

PageA2-21

bullet

PageA2-22

bullet

PageA2-23

bullet

PageA2-24

bullet

PageA2-26

bullet

PageA2-27

bullet

PageA2-28

bullet

PageA2-32

bullet

PageA2-33

bullet

PageA2-35

bullet

PageA2-38

bullet

PageA2-40

bullet

AverageAmountPaidByDriver

bulletApply Your Knowledge (BeyondClean database)
bullet

Step4

bullet

Step8

bullet

Step12

bullet

Step15

bullet

Step19

bulletLab 1 (WoodenCrafts database)
bullet

Step2

bullet

Step3 (See note on PageA2-18 above to put in all fields for full credit).

bullet

Step4

bullet

Step5

bullet

Step6

bullet

Step7

bullet

Step8

bullet

Step9

bullet

Step10

bullet

Step11

bullet

Step13

bullet

Step14

bullet

Step15

bullet

Step16

 

Rick Winter Home | Education | Links | References | Resume | My Students | School Board | Other