JMD Training and Consultancy courses

...Scenario Manager and Goal Seek tools Use Excel workgroup features Create and use macros Using multiple workbooks Using a workspace Printing workbooks Printing... Learn about: MS Excel, Goal seek, Microsoft excel training...

...Using Field Properties for Protection The Required property Default Values Input Masks Validation Rules and Validation Texts Lookups Table Relationships... Learn about: Foreign Keys,
Relationship Types, Relationships Defined...

...customising the Navigation pane Database display Table design - fields Applying and modifying data types such as text, memo, hyperlink, currency... Learn about: Table design, Field templates, Database training...

...Adding fields to tables Field templates Microsoft Access Query design Grouping information in a query Using a crosstab query Using wildcards in a query... Learn about: Database training, Microsoft Access, Multiple values



...

...the comment text in the presentation The Document Inspector Packaging a presentation for... Learn about: Automatic slide shows, Animating objects, Multimedia

...

...to slide transitions Automatic slide shows Custom slide shows Linking to other applications Importing and linking data from Excel to charts Importing information... Learn about: Drawing flowcharts, Managing presentations, Drawn objects...

...the importance of setting rules to ensure relationships between tables are valid First Steps with Microsoft Access Databases Opening and closing Access... Learn about: Preparing outputs, Deleting a query, Running a query...

...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: Deleting a query, Database training, Microsoft Access...

...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: Sorting records, Database training, Preparing outputs...

...On completion of the course delegates should understand and be able to accomplish basic operations associated with developing, formatting and using an MS Access database... Learn about: Sorting records, Database training, Preparing outputs...

...specific record Deleting a table Saving and closing a table Defining a primary key Indexing a field with and without duplicates Changing field format attributes such... Learn about: Running a query, Database training, Sorting records...

...using Microsoft Access 2013. They will be able to: •Use field properties for protection •Understand table relationships and referential integrity •Create... Learn about: Option groups


, Table design, Database training...

...features The Form Worksurface Creating Calculated Controls Adding Graphics to Forms Multi-Table Forms Subforms Microsoft Access 2003 and the Internet Hyperlinks... Learn about: Join Types, Parameter queries, Action Queries...

...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, Modify a journal entry...

...and logical expression controls in a report Calculating percentages in a report Using formulas and expressions in a report such as sum, count... Learn about: Query Types, Showing duplicates, Split forms...

...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: Data prompt, Creating arithmetic, Query Types...

...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, NOT values, Unmatched values...

...average, max, min, concatenate Creating running summaries in a report Macros Recording a simple macro Running a macro Assigning or attaching a macro to a... Learn about: Microsoft Access, Query Types, Refining Queries...

...Working with Properties Using the With Statement Working with Methods Understanding the DoCmd Object Working with Events Understanding the Order of Events Using Expressions... Learn about: Visual Basic training, Code Editor, Data Types...

...and declining tasks Changing the view for tasks Creating tasks from other Outlook components Organising tasks into categories Notes Creating notes Editing... Learn about: Declining tasks, Customising notes, Creating notes...