Training Course:Microsoft Access XP/2003School/Trainer:Catalyst Learning
London, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Learn how to use Access databases efficiently, extract required data, convert data into a well presented format as well as design effective and simple ways of entering in data. This course is ideal for those looking to design databases and become more than just a basic database user.
Pre-requisite
No prior knowledge of this package is required, although Windows experience is essential.
Course content
Module 1 - Create a Database · Plan a database. Create a table. Enter data into a table. Modify data in a table. Enter data into a form. Navigate through a table. Delete data from a table.
Module 2 - Use Forms · Create and modify a simple form. Create and modify controls on a form. Add records to a form. Show related records on a form.
Module 3 - Modify a Database · Open a database. Modify field layout. Modify the presentation of a database.
Module 4 - View Information · Present information in a chart. View information in a form. View multiple records. Switch between views.
Module 5 - Organise Information · Sort data on single fields. Sort data on multiple fields.
Module 6 - Locate Information · Use find to search for specific records. Create a simple query. Create a query using multiple criteria. Add and remove filters.
Module 7 - Refine Results of a Query · Add and remove fields from a query. Sort a query. Join table in a query. Remove joins from a query. Save a query.
Module 8 - Analyse Data · Create summary queries. Add calculated fields to queries.
Module 9 - Create Sub Forms · Identify appropriate use for sub forms. Add records to both main and sub forms. Merge two tables into a form.
Module 10 - Build a Relational Database · Identify relationships. Relate tables.
Module 11 - Maintain Data Integrity · Identify criteria for data integrity. Validate text. Set required properties. Set validation rules. Set look up fields. Use expressions in calculated controls.
Module 12 - Integrate Information from Other Applications · Import data. Link data. Add pictures to records.
Module 13 - Build a Form for Other Users · Add a title to a form. Modify and enhance the design of a form.
Module 14 - Pivot Table and Pivot chart · Create and modify Pivot Table and Pivot Charts in Tables and Forms.
Module 15 - Produce Reports · Create and modify a report. Customise headers and footers. Add calculation on a report. Group and sort data in a report. Add custom pages.
Module 16 - Print · Print a form for a selected record. Print reports from tables or results of a query.
...''
Please go to the school's official website for training price and schedule:
http://www.cbduk.biz
Phone:0800 953 0387
School Address:
175 Tottenham Court Road
London, W1T 7NU
UK
Jobs & Resumes: London
Houses & Roommates: London
Other training courses offered by Catalyst Learning:
Train the Trainer
Negotiation
Illustrator CS
Acrobat
InDesign CS
Photoshop CS
HTML
Dreamweaver MX
Fireworks MX
Flash MX - Action Script
Microsoft Excel XP/2003
FrontPage 2003
Microsoft Outlook 2003
PowerPoint XP/2003
Microsoft Project XP/2003
Publisher 2003
Visio 2003
Microsoft Word XP/2003
QuarkXPress 6.0
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback. |
|
| 
