Microsoft (MOS) Access 2010 Taining Course Midlands | Birmingham | Telford | Stafford | Wolverhampton

Course Name	Microsoft (MOS) Access 2010
Duration	2 days
Cost	£495 excluding VAT
Location	EnableTechnology is based at Wolverhampton Science Park in the West Midlands. Training courses takes place at locations across the Midlands including Birmingham, Wolverhampton, Walsall, Sandwell, Dudley, Stourbridge,Telford, Cannock, Solihull, Redditch, Droitwich, Bromsgrove, Shropshire, Shrewsbury, Derbyshire, Staffordshire, Shropshire, Kidderminster, Stafford, Stoke-on-Trent, Lichfield, Cheltenham, Gloucestershire, Nottingham, Stoke-on-Trent, Tamworth, Kenilworth, Loughborough, Sutton Coldfield, Burton-on-Trent , Worcestershire and Worcester.
Course Description
A two day intensive course mapped against the MOS (Microsoft Office Specialist) qualification. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database. Topics include Getting started Database concepts Exploring the Access environment Getting help Databases and tables Planning and designing databases Exploring tables Creating tables Fields and records Changing the design of a table Finding and editing records Organizing records Data entry rules Setting field properties Working with input masks Setting validation rules Basic queries Creating and using queries Modifying query results and queries Performing operations in queries Using forms Creating forms Using Design view Sorting and filtering records Working with reports Creating reports Modifying and printing reports Relational databases Database normalization Table relationships Referential integrity Related tables Creating lookup fields Modifying lookup fields Subdatasheets Complex queries Joining tables in queries Using calculated fields Summarizing and grouping values Advanced form design Adding unbound controls Adding graphics Adding calculated values Adding combo boxes Advanced form types Reports and printing Customized headers and footers Calculated values Printing Labels Charts Charts in forms Charts in reports PivotTables and PivotCharts PivotTables Modifying PivotTables PivotCharts PivotTable forms Querying with SQL SQL and Access Writing SQL statements Attaching SQL queries to controls Advanced queries Creating crosstab queries Creating parameter queries Using action queries Macros Creating, running, and modifying macros Attaching macros to the events of database objects Advanced macros Creating macros to provide user interaction Creating macros that require user input Creating the AutoKeys and AutoExec macros Creating macros for data transfer Importing, exporting, and linking Importing objects Exporting objects Interacting with XML documents Linking Access objects Working with Windows SharePoint Services Database management Optimizing resources Protecting databases Setting options and properties Internet integration Hyperlink fields Working with Outlook 2010

Contact Enable Technology about Microsoft (MOS) Access 2010 training

Search our site for training courses
Course Name:

Telephone Enable Today

01902 837406

Alernative Enable Technology Training Courses

Training Course Locations

Training courses takes place at the followining locations throughout the Midlands. Birmingham, Wolverhampton, Walsall, Sandwell, Dudley, Stourbridge, Telford, Cannock, Solihull, Redditch, Droitwich, Bromsgrove, Shropshire, Shrewsbury, Derby, Derbyshire, Stafford Staffordshire, Shropshire, Kidderminster, Stafford, Stoke-on-Trent, Lichfield, Cheltenham, Gloucestershire, Nottingham, Stoke-on-Trent, Tamworth, Kenilworth, Loughborough, Sutton Coldfield, Burton-on-Trent , Worcestershire and Worcester.

Home \| About Us \| Training \| Solutions \| Contact
Booking Form	Disclaimer	Enable Links