TrainerQuest | custom Microsoft Access training and consulting

Microsoft Access provides a powerful set of tools that are sophisticated enough for professional developers, yet easy to learn for new users. Create or use powerful database solutions that make organizing, accessing, and sharing information easier than ever.

Our trainers and consultants deliver generic or customized Microsoft Access courses at your location, either in a classroom or at your employee's desk.

Contact us and learn how our client-focused Microsoft Access training and consulting solutions impact your bottom-line.

The topics below are guidelines to the course structures. After speaking with you we will tailor course content to suit your specific needs and arrange course delivery at a time convenient to you.

- Relational Database Design Topics
- Fundamental Access Topics
- Intermediate Access Topics
- Advanced Access Topics
- Programming with Microsoft Access
- Developing Enterprise Applications with MS Access
- Integrating Microsoft Access with an RDBMS

Relational Database Design Topics

	Purposes of a relational database
	Examples of relational databases
	Entity-Relationship concepts and terminology
	Tables, fields and records
	Primary keys, foreign keys
	Inner out outer joins
	Data types
	Levels of normalization
	Data integrity

Fundamental Access Topics

	Introduction to Databases
	Planning databases
	Creating a database
	Creating and modifying tables
	Lookup and input mask wizards
	Creating forms and controls
	Working with records
	Entering, editing and deleting records
	Creating and modifying queries
	Printing tables and query results

Intermediate Access Topics

	Creating and modifying reports
	Adding controls and parameters to reports
	Using control and section properties in reports
	Subreports
	Applying filters in queries
	Totals and parameter queries
	Action queries
	SQL statements
	Specifying join properties, foreign keys, foreign tables
	Optimizing queries
	Importing and exporting data
	Charts
	Linking data

Advanced Access Topics

	Defining and establishing table relationships
	Data validation
	Optimizing data types
	Creating and modifying forms
	Customizing form sections
	Using subforms
	Advanced form features
	The switchboard
	Startup options and passwords

Programming with Microsoft Access

	Develop applications with Access using Visual Basic for Applications (VBA)
	Identify and populate event properties to satisfy design specifications
	Modify object properties and invoke object methods to customize applications
	Create VBA statements using variables and built-in functions
	Build loops and decision logic
	Apply Active Data Objects (ADODB) and/or Data Access Objects (DAO) to incorporate business rules
	Construct custom objects and API calls
	Integrate Access with external applications through automation

Developing Enterprise Topics with Microsoft Access

	Program enterprise database applications using Microsoft Access and VBA
	Improve data retrieval with advanced SQL techniques
	Interface seamlessly with structure and data in SQL Server databases using Access Data Projects
	Implement ADOX security to control database accessibility
	Replicate data over networks
	Program connections to a client/server db over networks/ Internet using DHTML, ADO and OLE DB providers

Integrating Microsoft Access with an RDBMS

	Apply Access as a front-end to databases such as SQL Server and Oracle
	Upsize Access databases to develop multi-tier solutions
	Employ VBA programming techniques to create client/server database solutions
	Transform Access queries into stored procedures
	Base reports on stored procedures retrieved via pass-through queries
	Create ADO-compliant recordsets bound to Access forms and subforms