New to databases? Get an overview of the Office 365 version of Access, including building tables, defining relationships, and creating queries and reports.
- [Voiceover] If you're curious how a database can help you organize your data, then learning how Access works is a fantastic first step. Hi, my name is Adam Wilbert, and I'd like to welcome you to Learn Access for Office 365. I'm going to walk you through your first steps working with Microsoft's venerable database program that comes with your Home, Personal, ProPlus, or enterprise E3 or E5 subscriptions to Microsoft Access 365. First, we'll get started with a grand tour through the Access interface, and take a look at how you can get going quickly by using one of the freshly updated starter templates.
Then we'll shift gears a little and start building a customized application that responds to the unique requirements of our own data. I'll show you how to create tables and choose data types, pull in some data from an Excel spreadsheet, and see how to start thinking about your data from a relational perspective. This course is designed for those with little to no experience with Microsoft Access. So, if you want to take a peek, and see what relational databases are all about, then this is a great course to start with. Let's get ready to start exploring Microsoft Access for Office 365.
If you need a deeper dive into the topics discussed, check out Adam's Office 365: Access 2016 Essential Training course.
- Loading a premade template database
- Exploring the interface
- Defining data types
- Creating tables
- Defining table relationships
- Editing forms
- Creating queries and reports
- Editing reports in Layout view