Description
This hands-on class presents the planning, design, use and maintenance of a database system using Access as the tool. Students learn to analyze a database structure and create a new database by defining the tables and data types. Students work with databases to create relationships between tables, do advanced queries and reports. Students learn to create calculated categories to manipulate data, as well as creating Web-based applications. Students learn to create macros to automate database functions for the end user. A final unit presents the basics of SQL table creation and manipulation using MySQL. This course is designed to prepare students to take the current Microsoft Access exam.