Access 2007

Now you can learn the latest version of Microsoft Access in depth, starting at any time and studying at your own pace during our long opening hours.
A quick look at the job adverts for secretarial and admin positions will confirm the popularity of this advanced database programme which forms part of the MS Office suite.
You'll need to dedicate 25-30 hours of study at our comfortable training centre to master the programme, enhancing your employability all the while.
You can invest your learning time however you wish, studying daytimes, evenings or Saturdays or a blend of all three!
Some people study full-time for a few days, others dip in and out on an irregular basis to suit the other demands on their time.
The choice is yours!
What Is Covered. This course offers 10 increasingly challenging lessons covering the following:
Lesson One:
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:
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, adding a subreport to an existing report.
Lesson Eight:
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 analyse table function, using the analyse performance function, using the database documenter.
Lesson Nine:
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:
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.