MICROSOFT ACCESS DATABASE TRAINING HOW TO

Lesson Eight РІР‚вЂњ Including: exporting an html document, understanding object dependencies, importing and exporting a spreadsheet, importing a text file, using the analyze table function, using the analyze performance function, using the database documenter

Lesson Seven РІР‚вЂњ Including: adding a field with data validation in a table, creating a form with subform, entering data using a form/subform combination, creating a split form, creating and modifying the design of a report, using the concatenate expression, adding a subreport to an existing report Lesson Six РІР‚вЂњ Including: using query wizard, setting sort criteria, using expressions to set criteria, creating different types of queries, creating and naming a calculated field in a query using aggregate functions Lesson Five РІР‚вЂњ Including: Using advanced sort, using filters, importing a table from an external database using a junction table to resolve a many to many relationship, defining a composite (primary) key, using a calculated control on a form, creating a multi-value field, creating an attachment field Lesson Four РІР‚вЂњ Including: editing data, adding records, printing preview, changing page orientation, enforcing referential integrity in a relationship, creating a relationship report, creating a form, working with controls in form design, using AutoFormat, modifying properties in a form Lesson Three РІР‚вЂњ Including: defining relationships, creating tables, formatting, modifying, using the input mask wizard, using templates, renaming an object Lesson Two РІР‚вЂњ Including: planning and design, relationships, defining fields, data types and properties, creating tables, entering data, re-sizing columns, using the lookup wizard Lesson One РІР‚вЂњ Including: terminology, working with existing databases, opening a table, query, form and report, entering new records, searching and sorting

The opportunity to gain the widely recognised Pitman Training Certificate The lesson plan content for this Access course is detailed below:.

A reference guide to use and refer to on completion of the course.

The flexibility and value of a self-study course designed to enable you to work at your own pace.

MICROSOFT ACCESS DATABASE TRAINING HOW TO

Learn how to use this popular database program.

In this detailed and varied training programme youРІР‚в„ўll be guided through many aspects of Access including database terminology planning and design defining relationships and creating a table editing data using advanced tools using the query wizard adding a field exporting an html document adding charts to forms and creating macros. Microsoft Access is a highly worthwhile skill to have at your command as this very popular database application is widely used across many employment sectors.

Microsoft access database training