Create reports and queries using databases to easily retrieve information and summarize important information. Learn the Visual Basic features of Microsoft Access to create robust forms and applications unlike what can be done in other programs. Organize your data so that it may be easily retrieved.
Create a database and:
- View data in a database and change the view by sorting and filtering the data
- Create queries to view a subset of data in the database
- Build auto lookup features and more advanced queries
- Create reports for summarizing results
Use Microsoft Access to create more powerful data retrieval by:
- Designing simple and relational database models
- Creating forms, queries and reports that use relational databases
Organize data by using tables and and forms.
This course will teach you how to: - Design data tables and forms
- Define forms for inputs
- Create forms that contain sub-forms
- Create queries that use multiple tables
Manage your database using Microsoft Access' switchboard. Explore switchboards and learn to:
A basic understanding of Access is needed to complete this class.