• No products in the basket.

MS Access 2010 Intermediate

4.5( 4 REVIEWS )
MS Access 2010 Intermediate


The Microsoft Access 2010 Intermediate course will teach learners the fundamentals of database design, and how to construct a relational database where data analysis and future modifications are made easier. This course is a follow-up from the basic Access training and will touch on topics such as tables and its attributes, field properties and structures. The crucial step of this course is to equip new users with key components in Access 2010. This will help learners build a database retrieve data, generate reports and design and formulate queries.

The Microsoft Access 2010 Intermediate course will teach learners how to import data into the database, retrieve and modify records, delete records, build forms and reports.

The Access 2010 Intermediate course will give you an understanding of the different types of data and how to determine which data is allocated. You need to be efficient in these steps, otherwise the database will not function efficiently. 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 Intermediate.

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 Access 2010 interface including Ribbon Features and Backstage View
  • Learn new techniques to create forms to present data visually
  • Learn how to filter data in tables and forms
  • Learn how to improve report design, how to sort and group on the report and add existing fields
  • Learn how to update database quickly

Course Titles

  • Module 01: Relational Databases
  • Module 02: Related Tables 1.0
  • Module 03: Complex Queries
  • Module 04: Advanced Form Design
  • Module 05: Reports and Printing
  • Module 06: Charts
  • Module 07: PivotTables and PivotCharts

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 beginner’s knowledge of Access 2010.
  • Students looking to expand their skills in Microsoft Office Access 2010.
  • The course is ideal for individuals working as programmers.
  • 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 Intermediate 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 Intermediate.

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 Intermediate you will be qualified to work in the following positions. The Microsoft Access 2010 Intermediate 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 : 157
➤ Module 01: Relational Databases
Course Introduction
1.0 Topic A: Database Normalization
1.1 Normalization
1.2 Steps to Normalize: Rule 1
1.3 Steps to Normalize: Rule 2
1.4 Steps to Normalize: Rule 3
1.5 Demo – A-3: Using the Table Analyzer
1.6 Demo – A-4: Identifying Object Dependencies
2.0 Topic B: Table Relationships
2.1 Establishing Relationships
2.2 The Relationships Window
2.3 Demo – B-1: Establishing a One-to-One Table Relationship
2.4 One-to-Many Relationship
2.5 Demo – B-2: Establishing a One-to-Many Table Relationship
2.6 Junction Tables
2.7 Many-to-Many with Junction
2.8 Demo – B-3: Establishing a Many-to-Many Table Relationship
2.9 Printing Table Relationships
2.10 Demo – B-4: Printing Table Relationships
3.0 Topic C: Referential Integrity
3.1 Referential Integrity
3.2 Demo – C-1: Planning Table Relationships
3.3 Orphan Records
3.4 Demo – C-2: Working with Orphan Records
3.5 Using Cascading Deletes
3.6 Demo – C-3: Setting Cascading Deletes
3.7 Testing Cascading Deletes
3.8 Demo – C-4: Testing Cascading Deletes
3.9 Cascading Updates
3.10 Demo – C-5: Using Cascading Updates
3.11 Unit 01 Review
➤ Module 02: Related Tables 1.0
1.0 Topic A: Creating Lookup Fields
1.1 Lookup Field
1.2 Creating a Lookup Field
1.3 Demo – A-1: Creating a Lookup Field
1.4 Multivalued Fields
1.5 A Multivalued Lookup Column
1.6 Demo – A-2: Creating a Multivalued Lookup Field
2.0 Topic B: Modifying Lookup Fields
2.1 Display Column Headings
2.2 Demo – B-1: Modifying Lookup Field Properties
2.3 Types of Controls
2.4 Using a Value List Combo Box
2.5 Demo – B-2: Changing a Text Box to a Combo Box
3.0 Topic C: Using Subdatasheets
3.1 A Subdatasheet
3.2 Inserting a Subdatasheet
3.3 Demo – C-1: Using a Subdatasheet
3.4 Unit 02 Review
➤ Module 03: Complex Queries
1.0 Topic A: Joining Tables in Queries
1.1 Joins
1.2 Query Wizard
1.3 Creating a Query
1.4 Demo – A-1: Creating a Query with the Simple Query Wizard
1.5 Creating Joins in Design View
1.6 Demo – A-2: Creating a Join in Design View
1.7 Creating Outer Joins
1.8 Demo – A-3: Creating an Outer Join
1.9 Joins with an Intermediate Table
1.10 Demo – A-4: Creating a Join with an Intermediate Table
1.11 Creating a Self-Join Query
1.12 Demo – A-5: Creating a Self-Join Query
1.13 Finding Unmatched Records
1.14 Demo – A-6: Finding Records that Do Not Match Between Tables
1.15 Finding Duplicate Records
1.16 Demo – A-7: Finding Duplicate Records
1.17 Demo – A-8: Deleting Tables from a Query
2.0 Topic B: Using Calculated Fields
2.1 Syntax for Calculated Fields
2.2 Creating Calculated Fields
2.3 Demo – B-1: Creating a Calculated Field
2.4 Modifying Formats
2.5 Demo – B-2: Changing the Format of a Displayed Value
2.6 The Expression Builder
2.7 Specifying Criteria
2.8 Demo – B-3: Using the Expression Builder
3.0 Topic C: Summarizing and Grouping Values
3.1 Summary Functions in Queries
3.2 Demo – C-1: Creating a Query to Display Summary Values
3.3 Concatenation
3.4 Demo – C-2: Using Queries to Concatenate Values
3.5 Unit 03 Review
➤ Module 04: Advanced Form Design
1.0 Topic A: Adding Unbound Controls
1.1 Unbound Controls
1.2 Drawing a Rectangle on a Form
1.3 Demo – A-1: Drawing a Rectangle Around a Control
1.4 Changing the Tab Order
1.5 Demo – A-2: Changing the Tab Order
1.6 Creating a Grouped Control
1.7 Demo – A-3: Grouping Controls
2.0 Topic B: Adding Graphics
2.1 Add a Graphic to a Form
2.2 Demo – B-1: Adding a Graphic to a Form
2.3 Use an Unbound Object Frame
2.4 Demo – B-2: Embedding a Graphic in an Unbound Object Frame
3.0 Topic C: Adding Calculated Values
3.1 Bind Controls to Calculated Fields
3.2 Demo – C-1: Binding a Control to a Calculated Field
3.3 Create a Calculated Control
3.4 Align Controls on a Form
3.5 Demo – C-2: Creating a Calculated Control
4.0 Topic D: Adding Combo Boxes
4.1 Add a Combo Box to a Form
4.2 Demo – D-1: Adding a Combo Box to a Form
4.3 Modify Combo Box Properties
4.4 Demo – D-2: Modifying the Properties of a Combo Box
5.0 Topic E: Advanced Form Types
5.1 Create a Multiple-item Form
5.2 Demo – E-1: Creating a Multiple-item Form
5.3 A Split Form
5.4 Demo – E-2: Creating a Split Form
5.5 A Datasheet Form
5.6 Demo – E-3: Creating a Datasheet Form
5.7 A Form and Subform
5.8 Demo – E-4: Creating a Subform
5.9 Unit 04 Review
➤ Module 05: Reports and Printing
1.0 Topic A: Customized Headers and Footers
1.1 Report Header
1.2 Add a Report Header
1.3 Demo – A-1: Adding a Report Header
1.4 Report Footer
1.5 Demo – A-2: Adding a Report Footer
1.6 New Formatting Rule Dialog Box
1.7 Demo – A-3: Applying Conditional Formatting
1.8 Set the Keep Together Property
1.9 Demo – A-4: Keeping Parts of a Report on the Same Page
1.10 The Group, Sort, and Total Pane
1.11 Demo – A-5: Adding Controls to Group Footers
1.12 Force a New Page
1.13 Demo – A-6: Forcing a New Page
2.0 Topic B: Calculated Values
2.1 The DateDiff Function
2.2 Using the DateDiff Function
2.3 Demo – B-1: Working with the DateDiff Function
2.4 The IIf Function
2.5 Demo – B-2: Using the IIf Function
3.0 Topic C: Printing
3.1 Printing a Database Object
3.2 Demo – C-1: Printing a Table
3.3 Using the Database Documenter
3.4 Demo – C-2: Printing a Database Document
4.0 Topic D: Labels
4.1 Using the Label Wizard
4.2 Labels in Print Preview
4.3 Demo – D-1: Creating Labels
4.4 Unit 05 Review
➤ Module 06: Charts
1.0 Topic A: Charts in Forms
1.1 Adding a Chart to a Form
1.2 Chart Types
1.3 Demo – A-1: Creating a Chart in a Form
1.4 Naming the X- and Y-axes
1.5 Demo – A-2: Modifying a Chart in a Form
2.0 Topic B: Charts in Reports
2.1 Demo – B-1: Adding a Chart to a Report
2.2 Format a Chart Item
2.3 The Chart Type Dialog Box
2.4 Demo – B-2: Modifying Charts in Reports
2.5 Unit 06 Review
➤ Module 07: PivotTables and PivotCharts
1.0 Topic A: PivotTables
1.1 PivotTable View
1.2 Drop Areas
1.3 Demo – A-1: Examining PivotTable View
1.4 Add Fields to a PivotTable
1.5 Demo – A-2: Adding Fields to a PivotTable
2.0 Topic B: Modifying PivotTables
2.1 Summarize Data
2.2 Demo – B-1: Creating Totals
2.3 Move Fields in a PivotTable
2.4 Demo – B-2: Moving Fields in a PivotTable
2.5 Hide or Show Details
2.6 Demo – B-3: Showing and Hiding Details in a PivotTable
2.7 Change Field Settings
2.8 Demo – B-4: Formatting Fields
3.0 Topic C: PivotCharts
3.1 PivotChart Field Mapping
3.2 A PivotChart
3.3 Demo – C-1: Creating a PivotChart
4.0 Topic D: PivotTable Forms
4.1 Create a PivotTable Form
4.2 Demo – D-1: Creating a PivotTable Form
4.3 Unit 07 Review
4.4 Course Closure
WhatsApp chat