Back to Courses

Microsoft Access 2013 Training Course Intermediate

Training by Computer Tutoring Ltd

Enquire Now

On-Site / Training

Inquire to Request Schedule

GBP 340.00

Enquire Book Now

RESPONSE RATE

Details
Outline
About the Provider

Book Now

Enquire

Details

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.

Outline

Designing a Relational Database Access 2013

Relational Database Design
Create a Table
Create Table Relationships

Use Microsoft Access to Join Tables

Create Query Joins
Join Tables That Have No Common Fields with Access 2013
Relate Data within a Table
Work with Subdatasheets
Create Subqueries

Organising a Database for Efficiency

Data Normalization
Create a Junction Table
Improve Table Structure

Sharing Data Across Applications

Import Data into Access
Export Data to Text File Formats
Export Access Data to a Spreadsheet
Create a Mail Merge

Advanced Reporting

Organize Report Information
Format Reports
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report

Reviews

Be the first to write a review about this course.

Write a Review

For over 13 years Computer Tutoring have trained a wide range of web design, Microsoft and Adobe courses to individuals and businesses across London and East Anglia. Approachable and experienced trainers can help you to boost your confidence and enjoy learning.

To accommodate busy companies, Computer Tutoring can tailor the training so that the maximum benefit is felt in the shortest amount of time. For instance if a company would like help on how to transform their Adobe Photoshop images for use on their website, plus they need to alter an Adobe InDesign file and ensure that it is polished ready to go to print then we can combine the two. If you are not sure then just ask. An experienced Computer Tutoring Trainer can give you a no obligation call to discuss.

Computer Tutoring has trained people from many different companies / organisations. Clients have included: Argos. Walkers. Bokomo Foods. Home-Start UK. Smurfit Kappa. John West Foods. Europa Components. Humberside Airport. The Walt Disney Company. Royal Society of Chemistry. Many testimonials are listed on the Computer Tutoring website.

View Complete Profile

Office Application & Computer System Office Application & Computer System Human Resources