We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

Designed for:

 
Those wishing to learn how to use this popular Database application
 
Prerequisites:
 
Some knowledge of an Office 2010 application. 
 
Objectives:
 
To teach the Access 2010 program to an employable level and to help prepare for the Microsoft Office Specialist (MOS) test
 
Course Content
 
Lesson One – Including: The terminology used in an Access database, starting the Access 2010 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 – Including: 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 – Including: 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 – Including:  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 themes, modifying properties in a form
 
Lesson Five – Including:  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, adding a calculated field to a table
 
Lesson Six – Including:  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 – 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 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 adding a subreport to an existing report
 
Lesson Eight – Including:  exporting an html document, understanding object  dependencies, importing an excel spreadsheet into a table, exporting a spreadsheet, importing a text file into a table, using the analyze table function, using the analyze performance function, using the database documenter
 
Lesson Nine – Including:  adding a chart to a form, modifying a chart in a form, creating a pivot table creating a pivot chart, changing the tab order in a form, displaying the current date and time in a form, applying conditional formatting to a field, creating a navigation form, customising the ribbon
 
Lesson Ten – Including: deselecting the automatic switchboard option, 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, splitting a database, creating an application part
 
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
Reviews
Be the first to write a review about this course.
Write a Review
Pitman Training is the leading provider of Legal Secretarial Courses, Exec PA Training and Medical Secretarial Diplomas in Ireland
Pitman Training
Chamber Buildings, North Street, Swords, Dublin, Ireland
01 8404075
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.