To get the most out of this course, you should have a basic understanding of the Windows operating system and how to work with files and launch applications. Though familiarity with other programs in the Microsoft Office suite will be helpful, no prior experience with databases is needed.
- [Instructor] To get the most out of this course, I only expect that you are familiar with the Windows operating system, working with files and launching applications. If you have some experience with other applications in the Microsoft Office Suite, specifically Excel, then that would be helpful but it's not required. Also no prior database knowledge will be needed as I'll be starting at the beginning and we'll work our way through everything that you need to know to get started in Access.
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: What you should know