Microsoft Access 2013 Level 1 - DAC13L1

In this course, you will learn how to use Access 2013 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. For others, data management may consist of an incidental job responsibility, such as time reporting or recording a sale.

A relational database application such as Microsoft Access 2013 can help you and your organisation collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool, or you can use it as a construction set to develop applications for an entire department or organisation.

Target Audience:

The target students for this course are delegates who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.

Outline

Lesson 1: Getting Started with Access

  • Topic A: Orientation to Microsoft Access
  • Topic B: Create a Simple Access Database
  • Topic C: Get Help in Microsoft Access

Lesson 2: Working with Table Data

  • Topic A: Modify Table Data
  • Topic B: Sort and Filter Records
  • Topic C: Create Lookups

Lesson 3: Querying a Database

  • Topic A: Join Data from Different Tables in a Query
  • Topic B: Sort and Filter Data in a Query
  • Topic C: Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

  • Topic A: Create Parameter Queries
  • Topic B: Create Action Queries
  • Topic C: Create Unmatched and Duplicate Queries
  • Topic D: Summarise Data

Lesson 5: Generating Reports

  • Topic A: Create a Report
  • Topic B: Add Controls to a Report
  • Topic C: Enhance the Appearance of a Report
  • Topic D: Prepare a Report for Print

Lesson 6: Customising the Access Environment

  • Topic A: The Access Options Dialog Box

  • Pricing / Dates / Locations available on request

  • Please call us on 01285 711200
    Email: info@connect2courses.com
    Enquire below:

Course Information

  • Use a mouse
  • Type and use a keyboard
  • Navigate through Windows files and folders
  • Work with Windows - minimise, maximise, open and close

At the end of this course you will be able to:

  • Identify the basic components of an Access database
  • Build the structure of a database
  • Manage data in tables
  • Query a database
  • Generate reports
  • Customise the Access environment

Enquire about this course

Please leave this field blank: