As the most widely-used desktop database management programs, knowing how to use Microsoft Access adds a valuable skill to your professional profile. The Microsoft Access 2019 Series will teach beginners how to use Access to efficiently build, customize, and manage databases and bring their skills to an intermediate level.
Virtually every industry benefits from information management and Microsoft Access is one of the most widely used programs used for this task. Data ranging from inventory to customer information can be effectively organized with this longstanding software. If you work with databases of any kind, learning the ins and outs of Access 2019 will allow you to take a stronger role in database management.
This course bundle will teach how to use Access to organize, store, and document essential information. The Introduction course focuses on fundamentals, so you can plan and develop a well-organized database. The Intermediate Access 2019 course will teach you advanced techniques as you build an entire database project from scratch. You will learn how to import Excel spreadsheets as tables, create query calculations to crunch numbers, and use Visual Basic to automate common tasks.
From initial database creation to using conditional formatting, by the time you complete this course bundle, you will be well-versed in how to best manage and present your data with Access 2019.
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 this powerful software.
The Introductory course will teach you fundamental data management techniques, like creating forms and tables, efficient data entry, and editing. You will also learn how to use 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 previous Access skills. You will start by importing customer and order information from several Excel spreadsheets as 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.
Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Just go to www.ed2go.com/kirkwood to register.