9
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
€45.04
List Price:  €91
You save:  €45.96
£38.34
List Price:  £77.46
You save:  £39.12
CA$66.77
List Price:  CA$134.91
You save:  CA$68.14
A$73.55
List Price:  A$148.60
You save:  A$75.05
S$66.04
List Price:  S$133.43
You save:  S$67.39
HK$382.72
List Price:  HK$773.26
You save:  HK$390.53
CHF 44.62
List Price:  CHF 90.16
You save:  CHF 45.53
NOK kr513.67
List Price:  NOK kr1,037.83
You save:  NOK kr524.15
DKK kr336.09
List Price:  DKK kr679.05
You save:  DKK kr342.95
NZ$79.55
List Price:  NZ$160.73
You save:  NZ$81.17
د.إ179.97
List Price:  د.إ363.62
You save:  د.إ183.64
৳5,748.89
List Price:  ৳11,615.11
You save:  ৳5,866.21
₹4,076.08
List Price:  ₹8,235.36
You save:  ₹4,159.27
RM229.99
List Price:  RM464.68
You save:  RM234.69
₦72,640.54
List Price:  ₦146,763.54
You save:  ₦74,123
₨13,634.25
List Price:  ₨27,546.75
You save:  ₨13,912.50
฿1,795.13
List Price:  ฿3,626.91
You save:  ฿1,831.77
₺1,576.87
List Price:  ₺3,185.92
You save:  ₺1,609.05
B$253.50
List Price:  B$512.18
You save:  B$258.68
R900.84
List Price:  R1,820.07
You save:  R919.23
Лв88.09
List Price:  Лв177.99
You save:  Лв89.89
₩66,582.42
List Price:  ₩134,523.67
You save:  ₩67,941.24
₪180.14
List Price:  ₪363.97
You save:  ₪183.82
₱2,841.48
List Price:  ₱5,740.96
You save:  ₱2,899.47
¥7,686.44
List Price:  ¥15,529.75
You save:  ¥7,843.30
MX$817.40
List Price:  MX$1,651.48
You save:  MX$834.08
QR178.59
List Price:  QR360.83
You save:  QR182.24
P665.19
List Price:  P1,343.97
You save:  P678.77
KSh6,492.50
List Price:  KSh13,117.50
You save:  KSh6,625
E£2,327.99
List Price:  E£4,703.49
You save:  E£2,375.50
ብር2,793.99
List Price:  ብር5,645.01
You save:  ብር2,851.01
Kz41,740.16
List Price:  Kz84,332.16
You save:  Kz42,592
CLP$44,180.13
List Price:  CLP$89,261.90
You save:  CLP$45,081.77
CN¥348.35
List Price:  CN¥703.82
You save:  CN¥355.46
RD$2,885.11
List Price:  RD$5,829.10
You save:  RD$2,943.99
DA6,591.75
List Price:  DA13,318.04
You save:  DA6,726.28
FJ$109.18
List Price:  FJ$220.59
You save:  FJ$111.41
Q380.55
List Price:  Q768.87
You save:  Q388.32
GY$10,255.28
List Price:  GY$20,719.86
You save:  GY$10,464.57
ISK kr6,734.56
List Price:  ISK kr13,606.56
You save:  ISK kr6,872
DH486.47
List Price:  DH982.88
You save:  DH496.40
L867.79
List Price:  L1,753.30
You save:  L885.50
ден2,775.24
List Price:  ден5,607.12
You save:  ден2,831.88
MOP$394.04
List Price:  MOP$796.13
You save:  MOP$402.08
N$899.84
List Price:  N$1,818.06
You save:  N$918.21
C$1,803.25
List Price:  C$3,643.31
You save:  C$1,840.05
रु6,512.76
List Price:  रु13,158.44
You save:  रु6,645.68
S/183.39
List Price:  S/370.52
You save:  S/187.13
K190.50
List Price:  K384.90
You save:  K194.39
SAR183.77
List Price:  SAR371.30
You save:  SAR187.52
ZK1,311.74
List Price:  ZK2,650.26
You save:  ZK1,338.51
L224.12
List Price:  L452.82
You save:  L228.70
Kč1,110.58
List Price:  Kč2,243.84
You save:  Kč1,133.25
Ft17,280.30
List Price:  Ft34,913.27
You save:  Ft17,632.96
SEK kr516.27
List Price:  SEK kr1,043.08
You save:  SEK kr526.81
ARS$43,781.50
List Price:  ARS$88,456.50
You save:  ARS$44,675
Bs338.52
List Price:  Bs683.94
You save:  Bs345.42
COP$189,589.20
List Price:  COP$383,047.57
You save:  COP$193,458.36
₡25,193.42
List Price:  ₡50,900.99
You save:  ₡25,707.57
L1,210.64
List Price:  L2,446
You save:  L1,235.35
₲368,553.88
List Price:  ₲744,629.28
You save:  ₲376,075.39
$U1,886.38
List Price:  $U3,811.27
You save:  $U1,924.88
zł191.54
List Price:  zł387
You save:  zł195.45

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
9
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.