Access 2003
Sponsored links
Our Microsoft Access courses are spilt into managable lessons- although these are not fixed-time Microsoft Access training classes; our flexible study programme means you can work at your own pace at one of our handy town or city centre locations.
In a detailed and varied training programme, you'll be guided through many aspects of Access including database terminology; planning and design; defining relationships and creating a table; editing data; using advanced tools; using the query wizard; adding a field; exporting an html document; adding charts to forms; and creating macros. After your training, your workbook is yours to keep as a handy reference guide - and you'll have all the advantages of having the renowned Pitman Training name on your CV.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
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
This Training Course is available at the following locations:
Brighton
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
