CSC     195

195     CSC 195 – INTERMEDIATE MICROSOFT ACCESS 2010 (1 Cr) – You’ll start by learning how to create your new database by importing information from Excel spreadsheets into tables. Using action queries, you’ll add and update key fields that allow you to build relationships among the tables. Then you’ll master the steps for building complex yet easy-to-use forms to manage table data. The course offers you tips and techniques for optimizing your database, including ways to build crosstab and summary queries so you can access information quickly and easily. You’ll also learn about outer table joins that can make you queries more effective. Once you’ve built your database, you’ll examine how to build reports using conditional formatting to highlight key data points, and explore Visual Basic, a powerful programming language that allows you to automate simple and complex tasks. Finally, you’ll put the finishing touches on your database as you build a navigation form to make it easy for your users to find what they need.