|Home||Workshops||Calendar||Registration||General Information||About FAST3||Contact Us|
Our Microsoft Access workshops include:
The Level 1 course is for those whose job responsibilities include working with table data, asking questions of the data, and generating reports. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as designing databases.
Upon successful completion of Level 1, attendees will be able to identify the components of the Access 2013 environment; modify, sort and filter records, and work with lookups; join data from different tables in a query, perform calculations in a query, create parameter queries, action queries, unmatched and duplicate queries, and summarize data; and generate reports.
In Access 2013 Level 2, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Topics will include designing a relational database; working with query joins; learning ways to organize a database for efficiency; look at sharing data across applications; and advanced reporting.
The Level 1 course is for those whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.
Upon successful completion of Level 1, attendees will be able to identify the components of the Access 2010 environment; identify the components of a database; organize and view data in tables; query a database; design forms; and generate reports.
This intermediate-level course is 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.