- Use the Lookup Wizard to Create a Drop-down List
17
- NUmeric and Data validation Rules
18
- Add More Table Fields
19
- Exercise 03
20
- Importing Data from Excel
21
- Import Data from a Text File
22
- Exercise 04
23
- Design in the Datasheet View
24
- Sort and Filter in Datasheet View
25
- Enter and Modify Data in Datasheet View
26
- Exercise 05
27
- Relationships Explained
28
- Set Up Relationship
29
- Create a Link: Part 1
30
- Create a Link: Part 2
31
- Edit the Link Table
32
- Exercise 06
Description:
Learn the fundamentals of Microsoft Access 2021 in this comprehensive 3-hour beginner course. Explore database management essentials, including creating and saving databases, customizing the interface, and mastering keyboard shortcuts. Dive into table creation, field indexing, and data validation. Practice importing data from Excel and text files, designing in Datasheet View, and setting up relationships between tables. Follow along with downloadable exercise files to reinforce your learning and gain hands-on experience with Access 2021's latest features for efficient small to large database management.
Microsoft Access 2021 Beginner Course - Database Management Training