AACC offers a wide array of noncredit database training courses. Pick the one that's right for you.
For upcoming course dates, times, location and cost, visit AACC’s course search and select Noncredit for course type and Computer Technology (NC) as subject or click on the course number below.
CTC-316 - Microsoft Access 2007 - Level 1
Learn how to design and create databases. Work with tables, fields, and records; sort and filter data; and create simple queries. Build forms and reports. Organize data efficiently by using a database management system.
CTC-317 - Microsoft Access 2007 - Level 2
Learn intermediate features of Access. Explore how to normalize data, create charts and join queries, add objects, and print reports and labels. Learn to work with lookup fields, subdatasheets and PivotTables and Pivot Charts.
CTC-318 - Microsoft Access 2007 - Level 3
Lean advanced functions of Access. Use various queries and create macros. Work with database objects, XML documents and Windows SharePoint Services. Learn to optimize and secure databases, create hyperlink fields, and employ MS Outlook 2007
CTR-336 Microsoft Access 2010-LEVEL I
Learn database concepts, the Access environment and Help systems. Learn how to design and create databases; work with tables, fields and records; sort and filter data; and set field properties and data entry rules. Discover how to create queries, forms and reports. CEUs awarded. $155 includes $50 fee. Prerequisite: Knowledge of database structure.
CTR-337 Microsoft Access 2010 Level 2
Learn how to normalize data, manage table relationships and enforce referential integrity. Work with lookup fields and subdatasheets. Create join queries, calculated fields and summary values. Add objects to forms and create advanced form types. Print reports and labels. Create and modify PivotTables and PivotCharts. CEUs awarded. $155 includes $50 fee. Prerequisite: CTR 336 Microsoft Access 2010 - Level 1 or equivalent knowledge.
OLI 329 Introduction to Database Development ONLINE Learn how to utilize database applications to apply a systematic, structured approach to a database. Learn the phases of a system development project step by step. CEUs awarded.
OLN-392 - Introduction to Oracle ONLINE
Use the Oracle database management system to plan, organize and manage data. Build various database objects. Develop simple SQL, DLL, and Data Control Language statements to create, update and delete database objects and records information. Includes ways to query data and create reports. Prerequisite: CPT 380 and working knowledge of database structures.
ONL-377 - Intermediate Oracle ONLINE
Learn to build fully functional PL/SQL programs using procedures packages debugging routines, database structures triggors and cursor processing. Prerequisite OLN 392 Introduction to Oracle.
OLN-391 - Introduction to Structured Query Language (SQL) ONLINE
Learn key SQL concepts and gain a solid working knowledge of this powerful, universal database programming language. Work with the basic structure of relational databases. Learn to read and develop simple and complex SQL statements. Use advanced data manipulation techniques. CEUs awarded. Prerequisite: CTT 365 or equivalent knowledge and working knowledge of database structure.
For more information contact us today at firstname.lastname@example.org or call 410-777-2325.