Microsoft Access 2013 – Intermediate

Provided by

Enquire about this course

About the course

COURSE CURRICULUM

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

Benefits you will gain:

  • 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.

Certification:

Successful candidates will be awarded a certificate in Microsoft Access 2013 – Intermediate.

Who is this course for?
  • 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
Career path
  • Software Engineer
  • Technical Support
  • Technical Sales
  • Business Analyst
  • Web Developer
  • Software Tester

Enquire

Start date Location / delivery
No fixed date Online Book now

Related article

Could you be making CV mistakes that are sabotaging your job search? It’s quite possible, and easily fixed, by addressing these common CV mistakes.