00:00
00:00
13
views
Share the link to this page
Copied

About the Class

Microsoft Access is the database management system that is included with the Microsoft Office Suite or Office 365. It is a program that helps you manage a large amount of data even better than Microsoft Excel can. Many people don’t know how to use Access, and may even be afraid of it. This webinar will really show you the ins and outs of using Microsoft Access Tables and Queries. Even though Excel gives you some great ways to handle your data, with Access you will be able to handle large amounts of data. If you handle large amounts of data, this webinar will help you tremendously.

What will you learn in this course?

  • Tour of the Access screen
  • Using the Design view to create a table
  • The Lookup Wizard
  • Importing tables from other data sources
  • Linking tables to other data sources
  • Exporting data from Access into other data types
  • Creating table relationships
  • Database tools
  • Sorting and Filtering a table
  • Basic queries
  • Prompting the user for the criteria
  • Calculated field queries
  • Totals query
  • Using Multiple tables in a query
  • Viewing the SQL code
  • Query wizards
  • Subqueries
  • Append, Make Table, Update, and Delete queries
  • Showing a certain number of records in a query

Author

Tom Fragale - Microsoft Certified Trainer

Tom Fragale - Microsoft Certified Trainer - PCWebinars.com
Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel., and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. He has trained over 30,000 business people in on-line...

School

Tom Fragale - Microsoft Certified Trainer's School

Requirements

There are no additional requirements.
One-time Fee
$49
List Price:  $99
You save:  $50
€41.75
List Price:  €84.36
You save:  €42.60
£36.39
List Price:  £73.53
You save:  £37.13
CA$67.01
List Price:  CA$135.40
You save:  CA$68.38
A$74.66
List Price:  A$150.85
You save:  A$76.18
S$62.76
List Price:  S$126.81
You save:  S$64.04
HK$384.61
List Price:  HK$777.08
You save:  HK$392.46
CHF 39.04
List Price:  CHF 78.87
You save:  CHF 39.83
NOK kr497.62
List Price:  NOK kr1,005.39
You save:  NOK kr507.77
DKK kr311.67
List Price:  DKK kr629.71
You save:  DKK kr318.03
NZ$81.53
List Price:  NZ$164.73
You save:  NZ$83.19
د.إ179.97
List Price:  د.إ363.62
You save:  د.إ183.65
৳5,987.33
List Price:  ৳12,096.85
You save:  ৳6,109.52
₹4,239.18
List Price:  ₹8,564.87
You save:  ₹4,325.69
RM206.85
List Price:  RM417.92
You save:  RM211.07
₦74,880.33
List Price:  ₦151,288.83
You save:  ₦76,408.50
₨13,915.49
List Price:  ₨28,114.98
You save:  ₨14,199.48
฿1,586.39
List Price:  ฿3,205.17
You save:  ฿1,618.77
₺1,987.22
List Price:  ₺4,015.01
You save:  ₺2,027.78
B$270.63
List Price:  B$546.78
You save:  B$276.15
R869.18
List Price:  R1,756.11
You save:  R886.92
Лв81.66
List Price:  Лв165
You save:  Лв83.33
₩67,726.82
List Price:  ₩136,835.83
You save:  ₩69,109
₪164.67
List Price:  ₪332.71
You save:  ₪168.03
₱2,798.81
List Price:  ₱5,654.74
You save:  ₱2,855.93
¥7,245.77
List Price:  ¥14,639.42
You save:  ¥7,393.65
MX$910.03
List Price:  MX$1,838.64
You save:  MX$928.61
QR179.06
List Price:  QR361.79
You save:  QR182.72
P654.55
List Price:  P1,322.45
You save:  P667.90
KSh6,330.80
List Price:  KSh12,790.80
You save:  KSh6,460
E£2,403.79
List Price:  E£4,856.65
You save:  E£2,452.85
ብር6,755.36
List Price:  ብር13,648.59
You save:  ብር6,893.23
Kz44,685.79
List Price:  Kz90,283.54
You save:  Kz45,597.75
CLP$46,562.25
List Price:  CLP$94,074.75
You save:  CLP$47,512.50
CN¥351.20
List Price:  CN¥709.58
You save:  CN¥358.37
RD$2,971.81
List Price:  RD$6,004.28
You save:  RD$3,032.46
DA6,341.87
List Price:  DA12,813.16
You save:  DA6,471.29
FJ$109.89
List Price:  FJ$222.03
You save:  FJ$112.13
Q375.88
List Price:  Q759.43
You save:  Q383.55
GY$10,246.78
List Price:  GY$20,702.69
You save:  GY$10,455.90
ISK kr5,937.82
List Price:  ISK kr11,996.82
You save:  ISK kr6,059
DH439.88
List Price:  DH888.74
You save:  DH448.86
L824.22
List Price:  L1,665.27
You save:  L841.04
ден2,566.17
List Price:  ден5,184.72
You save:  ден2,618.54
MOP$396
List Price:  MOP$800.08
You save:  MOP$404.08
N$863.35
List Price:  N$1,744.32
You save:  N$880.97
C$1,802.50
List Price:  C$3,641.80
You save:  C$1,839.29
रु6,768.61
List Price:  रु13,675.35
You save:  रु6,906.74
S/174.15
List Price:  S/351.87
You save:  S/177.71
K205.97
List Price:  K416.14
You save:  K210.17
SAR183.82
List Price:  SAR371.39
You save:  SAR187.57
ZK1,142.32
List Price:  ZK2,307.95
You save:  ZK1,165.63
L211.74
List Price:  L427.81
You save:  L216.06
Kč1,024.66
List Price:  Kč2,070.24
You save:  Kč1,045.57
Ft16,561.07
List Price:  Ft33,460.13
You save:  Ft16,899.05
SEK kr467.04
List Price:  SEK kr943.62
You save:  SEK kr476.57
ARS$62,377.03
List Price:  ARS$126,027.07
You save:  ARS$63,650.04
Bs338.44
List Price:  Bs683.80
You save:  Bs345.35
COP$198,446.66
List Price:  COP$400,943.26
You save:  COP$202,496.59
₡24,724.17
List Price:  ₡49,952.92
You save:  ₡25,228.75
L1,282.48
List Price:  L2,591.13
You save:  L1,308.65
₲366,834.78
List Price:  ₲741,155.99
You save:  ₲374,321.21
$U1,962.65
List Price:  $U3,965.36
You save:  $U2,002.71
zł177.69
List Price:  zł359.02
You save:  zł181.32

What's Included

Language: English
Level: Beginner
Skills: Tables, SQL Code, Database, Queries, Relational Database, Microsoft Access, Microsoft
Age groups: All ages
Duration: 3 hours 34 minutes
3 Videos
0
Saves
13
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.