• No products in the basket.

Microsoft Access 2010 Advanced

4.5( 4 REVIEWS )
Microsoft Access 2010 Advanced


The Microsoft Access 2010 Advanced course follows the basic and intermediate training to showcase advanced techniques by bringing together Access objects to make a cohesive application. The learner will gain an understanding of why Access utilises Properties and Events. Individuals will also learn how to create macros and how to select Control and Events to achieve an optimal outcome. It is a hands-on course to equip learners on how to construct advanced design forms, use pivot charts and pivot tables for complex record handling and data retrieval. Microsoft Access 2010 will help learners simplify their tasks, and to import and export data to be used in Microsoft Word and Excel.

The Microsoft Access 2010 Advanced course will teach learners how to create and use advanced queries, create effective reports and understand documentation.

The Microsoft Access 2010 Advanced course will help learners understand the features and components to become familiar with Access. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Access 2010 Advanced.

Why consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

Learning Outcomes

  • Learn how to design the application
  • Learn how to use advanced form design
  • Learn how to create and use macros
  • Learn how to distribute the database
  • Learn how to create effective reports

Course Titles

  • Module 01: Querying with SQL
  • Module 02: Advanced Queries
  • Module 03: Macros
  • Module 04: Advanced Macros
  • Module 05: Importing, Exporting, and Linking
  • Module 06: Database Management

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.

Who is this Course aimed at?

  • The course is aimed at individuals who have intermediate knowledge of Access 2010.
  • Students looking to expand their skills in Microsoft Office Access 2010.
  • The course is ideal for individuals working as programmers and web developers.
  • Anyone interested in developing their skills in Microsoft Office Access 2010.

Entry Requirements

  • You must be over the age of 16 and have a basic understanding of Maths, English and ICT
  • Job seekers / graduates / school leavers

Method of Assessment

At the end of the Microsoft Access 2010 Advanced course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.


Those who successfully complete the exam will be awarded the certificate in Microsoft Access 2010 Advanced.

Awarding Body

The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.

Progression and Career Path

Once you successfully complete Microsoft Access 2010 Advanced you will be qualified to work in the following positions. The Microsoft Access 2010 Advanced qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to is given below.

  • Programmer – £44,873 per annum
  • Web Developer – £24,833 per annum
  • Project Assistant – £20,785 per annum
  • Business Executive – £23,667 per annum
  • Business Analyst – £35,543 per annum
  • Technical Support Analyst – £22,753 per annum

