|
The goal
of this lesson is to create a Query that can fill in the information
for a customer receipt or report. This Query will use a calculated
Field to combine several Fields together to
create a mailing label. This Query
will use tblCustomers for the Record Source. Know your data...
2.
Try it: Review the Customer Table Go to
All Access Objects. Double
click tblCustomers to open it in Datasheet View. What Do
You See? The Customer Table has 5 customers. The Table includes
the name and address Fields. Close tblCustomers. Keep
going...
Home
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.3. Manipulate fields: Create
Calculated Fields
|
|
| |
