Microsoft Access 2003
Microsoft Access 2003 Training in Aberdeen. Ideal for those wishing to learn this popular database program to a competent business standard.
Benefits
- Learn how to use this popular database program to Microsoft Office Specialist level
- 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: Terminology used in connection with a database, loading the Microsoft Office Access program, opening an existing database, navigating around different objects in a database, using datasheet and design view, entering a new record, finding records, sorting records
Lesson Two – Including: Planning and design of a database, recognising relationships between tables, defining fields, data types and properties using design view, entering data into tables using datasheet view, re-sizing columns, using the Lookup Wizard
Lesson Three – Including: Defining relationships, sing the Table Wizard to create a table, modifying the table design, sing the Input Mask Wizard, sing the Database Wizard to create a new database
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, using the Form Wizard, working with controls in form design
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, adding a new field to a form, using a calculated control on a form, creating a query, using criteria to retrieve selected data, creating and naming a calculated field in a query
Lesson Six – Including: Adding a field with data validation in a table, creating a form with subform, entering data using a form/subform combination, creating and modifying the design of a report, adding a subreport to an existing report
Lesson Seven – Including: Exporting an HTML file, editing an existing web page, creating a data access page, adding a hyperlink, object dependencies, importing an Excel spreadsheet as a table, importing a comma delimited text file as a table, creating a switchboard, backing up a database
Learning Method
Flexible self paced
Course Duration
16-18 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.
