JMD Training and Consultancy courses

...custom sorts Querying/filtering Creating a single or multiple criteria query using available options Using advanced query/filter options Templates Using... Learn about:
Solver, Data Analysis Tools, Tracing errors...

...multi-table queries Use calculations in a query Design custom entry forms Design custom reports Access Database Design Primary and Foreign Keys Relationships... Learn about: Form Controls, Control Wizards, Default Values...

...multi-table queries Use calculations in a query Design custom entry forms Design custom reports Displaying the Access 2007 database The Navigation... Learn about: Table design, Database training, Form Design...

...using Microsoft Access 2010. They will be able to: Use field properties for protection Understand table relationships and referential integrity Create... Learn about: Database training, Multiple values



, Table Relationships...

...Inserting sounds and movies Animating objects Changing the sequence of animations in a slide Applying automatic settings so that bulleted points and drawn... Learn about: Microsoft Powerpoint, Document Inspector, Custom slide shows...

...Merging slides and presentations Merging a word-processed outline into a presentation Applying background effects to slides Exporting slides in... Learn about: Microsoft Powerpoint, Managing presentations, Drawing flowcharts...

...>=, = , AND, OR Editing a query by adding or removing criteria Editing a query by adding, removing, moving, hiding, unhiding fields Running a query Deleting... Learn about: Deleting a query, Table
, Preparing outputs...

...The Navigation Pane Saving a database to a location on a drive Using available Help functions Closing an Access 2007 database Adjusting Settings Changing... Learn about: Sorting records, Database training, Preparing outputs...

...This course aims to introduce delegates with little or no understanding of the Microsoft Access 2010 software to the basic features of the package... Learn about: Sorting records, Deleting a query, Microsoft Access...

...a report Preparing outputs Previewing tables, forms and reports Changing report orientation: portrait, landscape. Changing paper size Print a... Learn about: Sorting records, Running a query, Preparing outputs...

...The Navigation Pane Saving a database to a location on a drive Using available Help functions Closing an Access 2016 database Adjusting Settings Changing... Learn about: Preparing outputs, Sorting records, Deleting a query...

...date and time in a field •Understanding the consequences of modifying data types such as text, memo, hyperlink, currency, date and time in a field •Creating... Learn about: Report Design, Option groups


, Microsoft Access...

...Use Access in conjunction with the Internet Create advanced queries Produce reports MS Access 2003 Database Design Theory of Normal Forms Naming Conventions... Learn about: Parameter queries, Grouping to Reports, Performing Calculations...

...advanced skills to apply when using Microsoft Outlook 2010. They will be able to: Work with contacts Communicate with e-mail alternatives Track work activities... Learn about: Group schedules, Mail Merge, Social Connectors...

...on a form Creating a subform and linking it to parent Modifying the subform to change records displayed Split forms Calculations in Reports Creating arithmetic... Learn about: Refining Queries, Query Types, Split forms...

...queries Produce reports Record and assign macros Query Types Creating and using a query to update data in a table Creating and using a query to delete... Learn about: Advanced Forms, Running A Macro, Refining Queries...

...on a form Creating a subform and linking it to parent Modifying the subform to change records displayed Split forms Calculations in Reports Creating arithmetic... Learn about: Split forms, Microsoft Access, Assign macros...

...on a form Creating a subform and linking it to parent Modifying the subform to change records displayed Split forms Calculations in Reports Creating arithmetic... Learn about: Microsoft

, Query Types, Advanced Forms...

...suite so no additional software is required) you create ‘macros’ which are step-by-step procedures written in Visual Basic. These procedures can then be run... Learn about: Debugging Code, Visual Basic, Trapping Errors



...

...and events Scheduling multi-day events Setting reminders Scheduling recurring appointments Planning meetings involving others Booking office resources... Learn about: Declining tasks, Accessing contacts, Sorting mail...