Chat with us, powered by LiveChat

Microsoft Access Intermediate

This course has been developed for Access users want to report on and manipulate data and improve their working knowledge of the product.

2 days course
4.55  (167 reviews)
What you will learn:
  • Import, link and export tables
  • Work with advanced table properties
  • Use advanced select queries and create crosstab queries and charts, as well as use action queries
  • Design forms and use subforms
  • Create simple macros
  • Design reports
What you'll get:
Workbook
Refreshments
Capped class sizes
eCertificate
Course prerequisites

Participants will need to be familiar with all of the topics covered in the Microsoft Access Introduction course.

Do I need to bring my own laptop?

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.

Topics covered in this training course
  • Introduction revision
  • Drag and drop import
  • Troubleshooting importing
  • Import a CSV file
  • Linking tables
  • Modify data in linked tables
  • Importing vs linked tables
  • Export data from Access
  • Export to Excel
  • Export to Access
  • Review basic field properties
  • Create a custom format
  • Custom date formats
  • Input mask property
  • Validation rules
  • Validation text property
  • Table properties
  • Modify lookup field properties
  • The relationships window
  • Set table relationships
  • Relationship types
  • Referential integrity
  • Cascade updates and deletes
  • Find null values
  • To exclude null values
  • NOT queries
  • Parameter queries
  • Parameter data types
  • Query multiple tables
  • Table joins
  • Find orphan (unmatched) records
  • Use expression builder
  • Convert nulls to zeros
  • Concatenation
  • StrConv function
  • Date functions
  • DateAdd()
  • DateDiff()
  • IIF() function
  • Aggregate queries
  • Format query field properties
  • Format the query headings
  • Top values query
  • Form design view
  • Breaking form layouts
  • Selecting form controls
  • Form properties
  • Form control properties
  • Create an unbound control
  • Add a calculation
  • Add a drop-down control
  • Change combo box properties
  • Add a button
  • Change tab order
  • Align controls
  • Resize controls
  • Evenly spacing controls
  • Add a logo to a form
  • Link a query to a form
  • Create a crosstab query using the wizard
  • Modify a crosstab query
  • Create a crosstab query manually
  • Make table query
  • Delete query
  • Update query
  • Append query
  • Create a subform from control wizard
  • Modify the subform
  • Datasheet view
  • Subform properties
  • Continuous forms view
  • Calculations on a subform
  • Report design view
  • Add a logo to a report
  • Add calculations to reports
  • Concatenation
  • Add calculations to a footer
  • Sum calculated fields
  • Advanced report properties
  • Show and hide report sections
  • Add page breaks
    Reset options
- +

Need your training approved? Get a quote

Need your training approved? Get a quote
4.55
4.55
from 167 reviews
5/5
“Great structure, just the right detail. Overall happy. Thank you Annie!”
Annika, May 2019
5/5
“Very knowledgeable instructor. Very enthusiastic and engaging.”
Oliver, May 2019
5/5
“Annie was lovely and very knowledgeable. ”
Kelly, May 2019
5/5
“The trainer Katherine was excellent and was able to teach additional knowledge based on questions of the class that was not covered in the structure.”
Joey, May 2019