Easter special sale Get up to 45% OFF until 10th Aprsee the offers

  • No products in the basket.

MS Access 2010 Basics

4.5( 4 REVIEWS )
MS Access 2010 Basics


If you’ve used or learned an earlier version of Access, the Microsoft Access 2010 Basic course will show learners how to use the newest version.  The course is perfect for users with basic knowledge of Access and will help them build on the introduction they’ve already had to the application. It is hands-on training and how to be more interactive with Access and use dialog boxes and more controls. Individuals will learn how to work in an Access environment, how a database works, how to move around in tables and other Access objects and how to preview and print tables and forms. Getting certified in Microsoft Access 2010 Basic will give individuals the opportunity to showcase their core skills to potential employees as this is a popular Microsoft application.

The Microsoft Access 2010 Basic course will help learners understand database concepts, exploring tables, forms and queries, creating database from templates and how to manually create databases and tables.

The Access 2010 Basic course will give you an understanding of how to create relationships between tables, change the look and arrangement of forms and sort information in tables.  The course will help learners become proficient at using Access 2010 in both their business and personal setting. 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 Basic.

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 use Access 2010 to build a database
  • Increase your productivity with Access tables
  • Gain an understanding of fields, forms and reports
  • Find out the new features of Access 2010
  • Expand your office skills

