Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Increase your knowledge of Microsoft Access. In this online course you will learn how to take your database management to a deeper level through interactive tutorials and simulation-based exercises. Work with queries, forms, and reports. You will also learn how to create relationship databases and explore advanced topics like mail merge.
Key Takeaways
By the end of the course, you will be able to:
- Build Relational Databases: table relationships and relationship types, create relationships between tables, print and delete relationships, and enforce referential integrity.
- Create and Work with Queries: hide, remove and sort fields; use AND and OR operators in a query; multiple table query; create a calculated field; work with expressions; format fields within queries; use an IIF function; summarize groups of records; apply parameter queries; find duplicate and unmatched records; and delete and append queries.
- Work with Forms: form wizard; modify a form; change the tab order; work with control and form properties; change a control data source; create a calculated control and change a control default value; create and modify subforms and navigation form.
- Create a Report: report wizard; use the label wizard; use copy formatting; change text alignment; insert a logo and background image; adjust page margin and orientation; and group, sort, and summarize data using totals.
- Apply Advanced Topics: conditional and number formatting, themes, importing and exporting information, link to external information, mail merge to Microsoft Word, the hyperlink field.
- Use Database Objects and Dependencies: compact and repair a database, convert an access database, backup and restore a database, split a database and password protect a database.
Who Will Benefit
Business professionals with a working knowledge of Microsoft Access who are responsible for managing database applications.
Disclaimer
Most of CPA Ontario's 450+ on-demand courses are compatible with the mobile app. Unfortunately, this on demand course is not compatible. For the best learning experience, we suggest you use your computer.
How to Access the Course
This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.
However, you will only have access to the course for 90 days after REGISTRATION.
To access the course please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal. Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
This online, interactive training course is presented by CustomGuide, North America’s trusted provider of simulation-based learning for Microsoft products.