Access Training- New Users

By: Taylor Mason Training  16/09/2011
Keywords: it training, Microsoft training, Microsoft Office Courses

Day 1 - Database Concepts Database concepts and terminology Exploring the Access environment Planning and designing databases Getting help Closing a database and Access Access Basics Exploring tables Examining queries Exploring reports Creating Databases Creating a database Using the table wizard Working in design view Working with Fields and Records Changing the design of a table Adding and deleting records Finding and editing records Sorting and filtering records Querying Tables Creating and using queries Modifying query results and queries Using calculations in queries Creating and Using Forms Creating forms by using AutoForm Using the form wizard Using design view Finding, sorting and filtering records Creating and Using Reports Using the report wizard and queries Creating, modifying and printing reports Importing, Exporting and Linking Objects Importing Access objects Exporting Access objects Linking Access objects Day 2- Creating relational databases Database normalising Introducing relating tables Adding referential integrity Working with related tables The lookup wizard Changing lookup fields Inputting data to related tables Defining data entry rules Using input masks Setting a property Setting a validation rule Using advanced query features How to join a table in queries Creating a calculated field Using an action query Creating advanced queries Summarise and group values Create a crosstab query Using a parameter query Creating advanced form design Working with graphics Working with calculations Working with combo boxes Working with unbound controls Using advanced report features Create customized headers and footers Add a calculated value Work with sub-reports

Keywords: it training, Microsoft Office Courses, Microsoft training

Other products and services from Taylor Mason Training

16/09/2011

Stress management

Delegates will learn how to manage stress, understand what it is and what are the causes of it; they will be shown how to spot stress and what happens if it is not managed.


16/09/2011

Recruitment and Selection

This course is recommencded if you need help with recruitment and selection as you will be learning things such as, Describe the features of a ‘best practice’ recruitment process Describe the advantages and disadvantages of different selection methods and interview formats Use effective questioning skills to select the best candidate for a role. And much more!


16/09/2011

Crystal Reports - Introduction

By the end of this 2 day Crystal Reports training course delegates will be able to: Display, find, sort and filter data Work with groups Build, write and edit formulas Work with filters Understand formatting Enhance reports Create charts Distribute reports


16/09/2011

Interview Skills and CV Writing

This interview and CV writing course is designed to provide you with the most up to date techniques and skills in CV preparation, interviewing techniques and self marketing strategies.


16/09/2011

Crystal Reports Training (Bespoke)

Usually this is delivered over the one day and can cater for proficient users of the software that are looking for specific training solution


16/09/2011

Headhunting Training

After attending this coure you will learn new tips and ideas such as, being able to describe what headhunting is and the process it follows you will understand how to explain why headhunting is used, and the needs of all parties affected by the headhunting process and also identify potential sources of candidates using research techniques and networking, plus much more.


16/09/2011

Headhunting Training

After attending this coure you will learn new tips and ideas such as, being able to describe what headhunting is and the process it follows you will understand how to explain why headhunting is used, and the needs of all parties affected by the headhunting process and also identify potential sources of candidates using research techniques and networking, plus much more.


16/09/2011

Sage Accounts 50

You will learn how to deal with sales, purchase and nominal ledgers, VAT returns and management reports through to prepayments and accruals.


16/09/2011

Sage Payroll - Introduction

The course uses your data as opposed to sample data thus ensuring that you receive both the training a practical set up of your payroll.


16/09/2011

Employment Law

After taking this course you will feel comfortable enough to be confident with no hesitation when asked about employment law. You will learn lots of new facts about it.


16/09/2011

Accredited Management Training - Level 3, 4 days

This management training course will enhance your skills and understanding of your role, your responsibility and the required behaviours to be successful at managingand leading people and teams.


16/09/2011

Discipline & Grievance Training

By taking this course you will learn new information and tips, and come away with a lot of new knowledge to help your company/business.


16/09/2011

Accredited Supervisor Training - Level 3, 1 day

This course provides new or excisting supervisor with the skills and knowledge to become exceptional team managers whilst obtaining an accreditation at the end of the training.


16/09/2011

Conflict Resolution

You will learn effective techniques in dealing with difficult situations professionally; you will be able to identify the underlying causes of difficult behaviour. You will also understand the model for managing conflict, keeping calm to resolve problems and understand the techniques used to overcome negative and aggressive behaviour.


16/09/2011

Appraisal Training

To provide you with an understanding of appraisals and how to use an appraisal system effectively.