Microsoft Access 2007
Learn Microsoft Access 2007 in Aberdeen and become familiar with this popular database application. This course is ideal for those wishing to learn how to use MS Access to a competent business standard.
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
Course Content
Lesson One – Including: The terminology used in an Access database, starting the Access 2007 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 AutoFormat, 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
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, creating a switchboard, changing the tab order in a form, displaying the current date and time in a form, applying conditional formatting to a field
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
Learning Method
Flexible self paced
Course Duration
22 hours
This course is offered through our Aberdeen Training centre.
Contact us to find out more information or to book on to this course. Telephone 01224 625803.
This course has been developed by the UK's Leading Private Training Provider who specialise in Office and IT based training.
