Wrangle your data by leveraging the power of Microsoft Access 2019. Learn how to use Access to build databases that help you store and retrieve your data more efficiently.
- [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.
Author
Adam Wilbert
Released
9/24/2018- Determine the essential uses for the Trust Center.
- Explore the functions of the database Navigation pane.
- Recognize the fundamentals of entering data when using Access.
- Identify the necessary steps when importing a table when using Access.
- Break down the fundamentals of filtering and sorting table data in Access.
- Identify the method utilized when building queries in Design view.
- Determine the role of forms in Access.
- Examine all of the elements involved in maintaining a database in Access.
- Explore how to properly protect an Access database with a password.
Skill Level Beginner
Duration
Views
-
Introduction
-
1. Getting Started
-
Database concepts4m 27s
-
Create the database file3m 53s
-
Understand the Trust Center3m 29s
-
Digging into Ribbon tabs5m 3s
-
The database Navigation pane3m 22s
-
-
2. Creating Tables
-
Enter data3m 44s
-
Primary and foreign keys4m 47s
-
Importing tables4m 29s
-
3. Setting Field Properties
-
Control input with masks4m 37s
-
Set a default value2m 42s
-
Data validation rules4m 53s
-
Data lookup fields3m 58s
-
Additional field properties4m 40s
-
4. Organizing Records
-
Sorting table data3m 7s
-
Filtering table data2m 27s
-
Deleting records1m 32s
-
-
5. Using Queries
-
What are queries?3m 19s
-
The Simple Query Wizard4m 22s
-
Build expressions5m 21s
-
Obtain summary statistics7m 23s
-
-
6. Creating Forms
-
Generate forms from tables5m 16s
-
Using the Form Wizard3m 50s
-
Form Design view4m 38s
-
Find records4m 33s
-
7. Creating Reports
-
Introducing reports3m 27s
-
The Report Wizard4m 37s
-
Edit a report in Layout view5m 11s
-
Group and sort records5m 35s
-
Creating calculated totals2m 59s
-
Create labels3m 31s
-
Adjust print settings3m 38s
-
-
8. Maintaining the Database
-
Set startup options3m 18s
-
Conclusion
-
Next steps55s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Building databases with Access