Course Description

Microsoft Access 2013 Advanced Course Online

Microsoft Access 2013 Advanced Course Online is a course run by 1 Training, Dublin. It is a 'Online Learning' course . For more information about Microsoft Access 2013 Advanced Course Online at 1 Training, please review the details below.

Microsoft Access 2013 Advanced Course Online


The Microsoft Access 2013 Advanced course is a hands-on course for advanced learners to gain an understanding of how to construct advanced queries, record handling, complex data retrieval and how to use pivot charts and pivot tables. Individuals will learn how to use macros in Access and automate tasks, connect macros to forms and tables and add controls to receive targeted results and layouts. The course is a core skill of Microsoft

The Microsoft Access 2013 Advanced course will help learners participate in basic and intermediate levels of a database and understand the advanced potential of the application. Learners will be able to view, extract and organise using advanced data management skills.

The Microsoft Access 2013 Advanced course will give you an understanding of how data can be related and reported, and how to import, export and link data. 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 2013 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

  • Understand how to create and normalise a database
  • Gain an understanding of Primary Keys and Relationships
  • Learn how to work with Dates in a Query
  • Learn how to create relationships between database Tables
  • Learn how to optimise a database and improve network performance

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 want to gain an advanced understanding of Access.
  • Students looking to improve their skills in Microsoft Office Access 2013.
  • The course is ideal for individuals like an office manager and professionals working in an office environment.
  • Anyone interested in developing their skills in Microsoft Office Access 2013.

Method of Assessment

At the end of the Microsoft Access 2013 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 2013 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.

Course Curriculum Total Units : 78
➤ Module 01 – Implementing Advanced Form Design
Course Introduction
1.0 Topic A: Add Controls to Forms
1.1 Types of Controls
1.2 Other Elements
1.3 The Original frmInventory View
1.4 The frmInventory Target Layout
1.5 Styling Elements
1.6 Demo 1-1: Changing the Tab Order on a Form
2.0 Topic B: Create Subforms
2.1 Subforms
2.2 Demo 1-2: Creating a Subform
3.0 Topic C: Organize Information with Tabs Pages
4.0 Topic D: Enhance Navigation of Forms
4.1 Demo 1-4: Creating a Navigation Form
5.0 Topic E: Apply Conditional Formatting
5.1 Demo 1-5: Changing the Display of Data Conditionally
5.2 Lesson 01 Review

➤ Module 02 – Using Data Validation
1.0 Topic A: Field and Record Validation
2.0 Topic B: Form Validation
2.1 Selecting the Type of Combo Box for a Form
2.2 Controls – List Box and Option Group
2.3 Demo 2-2: Using a Combo Box Control to Limit Option Values
2.4 Lesson 02 Review

➤ Module 03 – Using Macros to Improve UI Design
1.0 Topic A: Create a Macro
1.1 Macros
1.2 The Macro Builder Window and Action Catalog
1.3 Macro Actions and Positioning Arrows
1.4 Types of Macro Actions
1.5 Event Options Form Field
1.6 Macro Event Groups
1.7 Events and Supported Controls
1.8 Demo 3-1: Creating a Macro to Open a New Record on a Form
2.0 Topic B: Restrict Records Using a Condition
2.1 The OpenForm Macro Action with Where Condition
2.2 Demo 3-2: Using the Where Condition to Restrict Data
3.0 Topic C: Validate Data Using a Macro
3.1 Validate Data Using a Macro
3.2 Demo 3-3: Using a Macro to Validate Data
4.0 Topic D: Automate Data Entry Using a Macro
4.1 Event Properties for Automating Data Entry
4.2 Demo 3-4: Automating Data Entry with a Macro
5.0 Topic E: Convert a Macro to VBA
5.1 Macros and VBA
5.2 Demo 3-5: Converting a Macro to VBA
5.3 Lesson 03 Review

➤ Module 04 – Using Advanced Database Mgmt
1.0 Topic A: Link Tables to External Data Sources
1.1 External Data Sources
1.2 Demo 4-1: Using an External Data Source
2.0 Topic B: Manage a Database
2.1 Modes to Open a Database
2.2 Maintaining a Database
2.3 Demo 4-2: Compacting and Repairing a Database
3.0 Topic C: Determine Object Dependency
3.1 The Object Dependencies Pane
3.2 Demo 4-3: Viewing Object Dependency
4.0 Topic D: Document a Database
4.1 Database Documenter
4.2 Demo 4-4: Using the Database Documenter
5.0 Topic E: Analyze the Performance of a Database
5.1 Analysis Results
5.2 Demo 4-5: Using the Performance Analyzer
5.3 Lesson 04 Review

➤ Module 05 – Distributing and Securing a Database
1.0 Topic A: Splitting a Database for Multiple User Access
1.1 Viewing Tables in a Split Database
1.2 Demo 5-1: Splitting a Database
2.0 Topic B: Implement Security
2.1 The Message Bar
2.2 Implementing Security
2.3 The Trust Center Dialog Box
2.4 Demo 5-2: Adding a Trusted Location
3.0 Topic C: Set Passwords
3.1 Password Guidelines
3.2 Demo 5-3: Setting a Database Password
4.0 Topic D: Convert an Access Database to an ACCDE File
4.1 ACCDE File Format
4.2 Creating an ACCDE File
4.3 Quick Start Database Templates Menu
4.4 Template Customization
4.5 Saving Your Database as a Template
4.6 Demo 5-4: Converting a Database to ACCDE Format
5.0 Topic E: Package a Database with a Digital Signature
5.1 Packaging a Database with Digital Signatures
5.2 Package and Sign
5.3 Certificates
5.4 Lesson 05 Review

➤ Module 06 – Managing Switchboards
1.0 Topic A: Create a Database Switchboard
1.1 The Switchboard Manager’s Initial Message
1.2 The Switchboard Manager’s Main Screen
1.3 Demo 6-1: Creating a Simple Switchboard
2.0 Topic B: Modify a Database Switchboard
2.1 Demo 6-2: Modifying a Switchboard
3.0 Topic C: Set Startup Options
3.1 Startup Options for the Current Database
3.2 Error Checking Options
3.3 Demo 6-3: Setting Startup Options
3.4 Lesson 06 Review
3.5 Course Closure

The Microsoft Access 2013 Advanced Course Online 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 • Office Manager – £24,073 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