Other Benefits

  • Written and designed by the industry’s finest expert instructors with over 15 years of experience
  • Repeat and rewind all your lectures and enjoy a personalised learning experience
  • Gain access to quality video tutorials
  • Unlimited 12 months access from anywhere, anytime
  • Excellent Tutor Support Service (Monday to Friday)
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Quizzes, tests mock exams, practice exams to ensure you are 100% ready
  • Eligible for a TOTUM discount card

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Course Curriculum Total Units : 123
➤ Module 01: Querying with SQL
1.0 Topic A: SQL and Access
1.1 Sample SQL Statements
1.2 A Query in SQL View
1.3 Demo – A2: Examining a SQL Statement in Access
2.0 Topic B: Writing SQL Statements
2.1 Writing a SQL Statement
2.2 Demo – B1: Writing a SQL SELECT Statement
2.3 Syntax for WHERE Clause
2.4 Demo – B2: Using the WHERE Clause
2.5 Aliases
2.6 Demo – B3: Creating Aliases
2.7 Syntax to Display Matched Records
2.8 Demo – B4: Displaying Matching Records from Related Tables
2.9 Syntax to Display Unmatched Records
2.10 Demo – B5: Finding Unmatched Records
2.11 Context-Sensitive Help
2.12 Demo – B6: Getting Context-Sensitive Help on SQL
3.0 Topic C: Attaching SQL Queries to Controls
3.1 SQL-Specific Queries
3.2 Create a Union Query
3.3 Attach a SQL Query to a Button
3.4 Command Button Wizard
3.5 Demo – C1: Assigning a SQL Query to a Command Button
3.6 Unit 01 Review
➤ Module 02: Advanced Queries
1.0 Topic A: Creating Crosstab Queries
1.1 A Crosstab Query Result
1.2 Demo – A-1: Viewing a Crosstab Query
1.3 Create a Crosstab Query
1.4 The Crosstab Query Wizard
1.5 Demo – A-2: Using the Crosstab Query Wizard
2.0 Topic B: Creating Parameter Queries
2.1 Create a Single-Criterion Query
2.2 Demo – B1: Creating a Single-Criterion Parameter Query
2.3 Create a Multiple-Criteria Query
2.4 Demo – B2: Creating a Query with Multiple Parameters
2.5 Create a Wildcard Query
2.6 Demo – B3: Using a Wildcard in a Parameter Query
3.0 Topic C: Using Action Queries
3.1 Types of Action Queries
3.2 Use an Append Query
3.3 Demo – C1: Adding Records to a Table with an Append Query
3.4 Use a Delete Query
3.5 Demo – C2: Deleting Records with a Delete Query
3.6 Use an Update Query
3.7 Demo – C3: Modifying Records with an Update Query
3.8 Use a Make Table Query
3.9 Demo – C4: Creating a Make Table Query
3.10 Unit 02 Review
➤ Module 03: Macros
1.0 Topic A: Creating, Running, and Modifying Macros
1.1 Sample Macro with a Condition
1.2 The Macro Tools | Design Tab
1.3 Demo – A1: Creating and Running a Macro
1.4 Demo – A2: Modifying a Macro
2.0 Topic B: Attaching Macros to the Events of Database Objects
2.1 The Event Tab
2.2 Demo – B1: Attaching a Macro to the Open Event of a Form
2.3 Attach Macro to Command Button
2.4 Demo – B2: Attaching a Macro to a Command Button
2.5 Unit 03 Review
➤ Module 04: Advanced Macros
1.0 Topic A: Creating Macros to Provide User Interaction
1.1 Sample Macro with a Condition
1.2 Create a Data Validation Macro
1.3 Demo – A1: Creating a Data Validation Macro
1.4 Create a Data Entry Macro
1.5 Demo – A2: Creating a Data Entry Macro
2.0 Topic B: Creating Macros that Require User Input
2.1 Macro to Run a Parameter Query
2.2 Demo – B1: Creating a Macro that Runs a Parameter Query
3.0 Topic C: Creating AutoKeys and AutoExec Macros
3.1 The AutoKeys Macro
3.2 Demo – C1: Creating an AutoKeys Macro
3.3 Create an AutoExec Macro
3.4 Demo – C2: Creating an AutoExec Macro
4.0 Topic D: Creating Macros for Data Transfer
4.1 The ImportExportData Action
4.2 Demo – D1: Importing a Database Object by Using a Macro
4.3 Export Data to a Spreadsheet
4.4 Demo – D2: Exporting Data to a Spreadsheet by Using a Macro
4.5 Unit 04 Review
➤ Module 05: Importing, Exporting, and Linking
1.0 Topic A: Importing Objects
1.1 Import Objects from a Database
1.2 The Import Objects Dialog Box
1.3 Demo – A1: Importing Multiple Objects
1.4 Import Objects from Excel
1.5 Demo – A2: Importing an Object from Excel
1.6 Manage Data Tasks
1.7 Demo – A3: Using a Saved Import Specification
1.8 Fixed Width vs. Delimited Format
1.9 Demo – A4: Importing a CSV File
2.0 Topic B: Exporting Objects
2.1 Export Objects from a Database
2.2 The Export Table Dialog Box
2.3 Demo – B1: Exporting an Object
2.4 Demo – B2: Using a Saved Export Specification
3.0 Topic C: Working with XML Documents
3.1 Export as XML
3.2 The Export XML Dialog Box
3.3 The Import XML Dialog Box
3.4 Demo – C1: Exporting and Importing XML Documents
3.5 Export with an XSL File
3.6 Demo – C2: Exporting to an XML Document with an XSL File
3.7 Publish as PDF or XPS
3.8 Demo – C3: Saving a Table as an XPS File
4.0 Topic D: Linking Access Objects
4.1 Link a Table
4.2 Demo – D1: Linking to an Access Table
4.3 Update a Link
4.4 Linked Table Manager
4.5 Demo – D2: Updating Links
4.6 Link to an Excel Workbook
4.7 Demo – D3: Linking to an Excel Workbook
5.0 Topic E: Using Hyperlink Fields
5.1 Create a Hyperlink Field
5.2 Demo – E1: Creating a Hyperlink Field
5.3 The Insert Hyperlink Dialog Box
5.4 Demo – E2: Inserting Data in a Hyperlink Field
5.5 Modify Hyperlink Data
5.6 Demo – E3: Modifying Data in a Hyperlink Field
5.7 Unit 05 Review
➤ Module 06: Database Management
1.0 Topic A: Optimizing Resources
1.1 Convert to a Prior Version
1.2 Demo – A1: Converting a Database to a Prior Version
1.3 The Performance Analyzer
1.4 Performance Analyzer Results
1.5 Demo – A2: Analyzing Performance
1.6 Split a Database
1.7 Demo – A3: Splitting a Database
1.8 Compact and Repair a Database
1.9 Demo – A4: Using the Compact and Repair Database Utility
1.10 Back Up the Active Database
1.11 Demo – A5: Backing up a Database
2.0 Topic B: Protecting Databases
2.1 Encrypt and Password-Protect
2.2 Demo – B1: Encrypting a Database with a Password
2.3 Remove Password and Encryption
2.4 Demo – B2: Removing a Password and Encryption
3.0 Topic C: Setting Options and Properties
3.1 The Access Options Dialog Box
3.2 Demo – C1: Setting Access Options
3.3 Database Properties Dialog Box
3.4 Demo – C2: Creating and Populating Database Properties
3.5 Unit 06 Review
3.6 Course Closure
WhatsApp chat