Главная
Study mode:
on
1
- Acquiring Access 2021
2
- What's New in Access 2021
3
- Exercise 01
4
- Use Database Templates
5
- Create, Save and Open Databases
6
- Expose the Access Interface and Backstage
7
- Customize the Quick Access Toolbar
8
- Access Menus
9
- Keyboard Shortcuts & Key Tips
10
- Online Help
11
- Access Options
12
- Exercise 02
13
- Create a Table and Fields
14
- Index Fields, Primary Keys and Add Records
15
- Use the Lookup Wizard to Create a Drop-down List
16
- Numeric and Data Validation Rules
17
- Add More Table Fields
18
- Exercise 03
19
- Importing Data from Excel
20
- Import Data from a Text File
21
- Exercise 04
22
- Design in the Datasheet View
23
- Sort and Filter in Datasheet View
24
- Enter and Modify Data in Datasheet View
25
- Exercise 05
26
- Relationships Explained
27
- Set Up Relationship
28
- Create a Link: Part 1
29
- Create a Link: Part 2
30
- Edit the Link Table
31
- Exercise 06
32
- Advanced Course Intro
33
- Setup for Success
34
- Primary Keys and Indexing
35
- More About Indexes
36
- Setup Northwind Database
37
- Work in Datasheet View
38
- Customize Datasheet View
39
- Advanced Sort and Filter
40
- Subdatasheets
41
- Exercise 01
42
- Link Tables to Other Access Database
43
- Install SQL Server Express
44
- Setup SQL Server Express
45
- Exercise 02
46
- Split an Access Database into Frontend and Backend
47
- Convert to Local Table
48
- Addressing Multi-user Issues When Sharing
49
- Exercise 03
50
- Basics of Macros
51
- Macros On-Events; AutoExec
52
- More About AutoExec
53
- Macro Security Settings
54
- Exercise 04
55
- Conclusion
Description:
Embark on a comprehensive 5+ hour tutorial course covering Microsoft Access 2021 from beginner to advanced levels. Learn to acquire and navigate Access 2021, utilize database templates, create and customize tables, implement data validation rules, and import data from various sources. Master datasheet view operations, understand database relationships, and set up links between tables. Explore advanced features like indexing, working with the Northwind Database, and addressing multi-user issues when sharing databases. Dive into macro basics, including AutoExec and security settings. Follow along with provided demo files and use timestamps to navigate specific topics, ensuring a thorough understanding of Microsoft Access 2021's capabilities for efficient database management and design.

Microsoft Access 2021 - Beginner to Advanced Tutorial Course

Simon Sez IT
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Access #Programming #Domain-Specific Languages (DSL) #SQL #Computer Science #Database Management #Data Science #Data Analysis #Spreadsheets #Macros #Information Technology #Data Management #Data Validation
0:00 / 0:00
1 of 55

- Acquiring Access 2021