|Home||Workshops||Calendar||Registration Form||General Information||About FAST3||Contact Us|
Our Microsoft Access workshops include:
In this 1-hour overview, we will explore the new interface and features of Access 2013. First we will take a look at an Access web app, which is a new type of database that you can build in Access, then use and share with others as a SharePoint app in a web browser. With Access 2013, you can also still create traditional desktop databases from scratch. Or, try out a template to create an app, a desktop database, or Access 2010-style web database. Other new features include pre-designed table templates, call outs for setting properties, related items control (provides a quick way to list and summarize data from a related table or query), Auto-complete control, drill through links, and more.
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.