Advanced Access 2013, 2016 snd 2019 Training Courses
DMW’s Advanced Microsoft Access courses are for anyone wishing to further their ambition to set up a fully functional, relational database, possibly to be used concurrently by colleagues.
Also, the courses should suit anyone who has inherited a database and who needs techniques for understanding how the database works and for assessing what it might take to revise or extend it.
Every course DMW presents is tailored to our client's needs. At the advanced level, topics are likely to be drawn from those in this list.
Development Considerations Addressing issues database developers often have to face; separating needs from wishes; naming conventions.
Referential Integrity Relationship design; cascading updates; cascading deletes.
Multi-user Databases Setting up a database for multiple users on a LAN (local area network—split FE (front end) and BE (back end) databases.
Linking Databases Linking database with other databases and other sources of data.
Maintenance and Structuring Strategies Maintaining and updating databases; structuring large databases.
Select queries Advanced techniques; managing query joins; criteria and sorting; using forms to apply criteria.
Functions Special functions for use in query expressions; construction of complex expression fields.
Sub-queries SQL technique for extending query design.
Nested queries Mining for data by basing one query upon another.
Action queries Further techniques for exploiting make-table, delete, update and append queries.
Cross-tab queries Creating cross-tabulations for data analysis.
Union queries Amalgamating data from two or more queries using a single query
Avoiding Data Duplication Managing duplicate records in multiple data sets.
Queries behind forms Using queries as record sources for forms.
Query optimisation Techniques for improving performance of queries; application of indexes.
From design Advanced techniques for designing forms; the tab control; use of functions as control sources; nesting forms; pop-up forms.
Report design Advanced techniques for designing reports; grouping; data sorting; nested reports; filtering data; use of functions as control sources; e-mailing.
Macros A first look at creating and editing macros. Access's support for macros has been extended with each new version. However, if you are serious about programming your database, please consider DMW’s Access VBA training: this introduces the comprehensive power of the VBA language.
Ribbon customisation Customising ribbons requires an understanding of the XML mark-up language. Another skill you need to master if you the benefits of customisation. DMW will give you a start.
Maintenance Compacting and repairing databases.
As appropriate, the training may include topics not listed above. Please discuss ahead of any training the plans you have for your database so that DMW is aware of topics that are likely to be of most relevance.
The minimum duration for this course is one day on-site, normally between 9:30am and 4:30pm.
Depending on the complexity of the database you have in mind, and your ambitions for it, you may need to allow an extra day or two.
Some clients have found advantage in completing the first day and then taking a break in their training to try things out before deciding if they need to make an additional booking.
Completion of DMW’s Intermediate course or practical experience of applying the skills covered in that course to the creation of your own database.
You might find benefit from taking a look at DMW’s companion website and its page on creating a contacts database. You’ll find something on planning that’s likely to set you thinking about your design of your own database.