JMD Training and Consultancy courses

...SmartArt graphic layout Changing SmartArt graphic colours Macros Recording macros Running macros Editing macros... Learn about: Data Analysis Tools,
Solver, MS Excel...

...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: Input Masks, Form Sections,
Relationship Types...

...check box and option groups Inserting a data field to appear within form header or footer on the first page or all pages Stacked and tabular layout controls... Learn about: Microsoft Access, Form Design, Query Design...

...Report design Inserting a data field to appear within report header or on footers on the first page or all pages Forcing page breaks for groups on reports Importing... Learn about: Query Design, Microsoft Access, Report Design...

...jpeg and bmp formats Pictures, images and drawn objects Converting pictures to drawn objects Grouping and ungrouping drawn objects Bringing images backwards... Learn about: Document Inspector, Inserting sounds, Automatic slide shows...

...objects will dim to a specified colour after animation Animating chart elements Managing presentations Hyperlinks Creating action buttons Applying timings... Learn about: Drawn objects, Microsoft Powerpoint, Managing presentations...

...one-to-many relationship between tables Deleting relationships between tables Applying rules to relationships such that fields that join tables are... Learn about: Sorting records, Deleting a query, Database training...

...unhiding fields Running a query Deleting a query Saving and closing a query Sorting records Sorting data in a table, form or query output in ascending... Learn about: Database training, Preparing outputs, Microsoft Access...

...selected records, a complete table Print all records or specific pages using form layout Printing the results of a query Printing a report or specific pages in a report... Learn about: Running a query, Preparing outputs, Database training...

...footers Deleting a form Saving and closing a form Searching and filtering Using the search command for a specific word, number, date in a field Applying... Learn about: Microsoft Access, Running a query, Sorting records...

...a query using the operators , >=, = , AND, OR Editing a query by adding or removing criteria Editing a query by adding, removing, moving, hiding... Learn about: Deleting a query, Preparing outputs, Sorting records...

...This course aims to give delegates a greater understanding of MS Access 2013. On completion of the course delegates will have improved their skills... Learn about: Database training, Table design, Form Design...

...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: Join Types, Update Queries, Microsoft Access...

...using the Journal Interact with the Internet Work offline and remotely Create a custom form Collaboration Connecting with colleagues via Outlook Social... Learn about: Mail Merge, Group schedules, Social Connectors...

...records in a table Creating and using a query to save the selected information as a table Appending records to a table using a query Refining Queries Showing... Learn about: Showing duplicates, Split forms, Query Types...

...duplicates Showing unmatched values Showing the highest or lowest range of values in a query Parameter queries - allowing query input from a data prompt... Learn about: Query Types, Running A Macro, Creating arithmetic...

...duplicates Showing unmatched values Showing the highest or lowest range of values in a query Parameter queries - allowing query input from a data prompt... Learn about: Produce reports, Microsoft Access, Unmatched values...

...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

, Advanced Forms, Query Types...

...a programming language which can be used to build your own applications. Within this Integrated Development Environment (VBA is part of the Microsoft Office... Learn about: Visual Basic training, Debugging Code, Variable Scope...

...use Microsoft Outlook 2003. They will be able to: Send and receive mail Schedule appointments, events and meetings Create and manage tasks Organise contacts... Learn about: Managing e-mail, Editing notes, Outlook


...