This is an intermediate-level course targeted for individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the integration of Access data with other applications such as Microsoft Word or Excel. Upon successful completion, attendees will be able to streamline data entry and maintain data integrity; join tables to retrieve data from unrelated tables; create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries; improve forms; customize reports to organize the displayed information and produce specific print layouts; and share data between Access and other applications.
Prerequisite: Completion of Level 1 or equivalent experience
Hours: 7