Access 2013

Course

Online

£ 47.15 VAT inc.

*Indicative price

Original amount in USD:

$ 59

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database training
  • Access
  • Database
  • Design
  • Layout
  • Macros
  • Mail Merge
  • Exporting Data
  • PivotTables
  • PivotCharts
  • Databases Access
  • Switchboards

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

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

Additional information

LENGTH

2 hrs 14 mi

Access 2013

£ 47.15 VAT inc.

*Indicative price

Original amount in USD:

$ 59