JMD Training and Consultancy courses

...and previewing multiple worksheets Custom views Display Using one-input or two-input data tables Protection Protecting and unprotecting a worksheet... Learn about: Scenario manager, SmartArt graphics, Goal seek...

...Relationships Defined Relationship Types How to Create and Edit Relationships Using Lookups for Referential Integrity Multi-Table Datasheet view Access... Learn about: Foreign Keys, Control Wizards, Input Masks...

...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: Database training, Microsoft Access, Table 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: Microsoft Access, Form Design, Table Relationships...

...rescaling an image Rotating, mirroring and flipping an image Applying effects to images Converting an image into greyscale or black and white format Converting... Learn about: Action buttons, Inserting sounds, Ms PowerPoint...

...from other applications Exporting slides to other applications Securing and sharing presentations Inserting, reading, editing and deleting comments Using... Learn about: Drawn objects, Drawing flowcharts, Ms PowerPoint...

...count, at appropriate break points Adding and modifying text in report headers and footers Deleting a report Saving and closing a report Preparing outputs Previewing tables... Learn about: Database training, Sorting records, 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: Preparing outputs, Sorting records, Database training...

...within a report layout Grouping data under a specific field in a report in ascending or descending order Presenting specific fields in a grouped report by... Learn about: Running a query, Database training, Preparing outputs...

...Navigating to next record, previous record, first record, last record, specific record using form display Adding and modifying text in form headers... Learn about: Sorting records, Database training, Preparing outputs...

...They should also be able to create and use tables and forms, and be able to retrieve information from a database using queries and reports. MS Access Database... Learn about: Deleting a query, Sorting records, Database training...

...and editing a lookup in a field •Creating and editing a validation rule in a field •Creating and editing an input mask in a field •Applying and modifying... Learn about: Database training, Query Design, Microsoft Access...

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

...form Add fields to a form Save a form Test a... Learn about: Mail Merge, Social Connectors, Group schedules...

...added to their skills in using Microsoft Access. They will be able to: Use advanced forms features Use Access in conjunction with the Internet Create advanced... Learn about: Parameter queries, Query Types, Split forms...

...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: Data prompt, Advanced Forms, Running A Macro...

...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: Forms features, Microsoft Access, Assign macros...

...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, Advanced Forms, Microsoft

...

...triggered, by actions through the forms and reports events. No previous programming experience is required. Our course will introduce you to coding... Learn about: Variable Scope, Handling Errors, Microsoft Access...

...using fields Organising contacts by category Linking activities to a contact Tasks Creating and updating one-time tasks Assigning tasks to others Accepting... Learn about: Accessing contacts, Filtering views, Outlook


...