Enable Technology

Access 

Microsoft MOS Access 2013




Course Overview


A two day intensive course which equips participants with the skills to create manage and query an Access based relational database.

Duration: 2 day course



Course Content


Getting started
Database Concepts
Exploring the Access environment

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
Graphics
Adding calculated values
Adding combo boxes
Advanced form types

Reports and printing
Report formatting
Calculated values and subreports
Printing
Label printing

Charts
Charts in forms
Charts in reports

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 AutoKeys and AutoExec macros
Creating macros for data transfer

Importing, exporting, and linking objects
Importing objects
Exporting objects
Working with XML documents
Linking Access objects
Using 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;