Have a Question? Call 0800 689 3038 or Click here to email us.
Cart 0
Access 2013 Online Course

Access 2013 Online Course

[ TTAS2013 ]

£48.00

Seen this product cheaper elsewhere?
We'll beat any like-for-like training quote!
CLICK HERE


Course Description

In Access 2013, presenter Cindy Rybaczyk will take you through the basics of customizing the Ribbon and using the Quick Access toolbar, and then explain other topics such as creating a tables using a template, sorting query results, using the Report Wizard. This is training for Microsoft Access 2013 for Windows.

In this Microsoft Access 2013 training course, learn how to use the results-oriented user interface that’s context-sensitive and optimized for efficiency and flexibility. Learn how to create a database, work with tables, and develop queries. Then, learn how to create a form for entering data and run reports.

PACKAGE INCLUDES:

Length of Subscription: 12 Months Online On-Demand Access
Running Time: 2 hrs 14 min
Platform: Windows & MAC OS
Level: Beginner to Advanced
Project Files: Included

 

Learn anytime, anywhere, at home or on the go.

Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices.


Course Outline

Getting Started

  • What you’ll learn in this training
  • Beginning from a template
  • Working with Access objects: tables
  • Working with Access objects: forms part 1
  • Working with Access objects: forms part 2
  • Working with Access objects: reports
  • Working with Access objects: queries


Basics

  • Working with, using, and minimizing the ribbon
  • Customizing the ribbon part 1
  • Customizing the ribbon part 2
  • Resetting ribbon customizations
  • Using the Quick Access toolbar
  • Customizing the Quick Access toolbar
  • Resetting the Quick Access toolbar
  • Using Backstage view
  • Using the navigation pane & shutter bar
  • Finding help in Access
  • Searching for a topic in Access help
  • Creating a PDF


Understanding Content Security

  • Enabling a database that is not trusted
  • Viewing and understanding the Trust Center
  • Defining trusted locations


Creating a Database

  • Creating a new database based on an existing database
  • Creating a database from a template
  • Finding database templates online
  • Beginning a new database from scratch
  • Creating a table in Design View
  • Creating a table by entering data
  • Creating a table by using a template
  • Assigning a Primary Key
  • Assigning multiple Primary Keys
  • Inserting additional fields
  • Deleting existing fields
  • Navigating through a table
  • Adding, editing, and deleting records in a table


Working with a Table

  • Finding data in a table
  • Replacing data in a table
  • Entering data using AutoCorrect
  • Adding to the AutoCorrect collection
  • Using spell check
  • Hiding and unhiding columns
  • Freezing and unfreezing columns
  • Renaming a field
  • Copying a field
  • Changing row height & column width
  • Filtering records in a table
  • Filtering records by form


Creating a Form

  • Creating a simple form
  • Working in layout view part 1
  • Working in layout view part 2
  • Creating a form using the Form Wizard
  • Creating a form from scratch
  • Adding a field to a form
  • Working in design view
  • Using a form for adding, modifying, or deleting records
  • Displaying a form & its data simultaneously


Working with Queries

  • Creating a detail query
  • Creating a summary query
  • Creating a query in design view
  • Creating a multiple table query
  • Adding criteria to a query
  • Using logical operators in queries
  • Sorting query results
  • Finding the top values in a query


Working with Reports

  • Creating a report using the Report Wizard
  • Creating a one click report
  • Creating a report in Design view
  • Creating a report in Layout view
  • Adding a page header and footer
  • Adding a report header and footer

If you'd like a Free Demo of this product then please complete the form here :

Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.


More from this collection