One to One Training - Microsoft Access: Beginner - Intermediate - Advance - (Go at your own pace)

£33.00
Qty

Once you have discussed your learning requirements with your Microsoft Office trainer please select your availability when making your booking here from the Select Option tab below. More information can be found under the Course Locations tab below. If you have a question or a query, call us today. We're here to help.

Title: Microsoft Access Advance Training (Go at your own pace)

Version: Designed for Microsoft Access 365, 2019, 2016, 2013 & 2010

Who is this training for?
Our Access advanced training is suitable for those users with an intermediary working knowledge of Access document and want to progress to the advanced features and functions of Access Database.

Prerequisites: A good working knowledge of Microsoft Access is required.

Benefits
You will be able to consolidate your IT skills using Access advance features and functions.

What will you learn on this Access Advance Training Course?

  • Advanced Queries
  • Advanced Forms
  • Advanced Reports
  • Macros
  • Importing and Exporting Data
  • Database Management

Subject areas covered are listed in detailed in the Curriculum tab above.

Course Level: Level 3

Teaching Method: Online tutoring using Cisco Webex or Zoom as our online tutoring platform.

Hours: 1 hour (Instructor-led lesson)

Tutor's Rate: £44 per hour

We can help you with ACCESS at beginner or intermediate level, call us today and discuss your learning needs with us, we're here to help you.

Title: Microsoft Access Intermediate Training (Go at your own pace)

Version: Designed for Microsoft Access 365, 2019, 2016, 2013 & 2010

Who is this training for?
Our Microsoft Access intermediate training course is suitable for those users with basic working knowledge of Access and want to take advantage of using more complex features and functions within Access Database.

Prerequisites: An basic working knowledge of Microsoft Access is required.

Benefits
You will be able to consolidate your IT skills using Access at intermediate level

What will you learn on this Access Intermediate Training Course?

  • Access Design Tips and Techniques
  • What's new in Access
  • Creating relational databases
  • Working with tables
  • Defining data entry rules
  • Using advanced query features
  • Creating advanced queries

Subject areas covered are listed in detailed in the Curriculum tab above.

Course Level: Level 2

Teaching Method: Online tutoring using Cisco Webex or Zoom as our online tutoring platform.

Hours: 1 hour (Instructor-led lesson)

Tutor's Rate: £33 per hour

Title: Microsoft Access Basic Training (Go at your own pace)

Version: Designed for Microsoft Access 365, 2019, 2016, 2013 & 2010

Who is this training for?
Our Microsoft Access basic training is suitable for those users with no prior knowledge or experience of using Microsoft Access and who want to progress to using the basic features and functions of Access.

Prerequisites: No experience or prior knowledge of Microsoft Access is required.

Benefits
You will be able to consolidate your IT skills using Access features and functions at basic level.

Helpful Tips
To benefit from our Access basic training, learners need to have a very basic knowledge of Windows and using a computer.

What will you learn on this Access Basic Training Course?

  • Getting started with Database
  • Using Access
  • Creating Database
  • Using Table Wizard
  • Creating and using Forms
  • Creating and using Reports
  • Importing, Exporting and Linking Objects

Subject areas covered are listed in detailed in the Curriculum tab above.

Course Level: Level 1

Teaching Method: Online tutoring using Cisco Webex or Zoom as our online tutoring platform.

Hours: 1 hour (Instructor-led lesson)

Tutor's Rate: £27.50 per hour

Ordering services from our website and how it works?

Once you have discussed your learning requirements and your availability with you teacher and you are ready to start learning, you will need to book your training session(s) here.

In the Select Option... tab above, you will find our course schedule list, choose your subject level by clicking on it, book your hour(s), you will then need to click on ADD TO BASKET button on the right-hand side.

You will now need to complete your billing detail(s), all the boxes with asterisk * will need to be completed or your booking form will not be processed and once you have completed your billing detail(s) you will need to tick the box to accept our terms and conditions else your checkout will not be processed. The other box is optional (mailing list, latest news and offers).

Once you have click CHECKOUT NOW! :

Our payment gateway "WORLDPAY" will then process your transaction and if successful you will receive an email of the confirmation of the transaction and invoice of service(s) purchased.

If you face any issues, call us on 020 8907 5522 and we will walk you through it.

We are available from 9am to 9pm (Monday to Friday).

Payment Methods:

  • Credit or Debit Card
  • Email PayByLink (Invoiced Payment)

