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.
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.
CTR-338 Microsoft Access 2010 Level 3
Learn how to query with SQL including crosstab, parameter and action queries. Discovery how to import, export and link database objects. Learn how to create hyperlink fields and macros; optimize, split and back up databases; and password-protect and encrypt databases. Interact with XML documents and set Access options and properties. CEUs awarded. $155 includes $50 fee.
CTR-361 Microsoft Access 2013 Level 1
Learn the basic operations of Access 2013 to perform day-to-day tasks. Discuss the advantages of a relational database program to business processes. Practice creating tables and forms, and producing reports. Textbook information available at AACC Bookstore. CEUs awarded. $157 includes $52 fee. Note: Knowledge of database structure recommended.
CTR 361 Microsoft Access 2013 Level 2
Increase knowledge of Access 2013 to take advantage of the more advanced features. Examine advanced queries, forms, calculated fields and summary values. Print reports and labels. Create and modify PivotTables and PivotCharts. Textbook information available at AACC Bookstore. CEUs awarded. $157 includes $52 fee. Prerequisite: CTR 361 Access 2013 Level 1 or equivalent experience.
CTR-358 Introduction to Database Design
Learn principles to create new databases or redesign existing ones. Discuss how to choose the best names for tables and fields, assign primary keys, set up relationships and implement normalization rules and field key attributes. Textbook information available at AACC Bookstore. CEUs awarded. $282 includes $32 fee. Prerequisite: CTR 361 Access 2013 Level 1 or databases experience.
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-2142.