Awarded By Microsoft

Microsoft Access 2013

Short course

Online

£ 59 VAT inc.

Description

  • Typology

    Short course

  • Methodology

    Online

  • Class hours

    35h

  • Start

    Different dates available

Description

To be successful in today's business world, you must have Microsoft Office skills. Whether you're an office manager, administrative assistant, sales professional or business manager, employing all the powerful features of Microsoft Office will make you more efficient and, later, more commercial. Most jobs in the business world involve office products.

Microsoft Access is a skill worth telling, since this popular database application is used extensively in numerous employment sectors.

Depending on the version of Access you need, we have the ideal course for you; including the most updated version, Microsoft Access 2016 as well as 2013 and 2010. Our training will also help you to take the Microsoft Office Specialist Test (MOS).
This course is designed to provide you with the main skills you will need to master Access, whether in a work or home environment, in the shortest possible time. You do not need to have previous experience in using Microsoft Access, our training in Microsoft Access 2013 covers beginner, intermediate and advanced level training to help you develop the skills you need to progress in your career.

Take advantage now to increase your professional skills! Request more information about this interesting online course in Emagister.

Facilities

Location

Starts

Online

Starts

Different dates availableNow taking bookings

To take into account

Anyone looking to develop their Microsoft Access skills. By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.

Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s. For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

You'll sit an online exam. We provide interactive quizzes after each module to ensure you're fully prepared for the real thing. Once you've passed with at least 80%, you'll be awarded an MTA certificate at no additional cost. If you’re interested in attaining a Microsoft Office Specialist certification, you’ll need to sit an official Microsoft exam at a local test centre. You’ll be able to book your exam as a private candidate.

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Achievements for this centre

This centre has demonstrated its quality on Emagister
4 years with Emagister

Subjects

  • Section Review
  • Setting Passwords
  • Splitting a Database
  • Columns
  • Chart Table
  • Automate Data Entry
  • Restrict Records Displayed
  • Crosstab Query
  • Create Duplicate Queries
  • table structure
  • Data entry
  • Parameter queries
  • Using Wild Cards
  • Action Queries
  • Input Mask
  • Create Lookup Field
  • Validation Rules
  • Contextual Tabs Design
  • Keyboard Shortcuts
  • Adding a Total Row

Course programme

Course Introduction

  • Instructor Introduction
  • Access Overview
  • Course Outline

Section 1: Access Basics

  • Section Overview
  • What Does Access Do?
  • Access Application Window
  • Database Objects
  • Basic Database and Table Management
  • Customizing Access
  • Keyboard Shortcuts
  • Section Review

Section 2: Designing a Database

  • Section Overview
  • Database Design Process
  • Normalizing Data
  • Setting Primary and Foreign Keys
  • Section Review

Section 3: Building a Database

  • Section Overview
  • Creating A New Database
  • Creating Tables
  • Inserting Field's in Tables
  • Setting Up Field Properties
  • Formatting the Datasheet View
  • Creating Relationships
  • Keyboard Shortcuts
  • Section Review

Section 4: Managing Table Data

  • Section Overview
  • Updating and Deleting Records
  • Finding and Replacing Values
  • Adding a Total Row
  • Using Sub-datasheets
  • Sorting Data
  • Filtering Data
  • Keyboard Shortcuts
  • Section Review

Section 5: Creating Selection Queries

  • Section Overview
  • Creating Queries Using the Query Wizard
  • Creating Queries Using the Query Design View
  • Adding Criteria
  • Add Calculated Fields to Query
  • Section Review

Section 6: Creating and Managing Forms

  • Section Overview
  • Form Basics and Creating Forms
  • Contextual Tabs Design and Layout View
  • Managing Table Data with Forms
  • Modifying the Look and Design
  • Design Tab Controls
  • Section Review

Section 7: Creating and Managing Reports

  • Section Overview
  • Creating Reports, Report Views, and Managing Report Sections
  • Adding Calculated Fields and Formatting The Report Controls
  • Section Review

Section 8: Controlling Data Entry

  • Section Overview
  • Setting Field Properties
  • Validation Rules
  • Input Mask
  • Create Lookup Field
  • Section Review

Section 9: Finding and Joining Data

  • Section Overview
  • Inner and Outer Joins
  • Joining Unrelated Tables and Relating Data Within Tables
  • Section Review

Section 10: Creating Flexible Queries

  • Section Overview
  • Select Query Properties
  • Parameter Queries
  • Using Wild Cards
  • Creating Action Queries
  • Section Review

Section 11: Enhancing Forms

  • Section Overview
  • Using the Form Layout View and Improving Form Appearance
  • Restricting Data Entry
  • Command Buttons and Creating Sub forms
  • Section Review

Section 12: Customizing Reports

  • Section Overview
  • Organizing Report Information and Setting Report Control Properties
  • Page Layout and Controlling Pagination
  • Summarize Info and Sub-reports
  • Mailing Labels
  • Section Review

Section 13: Sharing Access Data

  • Section Overview
  • Importing and Exporting Data
  • Sharing Data and Merging Data with Word
  • Section Review

Section 14: Structuring Existing Data

  • Section Overview
  • Analyzing Tables and Junction Tables
  • Improving Table Structure
  • Section Review

Section 15: Writing Table Queries

  • Section Overview
  • Multi Table Query
  • Creating Unmatched Queries
  • Create Duplicate Queries
  • Create Duplicate Queries and Grouping and Summarizing
  • Crosstab Query
  • Creating Pivot tables and Pivot Charts
  • Section Review

Section 16: Using Macros

  • Section Overview
  • Planning and Creating Macros
  • Attach Macros to Command Buttons
  • Restrict Records Displayed Using Where Condition
  • Require Data Entry with Macros
  • Automate Data Entry
  • Section Review

Section 17: Making Forms More Effective

  • Section Overview
  • Form Format Properties
  • Active X Controls and Tabbed Pages
  • Display Pivot Chart Table on Forms
  • Section Review

Section 18: Improving Reports

  • Section Overview
  • Include Chart In Report and Concatenating
  • Arranging Data In Columns, Grouping, and Parameter Reports
  • Report Events and Cancelling a Blank Report from Printing
  • Section Review

Section 19: Creating a Start-up Interface

  • Section Overview
  • Creating and Modifying a DB Switchboard
  • Setting and Modifying Start-up Options
  • Section Review

Section 20: Database Maintenance

  • Section Overview
  • Database Maintenance Tools
  • Section Review

Section 21: Distributing and Securing a Database

  • Section Overview
  • Splitting a Database
  • Implementing Security and Trust centre
  • Setting Passwords
  • Converting Files and Signing with Digital Signatures
  • Section Review

Microsoft Access 2013

£ 59 VAT inc.