Enable Technology

Access 

Microsoft MCAS Access 2007




Course Overview


This two day intensive course is mapped against the MCAS (Microsoft Certified Application Specialist) qualification.  The course will give candidates the skills to  build,  manage and query an Access 2007 database. The course assumes no prior Access knowledge

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
Reports
Modifying and printing reports

Relational databases
Database normalization
Relating tables
Implementing referential integrity

Related tables
Lookup fields
Modifying lookup fields
Subdatasheets

Complex queries
Joining tables in queries
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
Adding 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 2007






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;