|Home||Workshops||Calendar||Registration||General Information||About FAST3||Contact Us|
Our Microsoft Access workshops include:
Access 2013: Getting Started (2 hours)
Access 2013: Queries (2 hours)
Access 2013: Forms & Reports (2 hours)
Access 2013, Level 1 (7 hours)
Access 2013, Level 2 (7 hours)
This two-hour short course will introduce you to Microsoft's relational database application, Access 2013. Attendees will take a tour of the objects in an Access database, including tables, queries, forms, and reports.
In this two-hour short course attendees will learn how to create Access queries. We will learn about the different types of queries: simple select queries, parameter queries, crosstab queries, and action queries. We will also work with calculated fields in a query.
Access forms provide a fast and easy way to enter and view data in a table. Reports are the end product of a database and are the best way to format, summarize, and print data. In this 2-hour short course we will cover the basics of working with Access 2013 forms and reports. You will learn the steps for setting up a form or report from design/layout to creation.
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.