Enquire Now
Menu
£249 £59 (inc. VAT)

Buy Now

Add To Cart

  • 365 Days
  • ,
  • Course Certificate
  • ACCREDITED BY CPD & iAP
  • 10Guided Learning Hours
  • 21 Number of Modules
  • Course Material
  • Exam Included

What Will I Learn?

Learn the database application which enables you to create and use databases easily
Identify how to store information, query that information, build easy-to-use graphical interfaces, and create reports on the stored data
Learn from qualified trainers who are specialised i the industry
Learn how to easily understand the use of the software
Learn from the fundamentals to the advanced skills which area incorporated in the access 2013 package
Learn the skills essential to help advance your career

Learn the skills you need from Microsoft Access experts

Microsoft Access 2013 is the number one database application in the world and is designed to make databases easier to create and use. It’s essentially used to store a set of information, query that information, build easy-to-use graphical interfaces, and create reports on the stored data.

On this course, provided by Global Edulink who offer the world’s best online education all in one place, you are taken step-by-step through the software by qualified trainers who are specialists in their field. We make it easy for you to understand how to use the software, from the fundamental aspects such as setting up tables, inputting and manipulating table data, and generating reports, through to advanced skills such as carrying out mail merges, entering data using macros, creating and designing forms, and generating queries and reports.

Many businesses use Microsoft Access, from small one-person enterprises to large, multinational corporations, because it’s easy to maintain and requires very little infrastructure to support. Understanding Access is vital to real-world database use and our course will provide you with the skills required to help advance your career.

Begin your learning with us today.

Who is this course aimed at?
  • Those with technical roles within the IT industry
  • Professionals who design and programme system-level software such as database systems, operating systems, and embedded systems
  • Project-based technical analysts and engineers
  • Technical support personnel
Entry requirements
  • This course is available to all students, of all academic backgrounds. However, basic IT skills would be an advantage.
  • Learners should be ages 16 or over to undertake the qualification.
  • Good understanding of English language, numeracy and ICT are required to attend this course.
Certification Successful candidates will be awarded a Certificate in Microsoft Access 2013 Beginner to Advanced Training.
Progression and career path This course will not directly qualify you for any specific job position, however, will be of great benefit for your candidature for a range of job positions in the IT industry. This course can also be the answer to your much anticipated career progression as it enhances your eligibility for the job opportunities provided by your organisation. Given below are few of the job positions this course will help you in, along with the average UK salary per annum according to https://www.payscale.com,

  • Software Engineer – £34,981 per annum
  • Technical Support Engineer – £23,993 per annum
  • Technical Sales  Manager – £35,939 per annum
  • Business Analyst, IT – £35,800 per annum
  • Web Developer – £24,886 per annum
  • Software Tester – £24,559 per annum
Other Benefits
  • High quality e-learning study materials and mock exams.
  • Tutorials/materials from the industry leading experts.
  • 24/7 Access to the Learning Portal.
  • Benefit of applying NUS extra Discount Card.
  • Recognised Accredited Qualification.
  • Excellent customer service and administrative support.

Course Curriculum

------------ beginner ------------
1. introduction to access 2013
Orientation to Microsoft Access 00:46:00
Simple Access Database 00:27:00
Get Help in Microsoft Access 00:04:00
2. table data
Modify Table Data 00:13:00
Sort and Filter Records 00:06:00
Create Lookups 00:15:00
3. querying a database
Join Data from Different Tables in a Query 00:14:00
Sort and Filter Data in a Query 00:19:00
Calculations in a Query 00:10:00
4. advanced queries
Parameter Queries 00:11:00
Action Queries 00:08:00
Unmatched and Duplicate Queries 00:05:00
Summarize Data 00:08:00
5. generating reports
Create a Report 00:10:00
Controls to a Report 00:08:00
6. enhance the appearance of a report
Appearance of a Report 00:05:00
Report for Print 00:03:00
7. the access options dialog box
The Access Options Dialog Box 00:05:00
------------ intermediate ------------
1. relational database
Relational Database Design 00:12:00
Create a Table – Access 00:05:00
Create Table Relationships 00:09:00
2. joining tables
Create Query Joins 00:10:00
Join Tables That Have No Common Fields 00:03:00
Relate Data within a Table 00:05:00
Work with Subdatasheets 00:04:00
Create Subqueries 00:05:00
3. organizing a database for efficiency
Data Normalization 00:13:00
Create a Junction Table 00:06:00
Improve Table Structure 00:03:00
4. import and export the data
Import Data into Access 00:11:00
Export Data to Text File Formats 00:06:00
Export Access Data to Excel 00:03:00
5. mail merge
Create a Mail Merge 00:10:00
6. advanced reporting
Organize Report Information 00:18:00
Format Reports 00:17:00
Control Formatting in a Report 00:03:00
Add a Calculated Field to a Report 00:05:00
Subreport to an Existing Report 00:03:00
------------ advanced ------------
1. advanced form design
Create Subforms 00:03:00
Organize Information with Tabs Pages 00:05:00
Navigation of Forms 00:06:00
Conditional Formatting 00:04:00
2. data validation
Field and Record Validation 00:20:00
Form Validation 00:07:00
3. user interface design
Create a Macro 00:07:00
Restrict Records Using a Condition 00:05:00
Validate Data Using a Macro 00:06:00
4. data entry using a macro
Automate Data Entry Using a Macro 00:06:00
Convert a Macro to VBA 00:04:00
5. database management
Link Tables to External Data Sources 00:04:00
Manage a Database 00:06:00
Determine Object Dependency 00:04:00
Document a Database 00:04:00
Analyze the Performance of a Database 00:03:00
6. securing a database
Splitting a Database for Multiple User Access 00:05:00
Implement Security 00:08:00
Set Passwords 00:06:00
7. distributing database
Convert an Access Database to an ACCDE File 00:07:00
Analyze the Performance of a Database 00:03:00
8. switchboards
Create a Database Switchboard 00:06:00
Modify a Database Switchboard 00:03:00
Set Startup Options 00:03:00
mock exam
Mock Exam: Microsoft Access 2013 – Beginner to Advanced 00:40:00
final exam
Exam: Microsoft Access 2013 – Beginner to Advanced 00:40:00
£249 £59 (inc. VAT)