If you have a question or a query, call us today. We're here to help.

Additional Information:

We only recruit educators who have a teaching qualification and a degree in their subject specialism and who have the necessary skills and experience in delivering lessons to learners on regular basis.

We have stringent recruitment policy in place for our teachers' vacancies. We check and verify each teacher's credentials and interview them personally in stages before they can join our teaching team. Our teachers are fully qualified, highly experienced and specialised in helping people of all ages to reach their full potential.

Customers may request details of our educators prior to engaging our services.

Services: Remote Learning, Online Classes, On-site Group Training.

Course Curriculum: Access Advance

Subject areas covered
1. Advanced Queries
2. Advanced Forms
3. Advanced Reports
4. Macros
5. Importing and Exporting Data
6. Database Management

Module: Advanced Queries

  • Grouping and Summarising
  • About grouping
  • Building totals queries
  • Totals query design
  • Where totals
  • Expression totals
  • Common aggregate functions
  • Updating, deleting, and relationships
  • Referential integrity
  • Cascading practices
  • About cascading deletes
  • Allowing deletes in key fields
  • Allowing updates in key fields
  • Indexing for performance
  • About indexes
  • How an index works
  • Index planning
  • Creating indexes in tables
  • Setting index properties
  • Maximising performance
  • Specialised query types
  • Pass-Through Queries
  • Data Definition Query

Module: Advanced Forms

  • About subforms
  • Creating the main form and subform using the Form Wizard
  • Creating a subform using the SubForm Wizard
  • Using an existing form as a subform
  • Nested subforms
  • Linking forms
  • Main form-subform data relationships
  • The hyperlink control
  • Adding a hyperlink to a form
  • The Web Browser control
  • The attachment control
  • Managing attachments in a form
  • The chart control
  • Specialised form types
  • About navigation forms
  • Creating a navigation form
  • Modal dialog forms
  • Creating a database start-up form

Module: Advanced Reports

  • About sub-reports
  • Sub-report record sources
  • Main and sub-report with the same record source
  • Main and sub-report with related record sources
  • Using an unbound main report as a container
  • Advanced grouping
  • Date ranges
  • Running sums
  • Advanced formatting
  • Banded reports
  • Formatting and design options
  • Showing Username name
  • Using a logo
  • Showing and hiding for printing

Module: Macros

  • Creating a macro
  • Planning macros
  • Using the Macro Builder
  • Using Macro Builder features
  • Embedded macros
  • Assigning macros to events
  • Data macros
  • Using variables
  • Variable scope
  • Choosing variable sources
  • When to use variables
  • Creating macros with variables
  • Troubleshooting macros
  • Error handling basics
  • Stepping through macros
  • Displaying variable values
  • Using the OnError action
  • Using the MacroError Object
  • Designing robust macros
  • Logging Debug info

Module: Importing and Exporting Data

  • Data exchange basics
  • Choosing which parts of Access to use
  • Other database applications
  • OCDB databases
  • Saving import and export procedures
  • Import options
  • Export basics
  • Exchanging data with other Access databases
  • Linking to Access tables
  • Importing data in Access
  • Exporting Access objects
  • Exchanging data with Excel
  • Importing from Excel
  • Linking to Excel data
  • Appending Excel data
  • Exporting data to Excel
  • Using Text and XML data files
  • Exporting to text files
  • Exporting to XML
  • Importing from text files
  • Importing from XML files

Module: Database Management

  • Preparing and running Compact & Repair
  • Running Compact & Repair automatically
  • Restoring a database
  • Other maintenance tasks
  • Encrypting a database
  • Creating an executable file
  • Documenting the database structure

