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.

Learning Objectives:

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 forms
    • 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.