Access Complete (up to 15 Hours):
Recommended Prerequisite: Computer Basics
This course introduces Access and discusses structure for good database design. Learn how to create databases using wizards, construct tables and enter data, importing, sorting, and deleting data, establishing relationships, enforcing referential integrity, and printing relationships. Understand data types, primary keys, and table design. Create a form, enter data in a form, work with form controls and filter and sort data. Generate single and multi-table queries and use the query wizard. Learn how to modify tables in design view, add captions, adjust data types, use default values, and change field properties in tables. Learn to import and export data, use the lookup wizard, input mask wizard, and office clipboard. Generate queries using criteria, multi-table queries, calculated fields, and action queries. Work with forms, explore form sections, bind controls and data, and work with calculated and other types of controls. Work with headers and footers, bound controls, unbound controls, and calculated controls on reports. Learn to conditional formatting, input masks, and lookup fields. Building forms, form properties, control properties, and create subform controls. Learn report properties, and how to group and sort report data. Set database passwords and compact and repair.