Главная
Study mode:
on
1
Start
2
Introduction
3
Showing File Name Extensions
4
Opening Query.mdb
5
Updating File Formats and Showing Document Tabs
6
Hiding Table Fields
7
Unhiding Table Fields
8
Creating and Running Queries
9
Sorting the Query
10
More Ways to Select Views
11
Filtering Using OR
12
Filtering Using AND
13
Combining AND with OR
14
Filtering Using NOT and NULL
15
Multi-Table Queries
16
Wild Card Symbols
17
Calculations
18
Concatenating Words
19
Parameter Queries
20
Introduction
21
Multiplying and Aggregating
22
Subtotals via a Totals-Query
23
Crosstab-Query
24
Make-Table Query
25
Delete-Query
26
Update-Query
27
Append-Query
28
Exporting to PDF
29
Exporting to Word-RTF
30
Exporting to Excel
31
Importing from Excel
32
Linking to Excel
33
Linking from Access to Access
34
Lookup List in a Query
Description:
Dive into an advanced 5-hour tutorial on Microsoft Access, designed for users familiar with spreadsheet programs who need more powerful data analysis and management tools. Learn to create and manage robust databases for small to medium-sized businesses. Begin with database fundamentals before progressing to building tables, establishing relationships, querying data, and designing user-friendly interfaces. Master advanced techniques such as multi-table queries, wild card symbols, parameter queries, and various query types including crosstab, make-table, delete, update, and append. Explore data export and import functionalities with PDF, Word, and Excel, as well as linking between Access databases. Gain practical skills through hands-on exercises and comprehensive examples, equipping you to efficiently design and manage databases for your organization.

Access Advanced Tutorial

Learnit Training
Add to list
0:00 / 0:00