Lesson One – Including: terminology, working with existing databases, opening a table, query, form and report, entering new records. Lesson Two – Including: planning and design, relationships, defining fields, data types and properties, creating tables, entering data, resizing columns. Lesson Three – Including: defining relationships, creating tables, formatting, modifying, using the input mask wizard, using templates. 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. 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. Lesson Six – Including: using query wizard, setting sort criteria, using expressions to set criteria, creating different types of queries. 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 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. Lesson Nine – Including: adding and modifying a chart, changing the tab order in a form, displaying the current date and time in a form. Lesson Ten – Including: creating a macro, adding a control button to a form, backing up a database, viewing database properties, compacting and repairing a database, encrypting a database using a password, saving the database as a previous version.
Name: Microsoft Access Qualification title: - Qualification type: Course provider certificate (this must include an assessed element) Assessment Exam Awarding - Created 20170109 09:41:27 Updated 20170113 11:38:03
None
PITMAN TRAINING GROUP LIMITED
gail.charlton@pitman-training.com
n/a
Walkers Court, Audby Lane Town: Wetherby