Full course description
Ybor City Campus - Collaboration
1602 N 15th Street
Tampa, FL 33605
Room: HCS 132
Days: Tuesday from 8:30am - 4:30pm
Start Date: Wednesday, September 28, 2016
End Date: Wednesday, September 28, 2016
Instructor: Mark Aruda
Note: The book will be given by the instructor.
Description: Microsoft Access 2013 Level 3-Advanced is the last of a three part series. The delivery method involves hands-on experience in a computer center using Access software. Students will learn skills, such as how to Create Advanced Queries & Macros, Importing & Exporting Objects and Optimizing Resources in the Database.
General Topics: Querying with SQL, Advanced Queries, Macros, Working with Objects and Database Management.
Prerequisites: Be familiar with the environment and basic functions of Access. Suggested course: Microsoft Access 2013 Level 2-Intermediate
Who should attend? Office professionals, small business owners and anyone who needs advanced skills and concepts to fully utilize Access in managing data.
After taking this course, participants will be able to:
* Query with SQL - SQL and Access, write SQL queries and attach queries to controls
* Advanced Queries - Create crosstab & parameter queries and using action queries
* Macros - Create, run & modify macros, create macros to provide user interaction and create macros for data transfer
* Objects - Import, export & link objects, work with XML documents and use hyperlink fields
*Database Management - Optimize resources, protect database and set options & properties