00:00
00:00
12
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.63
List Price:  €84.12
You save:  €42.48
£35.75
List Price:  £72.24
You save:  £36.48
CA$66.86
List Price:  CA$135.09
You save:  CA$68.22
A$74.64
List Price:  A$150.80
You save:  A$76.16
S$62.40
List Price:  S$126.08
You save:  S$63.68
HK$384.64
List Price:  HK$777.13
You save:  HK$392.49
CHF 38.83
List Price:  CHF 78.45
You save:  CHF 39.62
NOK kr494.44
List Price:  NOK kr998.98
You save:  NOK kr504.53
DKK kr310.67
List Price:  DKK kr627.69
You save:  DKK kr317.01
NZ$80.68
List Price:  NZ$163.02
You save:  NZ$82.33
د.إ179.97
List Price:  د.إ363.62
You save:  د.إ183.64
৳6,015.47
List Price:  ৳12,153.71
You save:  ৳6,138.23
₹4,197.85
List Price:  ₹8,481.37
You save:  ₹4,283.52
RM207.22
List Price:  RM418.67
You save:  RM211.45
₦75,190.99
List Price:  ₦151,916.49
You save:  ₦76,725.50
₨13,907.89
List Price:  ₨28,099.62
You save:  ₨14,191.73
฿1,588.72
List Price:  ฿3,209.87
You save:  ฿1,621.15
₺1,950.03
List Price:  ₺3,939.86
You save:  ₺1,989.83
B$268.63
List Price:  B$542.74
You save:  B$274.11
R865.42
List Price:  R1,748.50
You save:  R883.08
Лв81.40
List Price:  Лв164.47
You save:  Лв83.07
₩66,596.07
List Price:  ₩134,551.25
You save:  ₩67,955.17
₪165.20
List Price:  ₪333.77
You save:  ₪168.57
₱2,762.37
List Price:  ₱5,581.12
You save:  ₱2,818.75
¥7,052.22
List Price:  ¥14,248.36
You save:  ¥7,196.14
MX$917.96
List Price:  MX$1,854.66
You save:  MX$936.69
QR178.21
List Price:  QR360.07
You save:  QR181.85
P648.34
List Price:  P1,309.92
You save:  P661.57
KSh6,330.80
List Price:  KSh12,790.80
You save:  KSh6,460
E£2,416.09
List Price:  E£4,881.50
You save:  E£2,465.40
ብር6,753.63
List Price:  ብር13,645.10
You save:  ብር6,891.46
Kz44,850.59
List Price:  Kz90,616.51
You save:  Kz45,765.91
CLP$45,502.87
List Price:  CLP$91,934.37
You save:  CLP$46,431.50
CN¥351.26
List Price:  CN¥709.70
You save:  CN¥358.43
RD$2,914.34
List Price:  RD$5,888.16
You save:  RD$2,973.81
DA6,359.48
List Price:  DA12,848.75
You save:  DA6,489.26
FJ$109.57
List Price:  FJ$221.38
You save:  FJ$111.81
Q376.92
List Price:  Q761.54
You save:  Q384.61
GY$10,250.69
List Price:  GY$20,710.59
You save:  GY$10,459.89
ISK kr5,954.48
List Price:  ISK kr12,030.48
You save:  ISK kr6,076
DH439.91
List Price:  DH888.80
You save:  DH448.89
L823.46
List Price:  L1,663.73
You save:  L840.27
ден2,560.28
List Price:  ден5,172.82
You save:  ден2,612.53
MOP$396.32
List Price:  MOP$800.73
You save:  MOP$404.41
N$861.71
List Price:  N$1,741.01
You save:  N$879.30
C$1,803.87
List Price:  C$3,644.57
You save:  C$1,840.69
रु6,703.52
List Price:  रु13,543.86
You save:  रु6,840.33
S/173.63
List Price:  S/350.81
You save:  S/177.18
K202.13
List Price:  K408.39
You save:  K206.25
SAR183.75
List Price:  SAR371.26
You save:  SAR187.50
ZK1,170.21
List Price:  ZK2,364.30
You save:  ZK1,194.09
L210.94
List Price:  L426.20
You save:  L215.25
Kč1,026.06
List Price:  Kč2,073.06
You save:  Kč1,047
Ft16,604.14
List Price:  Ft33,547.14
You save:  Ft16,943
SEK kr466.25
List Price:  SEK kr942.02
You save:  SEK kr475.76
ARS$59,094
List Price:  ARS$119,394
You save:  ARS$60,300
Bs338.70
List Price:  Bs684.31
You save:  Bs345.61
COP$201,667.60
List Price:  COP$407,450.87
You save:  COP$205,783.27
₡24,740.57
List Price:  ₡49,986.06
You save:  ₡25,245.48
L1,280.93
List Price:  L2,588
You save:  L1,307.07
₲390,982.04
List Price:  ₲789,943.31
You save:  ₲398,961.27
$U1,958.28
List Price:  $U3,956.52
You save:  $U1,998.24
zł177.05
List Price:  zł357.73
You save:  zł180.67

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