Microsoft Access Master Class

Learn about the intermediate and advanced Microsoft access.

Microsoft Access Master Class

Learn about the intermediate and advanced Microsoft access.
17
views
Share the link to this page
Copied

About the Class

This course is the follow-on course from the Introduction to Microsoft Access. The course covers how to put a database together and interrogate the data through queries, forms, and reports. The course explains how to carry out a detailed analysis of the data set used. At the end of the course, you should be able to create a relational database with a macro-driven front end including command buttons set to navigate and manage your database.

What will you learn in this course?

  • Update queries
  • Append queries
  • Make table queries
  • Delete queries
  • Calculations in queries
  • Sub Totals in queries
  • Parameter queries
  • Form calculations
  • Form tab controls
  • Form option groups
  • Form images
  • Forms and subforms
  • Report calculations
  • Report concatenation
  • Basic functions, IIF, Average, Sum, Count, Max
  • Basic command buttons
  • Macros, Autoexec, Auto keys, IF, send to and more
  • Navigation options
  • Event properties, macro attached to properties
  • Splitting a database and properties

Author

Stephen Saxton

IT Trainer and Author
I have been delivering IT training sessions in the UK for over twenty two years. In that time, I have developed many courses both online and classroom based. My main focus is the Microsoft suite of programs, Office, Office 365, Microsoft Project, and Visio.

School

Stephen Saxton's School

Requirements

You should have completed the Introduction to Microsoft Access course or have user experience before attempting this course.

One-time Fee
$250
€230.48
£196.14
CA$341.61
A$376.70
S$337.45
HK$1,952.96
CHF 228.34
NOK kr2,630.10
DKK kr1,719.52
NZ$407.65
د.إ918.24
৳29,411.62
₹20,841.35
RM1,175.87
₦356,865
₨69,749.53
฿9,190.06
₺8,059.92
B$1,290.17
R4,568.77
Лв450.68
₩341,635.27
₪923.25
₱14,621.24
¥39,308.46
MX$4,187.62
QR914.40
P3,402.86
KSh33,000
E£11,825.16
ብር14,400.91
Kz213,236.66
CLP$224,095
CN¥1,778.08
RD$14,770.32
DA33,646.52
FJ$564.73
Q1,946.46
GY$52,464.48
ISK kr34,320
DH2,490.17
L4,421.27
ден14,192.66
MOP$2,015.31
N$4,608.21
C$9,224.82
रु33,356.83
S/939.48
K974.55
SAR937.67
ZK6,748.25
L1,146.87
Kč5,693.74
Ft89,088.13
SEK kr2,652.43
ARS$223,374
Bs1,731.33
COP$970,332.42
₡128,880.33
L6,193.35
₲1,887,179.74
$U9,641.09
zł980.95

What's Included

Language: English
Level: Advanced
Skills: MS Access, Database, Update Queries, Report Calculations, Microsoft Access, Microsoft, Report Concatenation
Age groups: All ages
Duration: 2 hours 21 minutes
15 Videos
20 Documents
0
Saves
17
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.