Course Description

MS Access 2010 Basics

MS Access 2010 Basics is a course run by 1 Training, Dublin. It is a 'Online Learning' course . For more information about MS Access 2010 Basics at 1 Training, please review the details below.

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

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.

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.

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

The MS Access 2010 Basics course at 1 Training is listed in's national courses finder.
Training Provider1 Training
Course LocationDublin
Course TypeOnline Learning
Course Fee18
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
Carear Path• 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
Phone+44 208 610 9650
For more information about 1 Training, please visit our College page on by clicking here.

Course Provider

1 Training

63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE, Dublin, United Kingdom. Eircode: EC1N 8LE

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to 1 Training

Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the community.


1 Training
63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE
United Kingdom
Visit Website