Buy Now

Add To Cart

  • 365 Days
  • ,
  • Course Certificate
  • ACCREDITED BY CPD & iAP
  • 10Guided Learning Hours
  • 21 Number of Modules
  • Course Material
  • Exam Included

Inquiry Now

  • By submitting your information, you agree to the terms and conditions stated in our privacy policy.
Call Back

1992 STUDENTS ENROLLED

CPD Accredited

Accredited Qualification


sage

Unit Summary


sage

Accredited by CPD & iAP

Awarded by iAP

CPD Accredited

CPD Membership No: 10582

Study independently accredited and recognised CPD courses. Gain your certification today

Buy with Confidence

UKRLP


Build Your CV Here
cv All students enrolled with Global Edulink are entitled to a CV Writing and Interview Skills Pack, which includes CV templates, cover letter guidance, and advice for interviews. MORE INFO
cv If you need career support Global Edulink is here for you. We provide excellent career support through our Career Support Service.
MORE INFO

TOTUM Card


NUS Extra Card Every student of Global Edulink is eligible to apply for a TOTUM card powered byNUS Extra, allowing you to enjoy great saving by top brands on the high-street and online.

Paypal Credit

Smiley face

Course Reviews

5

5
1 ratings
  1. Renold Mareya

    Great Course

    The course exceeded my expectations in many regards — especially in the depth of information supplied.

    5

Popular Courses

Cisco 200-355: CCNA Wireless Network Fundamental WIFUND

Become a handsomely compensated, critical...
  • 365 Days
  • Awarded By 'CISCO'
5
£299 £89 (inc. VAT)

Certificate in Essential Training in Children’s Nutrition and Behaviour

Overview: Children are the next...
  • 365 Days
  • 14Guided Learning Hours
5
£249 £69 (inc. VAT)

FREE Microsoft Excel 2016 – Beginner

Register today and get free...
  • 30 Days
  • CPD & iAP ACCREDITED BY
5
FREE

Level 3 Award in Coaching and Mentoring

Overview Are you seeking to...
  • 365 Days
  • CMI
5
Price Options +
£449 £299 (inc. VAT)
or only £49 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £49.00 (Inc. VAT)
Awarding Body Registration:

£99.00 (Inc. VAT)

Assessment: £159.00 (Inc. VAT)
Total Price: £307.00 (Inc. VAT)

Diploma in Strategic Marketing – Level 3

Overview It is not only...
  • 365 Days
  • Endorsed by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 04 Installments)

Total Price: £238.00 (Inc. VAT)

Diploma In Mastering SPSS Software And Analysis – Level 2

Overview As data has taken...
  • 365 Days
  • Endorsed by 'ABC Awards'
5
Price Options +
£399 £199 (inc. VAT)
or only £59 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £59.00 (Inc. VAT)
Exam Fee : £149.00 (Inc. VAT)
No of Installments: 3
Total Price: £208.00( Inc. VAT)

MoP® Foundation Official Exam

Overview Getting into the portfolio...
  • 365 Days
  • Awarded by 'Axelos'
5
£399 £199 (inc. VAT)

Professional Receptionist Training

Overview As a Receptionist, you...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49 (inc. VAT)

