graphic2
graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.2 Modify a Query: Add New Fields

Add Fields to the Query

3. Try it: Add Fields to the Query

From tblReceipt select the following Fields:

ReceiptID

CustomerID

DateRented

 

From CustomerNameSQ select these Fields:

FullName
Address1

CityStateZip

HomePhone

 

Do This, Now: Save the Query

Go to File->Save.

Enter a name: ReceiptSQ.

Click OK.

 

Close the Query. The Record Source for the Receipt Form is done.

Query Tools ->Design->Query Type->Select