Microsoft Access

Course Content
• Lesson One - The terminology used in an Access database, starting the Access 2007 or 2003 program opening an existing sample database, opening a table, query, form and report, entering a new record, finding records, sorting records, printing a report, closing
a database

• Lesson Two – planning and design, relationships, design view, defining fields, data types and properties, creating a new blank database, creating tables, entering data using datasheet view, re-sizing columns, using the lookup wizard

• Lesson Three – defining relationships, creating a table using the datasheet view, formatting the datasheet, modifying the table design, using the input mask wizard, creating a database using a template, renaming an object

• Lesson Four – editing data in form and datasheet views, adding new records, using print preview changing page orientation, printing a datasheet, enforcing referential integrity in a relationship, creating a relationship report, creating a form using the form
tool, working with controls in form design, using AutoFormat, modifying properties in a form

• Lesson Five – Using advanced sort, using filter by form, importing a table from an external database using a junction table to resolve a many to many relationship,
defining a composite (primary) key, adding a new field to a form, using a calculated control on a form, creating a multi-value field, creating an attachment field creating a form using the form wizard

• Lesson Six – using query wizard, setting sort criteria, using ‘or’ and ‘and’ in queries, using expressions to set criteria, creating different types of queries, creating and naming a calculated field in a query using aggregate functions

• Lesson Seven – 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 a basic report, using the report wizard, creating and modifying the design of a report, using the concatenate expression, inserting a logo to a report and adding a subreport to an existing report

Benefits
• Learn how to use this popular database program
• The flexibility and value of a self-study course designed to enable you to work at your own pace
• A personalised workbook to use as a reference guide on completion of the course
• The opportunity to gain the widely recognised Pitman Training Certificate