Menu
Use Code
Training95
For CPD & QLS
Use Code
Training90
For Opera PMS
Use Code
Training80
For BTEC, NCFE CACHE
Menu

  • No products in the basket.

Microsoft Access 2013 Beginner to Advanced Training

5( 1 REVIEWS )
423 STUDENTS
ACCREDITED BY
Buy Now

Course Description:

Microsoft Access is the database management system of choice for IT professionals. This course is a comprehensive guide to the programme and offers teaching on the fundamental aspects like setting up tables, manipulating data, reports, mail merges, macros, and much more. This certificate will be a great enhancement to your CV, as it is widely used by businesses.

Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.

What skills will I gain?

  • Generate databases and reports
  • Mail merge
  • Import / export data
  • Advanced form design
  • Data validation
  • Database management

What is the target audience?

  • This course would be suitable for anyone who would like to learn alongside work or childcare
  • This course is suitable for those who work in, or would like to work in, technical roles within the IT industry

How will I be assessed?

  • At the end of the course learners will take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
  • Those who successfully pass this course will be awarded a free e-certificate, and only need to pay £19 for your printed certificate.

What Certification am I going to receive?

If you successfully pass the exam then you will be awarded a Microsoft Access 2013 – Beginner to Advanced certificate.

What careers can I get with this qualification?

With this course, you are able to fulfil various roles, such as:

  • Software Engineer
  • Technical Support
  • Technical Sales
  • Business Analyst
  • Web Developer
  • Software Tester

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

Learners who successfully complete the course will be awarded a Certificate in Microsoft Access 2013 Beginner to Advanced Training by CPD and iAP.

 

Learners who successfully complete the course will be awarded a Certificate in Microsoft Access 2013 Beginner to Advanced Training by CPD and iAP.

 

Course Curriculum Total Units : 64
------------ BEGINNER ------------
1. INTRODUCTION TO ACCESS 2013
Orientation to Microsoft Access
Simple Access Database
Get Help in Microsoft Access
2. TABLE DATA
Modify Table Data
Sort and Filter Records
Create Lookups
3. QUERYING A DATABASE
Join Data from Different Tables in a Query
Sort and Filter Data in a Query
Calculations in a Query
4. ADVANCED QUERIES
Parameter Queries
Action Queries
Unmatched and Duplicate Queries
Summarize Data
5. GENERATING REPORTS
Create a Report
Controls to a Report
6. ENHANCE THE APPEARANCE OF A REPORT
Appearance of a Report
Report for Print
7. THE ACCESS OPTIONS DIALOG BOX
The Access Options Dialog Box
------------ INTERMEDIATE ------------
1. RELATIONAL DATABASE
Relational Database Design
Create a Table – Access
Create Table Relationships
2. JOINING TABLES
Create Query Joins
Join Tables That Have No Common Fields
Relate Data within a Table
Work with Subdatasheets
Create Subqueries
3. ORGANIZING A DATABASE FOR EFFICIENCY
Data Normalization
Create a Junction Table
Improve Table Structure
4. IMPORT AND EXPORT THE DATA
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
5. MAIL MERGE
Create a Mail Merge
6. ADVANCED REPORTING
Organize Report Information
Format Reports
Control Formatting in a Report
Add a Calculated Field to a Report
Subreport to an Existing Report
------------ ADVANCED ------------
1. ADVANCED FORM DESIGN
Create Subforms
Organize Information with Tabs Pages
Navigation of Forms
Conditional Formatting
2. DATA VALIDATION
Field and Record Validation
Form Validation
3. USER INTERFACE DESIGN
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
4. DATA ENTRY USING A MACRO
Automate Data Entry Using a Macro
Convert a Macro to VBA
5. DATABASE MANAGEMENT
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
6. SECURING A DATABASE
Splitting a Database for Multiple User Access
Implement Security
Set Passwords
7. DISTRIBUTING DATABASE
Convert an Access Database to an ACCDE File
Analyze the Performance of a Database
8. SWITCHBOARDS
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options
Mock Exam
Mock Exam : Microsoft Access 2013 – Beginner to Advanced
Final Exam
Exam : Microsoft Access 2013 – Beginner to Advanced
WhatsApp chat