Watch trailer
Course at a glance
| Release date | 8/1/2022 | |
| Level | Beginner | |
| Runtime | 3h 27m | |
| Closed captioning | Included | |
| Transcript | Included | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | N/A | |
| Exams | Included |
Course description
Microsoft Access is a database management system (DBMS) used to store and manage data allowing a user to create forms, query information and create reports. In this course you will learn to create tables, external tables, table relationships and how to work with them.
Prerequisites
Knowledge of data types, database structure and use of other Microsoft tools and interface ribbons is very useful, but not required.
Meet the expert
I’m Kari Hoien. I have a Bachelors degree in Business and Accounting from Concordia College in Moorhead, I was a CPA and went on to get my Masters in Education Technology from Pepperdine in Malibu, California. I have been working as a trainer and consultant for Microsoft Office products for more than 20 years and I’ve helped clients in almost every industry in a wide range of different capacities and applications. I have taught thousands of people how to use Microsoft Office apps (Excel, Access, Outlook, PowerPoint etc). I have done stand-up classroom style training, virtual training, on-demand training, self-paced training, executive training, one-on-one training – you name it – I've probably done it. I LOVE teaching people how to use these everyday programs better, ways to save time so you can work SMARTER and have more time for the things that you love. Thanks so much for allowing me to help you learn.
Course outline
Module 2
Creating Tables (56:02)
- Introduction (00:25)
- Access Tables (01:39)
- Demo: Creating Tables (01:24)
- Creating Tables on the Fly (03:19)
- Design View (00:41)
- DataSheet vs Design View (06:46)
- Field Properties and Data Types (02:21)
- Short Text (06:32)
- Long Test Field (01:24)
- Number Field (02:34)
- Help (05:22)
- Input Mask (00:42)
- Large Number (00:42)
- Date Time (02:11)
- Date Time Extended (00:27)
- Currency (01:10)
- Binary Field (01:02)
- OLE Object (00:45)
- Hyperlink (00:50)
- Attaachment (00:28)
- Calculated (02:04)
- lookup Wizard (02:33)
- DataSheet View (07:45)
- Primary Key (01:34)
- Table Views (00:55)
- Summary (00:15)
External Tables (49:51)
- Introduction (00:16)
- External Tables (00:48)
- External Tables (00:03)
- Import and Link Tables (01:17)
- Import and Link Group (02:02)
- Link Table Manager (00:38)
- Importing and Linking Access Tables (02:05)
- Linking (03:29)
- Link Differences (02:37)
- Import and Link Excel Tables (01:16)
- Import from Excel (06:07)
- Linking table (04:18)
- Connect SharePoint Tables (03:51)
- Link Sharepoint List (07:39)
- Other Data Sources (02:10)
- Exporting Tables (06:38)
- Export Text File (02:35)
- Email (01:34)
- Summary (00:20)
Module 3
Working with Tables (49:26)
- Introduction (00:11)
- Working with Tables (01:15)
- Navigationg Tables (03:15)
- Contextual Tabs (00:51)
- Find (02:07)
- Goto (00:50)
- Sorting and Filtering in Tables (08:50)
- Filter HomeTab (02:14)
- Advanced Filter (03:23)
- Dates and Values (05:21)
- Selection Filter (05:07)
- Adding Records in Datasheet (07:34)
- Undo and Redo (02:51)
- Data Entry Shortcuts (05:18)
- Summary (00:10)
Relationships between Tables (51:44)
- Introduction (00:08)
- Table Relationships (01:52)
- Relationship Types (02:30)
- Relationship Types Demo (16:00)
- Join Types (05:23)
- Demo: Referential Integrity (02:33)
- Cascade Relationship Settings (03:39)
- Lookup Wizard (06:49)
- Sub Datasheets (06:16)
- Relationship Best Practices (06:10)
- Summary (00:20)