Diploma in Improving Critical Business Skills – Level 3

What does it take to...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£399 £59 (inc. VAT)

Health and Safety at Work

Overview: Certificate in Health and...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49 (inc. VAT)

Diploma in Everyday Budgeting

Overview: Are you having difficulties...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49

Pre-MBA – PEARSON BTEC Level 7 Extended Diploma in Strategic Management and Leadership (RQF)

Are you looking to become...
  • 540 Days
  • Awarded By Pearson (BTEC)
5
Price Options +
£1,999 £1,799 (inc. VAT)
or only £299 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee:£299.00(Inc. VAT)
Awarding Body Registration :

£199.00(Inc. VAT)

Assessment:£1319.00(Inc. VAT)

(Pay in 11 Installments)

Total Price:£1817.00(Inc. VAT)

Diploma in Leadership and Management – Level 3

Overview: Develop your leadership and...
  • 365 Days
  • Endorsed by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £238.00 (Inc. VAT)

Diploma in Banking – Level 3

Overview Develop a strong foundation...
  • 365 Days
  • Endorsed by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £238.00 (Inc. VAT)

CMI Level 3 Certificate in Management and Leadership

Overview Are you a team...
  • 365 Days
  • CMI
5
Price Options +
£499 £299 (inc. VAT)
or only £69 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £69.00 (Inc. VAT)
Awarding Body Registration:

£129.00 (Inc. VAT)

Assessment: £109.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £307.00 (Inc. VAT)

Level 3 Certificate in Teaching Assistant – Child and Young Individual Development

Overview If you love to...
  • 365 Days
  • Endorsed by 'ABC Awards'
5
Price Options +
£349 £129 (inc. VAT)
or only £49 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £49.00 (Inc. VAT)
Assessment: £89.00 (Inc. VAT)

(Pay in 05 Installments)

Total Price: £138.00 (Inc. VAT)

Fashion and Styling

Do you have a passion...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£249 £59 (inc. VAT)

Wedding Planning and Business

Who doesn’t love a wedding? The...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£249 £59 (inc. VAT)

Mastering Business Mathematics

Become Business Maths Savvy This...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49 (inc. VAT)

Advanced Diploma in Business Administration – Level 3

Overview Do you want to...
  • 365 Days
  • Endorsed by 'ABC AWARDS'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £238.00 (Inc. VAT)

COSHH – Level 2

Overview The COSHH - Level...
  • 365 Days
  • Awarded by 'CIEH'
5
£119 £28 (inc. VAT)

Diploma in Diabetes and Children and Young People – Level 3

Overview Diabetes refer to the...
  • 365 Days
  • Endorsed by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 03 Installments)

Total Price: £238.00 (Inc. VAT)

PRINCE2 Agile® Foundation Official Exam

Overview Get started with this...
  • 365 Days
  • Awarded by 'Axelos'
5
£399 £199 (inc. VAT)

Diploma in Social Media & Business Strategy

Overview: Social media is a...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£399 £199 (inc. VAT)

Teacher Training with Technology

Become a super-effective, influential educator...
  • 365 Days
  • 04Guided Learning Hours
5
£249 £59 (inc. VAT)

Advanced Diploma in Wedding Planning – Level 3

Overview: The wedding planning industry...
  • 365 Days
  • Endorsed by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 03 Installments)

Total Price: £238.00 (Inc. VAT)

Level 3 Certificate in Coaching and Mentoring

Overview The Level 3 Certificate...
  • 365 Days
  • CMI
5
Price Options +
£749 £449 (inc. VAT)
or only £69 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £69.00 (Inc. VAT)
Awarding Body Registration:

£139.00 (Inc. VAT)

Assessment: £249.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £457.00 (Inc. VAT)

Diploma In Systems Analysis And Design – Level 4

Overview Systems analysis and design...
  • 365 Days
  • Endorsed by 'ABC Awards'
5
Price Options +
£469 £269 (inc. VAT)
or only £99 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £99.00 (Inc. VAT)
Assessment: £179.00 (Inc. VAT)

(Pay in 03 Installments)

Total Price: £278.00 (Inc. VAT)

Diploma in Teaching Assistant – Level 2

Overview If you love working...
  • 365 Days
  • Endorsed by 'ABC Awards'
5
Price Options +
£399 £199 (inc. VAT)
or only £59 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £59.00 (Inc. VAT)
Assessment: £149.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £208.00 (Inc. VAT)

Complete Cisco Networking Course Bundle

Overview: Certifications such as this...
  • 365 Days
  • Awarded by "CISCO"
5
Price Options +
£799 £149 (inc. VAT)
or only £33 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Deposit: £33.00
Monthly: £29.00
No of Installments: 4
Total Price: £119.00( Inc. VAT)
Load More
WhatsApp chat