Click Here to Get Started
Sample Files
Administrator Objectives:
Lesson Objectives: Learn how to
modify form controls with Visual Basic Programming. This lesson will
demonstrate how to design queries based on many tables, modify
relationships and how to create reports that display calculated fields. In this lesson
you will:
Design a query based
on many tables Page 3
Practice how to add
Data Fields in a query
Page 5
Learn how to
concatenate the Data Fields Page 6
Practice with the
DateDiff Function Page 10
Learn how to use the
Left() Function
Page 11
Learn how to use the
IIF() Function
Page 12
Practice with a
Parameter Query
Page 16
Practice with the
Like Operator Page 18
Learn how to
calculate with Queries Page 27