Course Titles

  • Module 01: Getting Started
  • Module 02: Databases and Tables
  • Module 03: Fields and Records
  • Module 04: Data Entry Rules
  • Module 05: Basic Queries
  • Module 06: Using Forms
  • Module 07: Working with Reports

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 basic knowledge of Access 2010.
  • Students looking to expand their skills in Microsoft Office Access 2010.
  • The course is ideal for individuals working as web developers and analysts.
  • 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 Basic 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 Basic.

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 Basic you will be qualified to work in the following positions. The Microsoft Access 2010 Basic 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 : 180
➤ Module 01: Getting Started
Course Introduction
1.0 Topic A: Database Concepts
1.1 Database Components
1.2 Relational Database
2.0 Topic B: Exploring the Access Environment
2.1 The Access Environment
2.2 Demo – B-1: Starting Access and Examining the Access Window
2.3 Opening Databases
2.4 Demo – B-2: Opening a Database
2.5 The Navigation Pane and Menu
2.6 Demo – B-3: Using the Navigation Pane
2.7 Open a Database Table
2.8 Demo – B-4: Examining a Database Table
3.0 Topic C: Getting Help
3.1 Access Help Online
3.2 Access Help Offline
3.3 Demo – C-1: Using Help
3.4 Unit 01 Review
➤ Module 02: Databases and Tables
1.0 Topic A: Planning and Designing Databases
1.1 Planning a Database
1.2 Rules for Names
1.3 Using a Database Template
1.4 Demo – A-2: Creating a Database from a Template
1.5 Creating a Blank Database
1.6 Demo – A-3: Creating a Blank Database
2.0 Topic B: Exploring Tables
2.1 Views for Tables
2.2 Datasheet View
2.3 Demo – B-2: Examining a Table in Datasheet View
2.4 Navigating in Datasheet View
2.5 The Record Selector
2.6 Demo – B-3: Navigating a Table in Datasheet View
2.7 Table in Design View
2.8 Demo – B-4: Examining a Table in Design View
3.0 Topic C: Creating Tables
3.1 Demo – C-1: Creating a Table from a Table Template
3.2 Creating Tables in Design View
3.3 Demo – C-2: Creating a Table in Design View
3.4 Demo – C-3: Adding Fields and Descriptions to a Table
3.5 Setting the Primary Key
3.6 Demo – C-4: Setting the Primary Key
3.7 The Save as Dialog Box
3.8 Demo – C-5: Saving the Table
3.9 Adding a Record
3.10 Demo – C-6: Adding a Record
3.11 The Paste Table as Dialog Box
3.12 Demo – C-7: Copying, Modifying, and Deleting a Table
3.13 A Composite Key
3.14 Demo – C-8: Creating a Composite Key
3.15 Demo – C-9: Using the Data Type Gallery
3.16 Unit 02 Review
➤ Module 03: Fields and Records
1.0 Topic A: Changing the Design of a Table
1.1 Ineffective Field Names
1.2 Demo – A-1: Modifying Field Names
1.3 Selecting a Field
1.4 Deleting and Inserting Fields
1.5 Demo – A-2: Deleting and Inserting Fields
1.6 Moving a Field
1.7 Demo – A-3: Moving a Field
1.8 Using the Attachment Data Type
1.9 The Attachments Dialog Box
1.10 Demo – A-4: Using the Attachment Data Type
1.11 Demo – A-5: Adding a Totals Row
2.0 Topic B: Finding and Editing Records
2.1 The Find and Replace Dialog Box
2.2 Demo – B-1: Finding and Replacing a Value
2.3 Undoing Changes
2.4 Demo – B-2: Undoing Changes
3.0 Topic C: Organizing Records
3.1 Sorting Records by a Single Field
3.2 Demo – C-1: Sorting Records by a Single Field
3.3 Sorting Records by Multiple Fields
3.4 Demo – C-2: Sorting Records by Multiple Fields
3.5 Filter by Selection
3.6 Filter from the Shortcut Menu
3.7 Demo – C-3: Using Filter by Selection
3.8 Filter by Form
3.9 Demo – C-4: Using Filter by Form
3.10 Filter Excluding Selection
3.11 Demo – C-5: Using Filter Excluding Selection
3.12 Advanced Filter/Sort
3.13 Demo – C-6: Using Advanced Filter/Sort
3.14 Deleting Records
3.15 Demo – C-7: Deleting a Record
3.16 Unit 03 Review
➤ Module 04: Data Entry Rules
1.0 Topic A: Setting Field Properties
1.1 Field Properties
1.2 Setting the Required Property
1.3 Demo – A-1: Setting the Required Property
1.4 Allow Zero Length Property
1.5 Demo – A-2: Using the Allow Zero Length Property
1.6 Field Size Property
1.7 Demo – A-3: Setting the Field Size Property
1.8 Append Only Property
1.9 The History Dialog Box
1.10 Demo – A-4: Setting the Append Only Property
2.0 Topic B: Working with Input Masks
2.1 Input Mask Definition: Sections
2.2 Creating an Input Mask
2.3 Demo – B-1: Creating an Input Mask
2.4 Using the Input Mask Wizard
2.5 Demo – B-2: Working with the Input Mask Wizard
3.0 Topic C: Setting Validation Rules
3.1 Creating a Validation Rule
3.2 Demo – C-1: Creating Validation Rules
3.3 Setting Validation Text
3.4 Demo – C-2: Setting Validation Text
3.5 Unit 04 Review
➤ Module 05: Basic Queries
1.0 Topic A: Creating and Using Queries
1.1 Queries
1.2 The Simple Query Wizard
1.3 Demo – A-2: Using the Query Wizard
1.4 Creating Queries in Design View
1.5 Demo – A-3: Creating a Query in Design View
1.6 Saving and Running a Query
1.7 Demo – A-4: Saving and Running the Query
1.8 Sorting Query Results
1.9 Demo – A-5: Sorting Query Results
1.10 Filtering Query Results
1.11 Demo – A-6: Filtering a Query by Adding Criteria
1.12 Creating Queries from Filters
1.13 Demo – A-7: Creating a Query from a Filter
2.0 Topic B: Modifying Query Results and Queries
2.1 Editing Records in Query Results
2.2 Demo – B-1: Editing Query Results
2.3 Modifying the Query Design
2.4 Demo – B-2: Adding Fields to a Query
2.5 Searching for Null Values
2.6 Demo – B-3: Finding Records with Empty Fields
3.0 Topic C: Performing Operations in Queries
3.1 Using Comparison Operators
3.2 Demo – C-1: Using Comparison Operators
3.3 Using the OR Condition
3.4 Demo – C-2: Using the OR Condition
3.5 Using the AND Condition
3.6 Demo – C-3: Using the AND Condition
3.7 Wildcard Operators
3.8 Demo – C-4: Using the * Wildcard
3.9 Using Calculations
3.10 Demo – C-5: Using Calculations in a Query
3.11 Totaling a Group of Records
3.12 Demo – C-6: Totaling a Group of Records
3.13 Avg and Count Functions
3.14 Demo – C-7: Use the Avg / Count Functions
3.15 Demo – C-8: Use the Min and Max Functions
3.16 Unit 05 Review
➤ Module 06: Using Forms
1.0 Topic A: Creating Forms
1.1 A Sample Form
1.2 A Form in Design View
1.3 Form Tools on the Design Tab
1.4 Form Tools on the Arrange Tab
1.5 Form Tools on the Format Tab
1.6 Demo – A-1: Examining a Form
1.7 Using the Form Button
1.8 A Basic Form
1.9 Demo – A-2: Creating a Basic Form
1.10 The Form Wizard
1.11 Demo – A-3: Creating a Form by Using the Form Wizard
2.0 Topic B: Using Design View
2.1 Creating Forms in Design View
2.2 Demo – B-1: Creating a Form in Design View
2.3 Adding a Control
2.4 Demo – B-2: Adding Controls
2.5 A Property Sheet
2.6 Modifying Section Properties
2.7 Demo – B-3: Modifying Properties
2.8 Conditional Formatting
2.9 Demo – B-4: Applying Conditional Formatting
3.0 Topic C: Sorting and Filtering Records
3.1 Sorting Records
3.2 Demo – C-1: Using a Form to Sort Records
3.3 Filtering Records
3.4 Demo – C-2: Using a Form to Filter Records
3.5 Unit 06 Review
➤ Module 07: Working with Reports
1.0 Topic A: Creating Reports
1.1 Print Preview
1.2 Demo – A-1: Examining a Report
1.3 Basic Reports
1.4 Demo – A-2: Creating a Basic Report
1.5 Using the Report Wizard
1.6 Sample Report Preview
1.7 Demo – A-3: Creating a Report by Using the Report Wizard
1.8 Sections in Design View
1.9 Demo – A-4: Creating a Report in Design View
2.0 Topic B: Modifying and Printing Reports
2.1 Modifying Reports
2.2 Demo – B-1: Modifying a Report in Design View
2.3 Layout View
2.4 Demo – B-2: Modifying a Report in Layout View
2.5 Grouping Records in a Report
2.6 Group, Sort, and Total Pane
2.7 Demo – B-3: Grouping, Sorting, and Filtering a Report
2.8 Adding Summary Fields
2.9 Summary Options Dialog Box
2.10 Demo – B-4: Adding Summary Fields by Using the Report Wizard
2.11 Modifying Report Layout and Style
2.12 Demo – B-5: Modifying the Layout and Style of a Report
2.13 The Print Preview Tab
2.14 Demo – B-6: Print a Report
2.15 Unit 07 Review
2.16 Course Closure
WhatsApp chat