Return to Top

Teach a person to fish. (or create a database)

MTC's trainers and consultants deliver generic or customized courses and one-on-one mentoring at your location, either in a classroom or at your desk. Contact us for more information on how our client-focused training programs impact your bottom-line.

Sample Microsoft Access training areas include:

- 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

Is your company looking to build an application using Microsoft Access? Learn more about our extensive Microsoft Access consulting offerings!

Note: We do not offer a public schedule for Microsoft Access training as we deliver all classes at your location.


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 Applications 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, MySQL 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
Return
To Top

Contact Us

Send us a message. We'd love to hear from you.

617.250.3220 Massachusetts Technology Corporation
60 Leo M Birmingham Parkway
Suite 107
Boston, MA 02135
617.250.3220