Elevate data. Create your own database apps easily in formats that serve your business best. Access is much more than a way to create desktop databases. It’s an easy-to-use tool for creating applications that help you run your business. Access data can be stored in a variety of cloud databases, so it’s more secure than ever, and you can share your Access applications with colleagues.
A relational database application such as Microsoft Office Access can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data. Full Course Outline / Schedule | $250.00
Your training and experience using Microsoft Access has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users. Full Course Outline / Schedule | $250.00
You've covered many of the basic functions of Microsof® Office Access, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Full Course Outline / Schedule | $250.00
When you create a new database, you typically begin by creating a few database objects such as tables, forms, and reports. Eventually, you reach a point where you need to add some programming to automate certain processes and tie your database objects together. In Access, programming is the process of adding functionality to your database by using Access macros or Visual Basic for Applications (VBA) code. For example, suppose you have created a form and a report, and you want to add a command button to the form that, when clicked, opens the report. Programming, in this case, is the process of creating a macro or VBA procedure and then setting the command button's OnClickevent property so that clicking the command button runs the macro or procedure. Full Course Outline / Schedule | $895