Helpful Tips
To benefit from our Access advanced training course, learners must have good working knowledge in these intermediary areas;

  • Understand Database Design, and what types of information are stored, use of data entry form, routine queries, how data is structured in a single table non-relational database, the use of indexes and key field to organise data.
  • Understand Data Integrity, Unique not null primary key, field characteristics, data validation, consistency, completeness, accuracy, and the effect of malicious or accidental alteration.
  • Able to modify database table, add or amend or delete field and field characteristics. Able to understand Field characteristics i.e. Data type, field name, field size, format, validation, and primary key.
  • Able to understand the Problems with database tables, i.e. redundant data, duplication, table structure, field characteristics and validation and sources of help.
  • Able to enter, edit and organise data i.e. select and update fields, create new records, locate and amend records, using wildcards, search operators, error checking, and data validation.
  • Understand and able to format data entry forms, i.e. field characteristics and layout, tables, colour, and lookups.
  • Able to check data entry, i.e. Spell check, format, accuracy, consistency, completeness, validity, and security.
  • Understand Data entry errors, i.e. Due to field size, data type, validation checks, using help, deal with data that does not fit parameters, alerts, reminders, and problems with forms
  • Able to perform Database queries, i.e. Alphanumeric sort, filter, single criteria, multiple criteria; save queries and output
  • Able to create Database reports, i.e. Using menus, wizards or shortcuts; selected fields; selected records
  • Competent in Formatting database reports, i.e. Data fields, page and section layout, add text or images, and adjust page setup for printing
  • Able to Check reports, i.e. Completeness, accuracy, security, sorting, formatting, layout.

Point to Note: Customers may customised modules according to their needs and learning requirements, and if you want to discuss specific modules not listed above, please speak to us, we're here to help.

Course Curriculum: Access Intermediate

Subject areas covered:
1. Access Design Tips and Techniques
2. What's new in Access
3. Creating relational databases
4. Working with tables
5. Defining data entry rules
6. Using advanced query features
7. Creating advanced queries
8. Creating advanced form design
9. Using advanced report features

Module: Creating relational databases

  • Database normalising
  • Introducing relating tables
  • Adding referential integrity

Module: Working with tables

  • The lookup wizard
  • Changing lookup fields
  • Inputting data to related tables

Module: Defining data entry rules

  • Using input masks
  • Setting a property
  • Setting a validation rule

Module: Using advanced query features

  • How to join a table in queries
  • Creating a calculated field
  • Using an action query

Module: Creating advanced queries

  • Summarise and group values
  • Create a crosstab query
  • Using a parameter query

Module: Creating advanced form design

  • Working with graphics
  • Working with calculations
  • Working with combo boxes
  • Working with unbound controls

Module: Using advanced report features

  • Create customized headers and footers
  • Add a calculated value
  • Work with sub-reports

Helpful Tips
To benefit from our Access intermediate training, learners must have good working knowledge in these basic areas;

  • Understand database components.
  • Understand what types of information are stored for example tables, forms, queries or reports.
  • Able to enter structured data for instance tables, fields and records.
  • Able to use of data entry form and create new record and add record to table.
  • Able to locate and amend for example find, search, replace, sort and wildcards.
  • Able to recognise data entry errors due to field size, data type, validation checks.
  • Able to use help.
  • Able to check data and use spell check, and format data, check data for accuracy and consistency.
  • Understand database queries and able to use alphanumeric sort, filter and single criteria.
  • Understand database reports and able to use menus, wizards or shortcuts.

Point to Note: Customers may customised modules according to their needs and learning requirements, and if you want to discuss specific modules not listed above, please speak to us, we're here to help.

Course Curriculum: Access Basic

Subject areas covered:
1. Access Design Tips and Techniques
2. What's new in Access
3. Getting started with Database
4. Using Access
5. Creating Database
6. Using Table Wizard
7. Creating and using Forms
8. Creating and using Reports
9. Importing, Exporting and Linking Objects

Point to Note: Customers may customised modules according to their needs and learning requirements, and if you want to discuss specific modules not listed above, please speak to us, we're here to help.

Services: Remote Learning, Online Classes, On-site Group Training.

Course Delivery Location: Our online tutorial services are delivered using Cisco or Zoom as our virtual training platform and you can start learning in the comfort of your home without the need to travel.

We also offer group training for employers who want to improve their staff ICT skills, we deliver training at our centre or at employers designated premises.

If you have a question or a query, call us today. We're here to help.

"Customised Curriculum were absolutely amazing in helping me with my Excel skills, James was so patient with me and what I learned enable me to go for a better job".

Sarah Smith, London

Professional tutoring agency!

Michael, Harrow

Great professional tutors for science and maths! Everything is smooth and swift from booking and communication. Highly recommended for anyone wanting to tutor their children.

Priteshb, London

Booked Maths GCSE & A level lessons for my daughters. Excellent tuition and support. I am very happy with my children's progress.

Murali Krishna IT Consultant, Wembley

Good dedicated tutors for maths lessons, booked them for my son and daughter's gcse and a level maths tuition.

Kirpal Singh, Wembley