Access 2019 Essential Training

  • Course details

    Learn how to wrangle your data and gain deeper insights by leveraging the power of Microsoft Access 2019. In this course, Access expert Adam Wilbert shows how to use Access to build databases that help you store and retrieve your data more efficiently. Adam begins by going over the concepts behind relational databases. He then discusses how to build tables—the foundation of any database—as well as how to define the relationships between tables and use queries to find and filter data. He also steps through how to build an interface for the database from forms, complete with combo boxes; create reports for printing and sharing; and take steps to maintain your database.

    Instructor

    • Click here to view Adam Wilbert’s instructor page

      Adam Wilbert

      LinkedIn Learning Instructor and Lynda.com Author

      Adam Wilbert is a data visualization expert who helps clients get better insights from their data.

      As a consultant and trainer, Adam has spent over 5 years helping government, enterprise, and nonprofit clients use Access and Excel efficiently. Adam has developed Access databases for National Park Service managers and U.S. Geological Survey scientists, in addition to leading Access and Excel workshops throughout the United States through a partnership with Northwest Environmental Training Center. His in-depth multi-day training events benefit private firms such as Boeing and Verizon, NGOs, and government employees in agencies such as the Environmental Protection Agency, Bureau of Land Management, and the Army Corps of Engineers.

      As the founder of CartoGaia, a cartography firm, Adam produces publication quality mapping products to explore awareness in the spatial arrangement of data in order to help guide policy and decision makers in a wide variety of environmental and business applications. He was chosen as a featured contributor to the inaugural edition of the North American Cartographic Information Society's Atlas of Design. You can connect with Adam on Twitter @awilbert or at adamwilbert.com.

    Skills covered in this course

  • Building databases with Access

    - [Adam] Do you find yourself in a sea of spreadsheets, unable to quickly find the actionable information that you need in the pile of data that you collect? Or maybe you're just setting up a business and wanna make sure that you keep your data collection activities organized right from the start. Now is a great time to start thinking about databases and the easiest way to get started is with Microsoft Access. Access provides all of the tools that you'll need to organization your data, quickly retrieve pertinent information and prepare reports that are easy to read and always up to date. It'll help you pull out relevant information and help clarify insights that are already hiding in your data. Hi, I'm Adam Wilbert and I've been introducing people to Access for over a decade. I invite you to take my LinkedIn Learning course Access 2019 Essential Training so that you too can start harnessing the power of databases for yourself.

  • Practice while you learn with exercise files

    Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.

    Download the exercise files for this course. Get started with a free trial today.

  • Download courses and learn on the go

    Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

    Watch this course anytime, anywhere. Get started with a free trial today.

Contents