Главная
Study mode:
on
1
Start
2
Database Basics
3
Introduction to Database Objects and the Access Interface
4
Accessing the Northwind Template
5
Exploring the Login and Homes Forms
6
Navigation Pane Default View and Datasheet and Design Views for Tables
7
Exploring Datasheet View, Design View, and SQL View for Query Objects
8
Exploring Form View, Layout View, and Design View for Form Objects
9
Exploring Report View, Layout View, Design View, and Print Preview for Report Objects
10
Running Macros and Exploring Design View
11
Examining VBA Code
12
Access Ribbon and Status Bar
13
Exploring the Relationships Window and Closing the Database
14
Introduction to Creating New Databases
15
Creating Blank Databases
16
Switching Default Table to Design View and Renaming the Primary Key Field
17
Adding Remaining Fields to the Customers Table
18
Field Descriptions, Format and Text Limit, and Input Mask
19
Using the Caption Field Property
20
Creating New Tables in Design View
21
Introduction to Entering Data into Tables
22
Manually Entering Table Data
23
Importing from Excel - Appending to Existing Table - Employees
24
Importing from Excel - Appending with Different Data Types Error - Customers
25
Importing from Excel - Adding Data into A New Table - Categories
26
Importing from Excel - Adding Data into New Tables
27
Reviewing Data Types and Field Properties for Imported Tables - Products
28
Reviewing Data Types and Field Properties for Imported Tables - Orders
29
Order Details Table - Discussing Composite Key Fields
30
Setting a Composite Key - Order Details
31
Sorting Table Data
32
Inclusive Filtering, Exclusive Filtering, and Filtering by Form
33
Introduction to Relationships
34
Adding Tables to the Relationships Window and Organizing Them
35
Common Fields Between Tables
36
Creating a One-To-Many Relationship Between Customers and Employees Tables
37
Creating Relationship Errors
38
Resolving Data Type Errors and Repopulating Table Fields
39
Manually Repopulating Table Fields
40
Creating Lookup Fields in a Table
41
Changing the Field Size of a Numeric Data Type to Resolve a Relationship Error
42
Resolving a Data Type Error and Repopulating Table Fields
43
Creating a Lookup Field in Another Table and Highlighting the Many-to-Many Relationship
44
Database Basics Recap
45
Conclusion
Description:
Embark on a comprehensive 2-hour 16-minute tutorial designed for beginners and experienced users alike to master Microsoft Access 2021. Navigate through a completed database while exploring relational database concepts and objects. Familiarize yourself with the Access interface before diving into planning, designing, and creating database tables. Learn to import data from Excel, manually enter table data, and apply sorting and filtering techniques. Explore table relationships, the cornerstone of successful relational databases, and create queries, forms, and reports. Discover how table relationships affect queries, automate them, and create action queries. Advance your skills with report and form design techniques, create switchboards, write macros, and utilize Access Visual Basic for Applications (VBA) for complex automation. Conclude by covering database security and customization options. Access exercise files, ad-free training, exams, certificates, and exclusive content through the provided links. Read more

Access Beginner Tutorial

Learnit Training
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Access #Programming #Databases #Database Design #Computer Science #Database Management #Data Science #Data Analysis #Spreadsheets #Macros #Information Technology #Data Management #Data Organization
0:00 / 0:00
1 of 45

Start