Enable Technology

Access 

Microsoft MOS Access 2010




Course Overview


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.

Duration: 2 day course



Course Content


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
Hyperlink fields

Database management
Optimizing resources
Protecting databases
Setting options and properties






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;