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.

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.