The Microsoft Access 2019/Office 365 Series provides a comprehensive overview of Access 2019. You will first learn the basic functions of Access and then learn more advanced techniques that fully utilize the powerful software.
To sign up for this course: https://www.ed2go.com/ulm/
The introductory course will teach you fundamental data management techniques, like creating forms and tables, efficent data entry, and editing. You will also learn how to Access to develop queries that locate and isolate records and to design professional reports. By the time you have finished the course, you will know how to organize and assemble an effective database for any kind of information you need to store, document, and manage.
The Intermediate course builds on your prveous Access skills. You will start by importing customer and oders information form several Excel spreadsheets an tables in a new database. Once you have mastered proper table construction, you will learn how to create forms to manage table data. Then, you will discover how to construct crosstab and summary queries, and crunch numbers using query calculations. Finally, you will build a navigation form, so users can search your database.
