Microsoft Access Intermediate

Short course

In Nantwich

Price on request

Description

  • Type

    Short course

  • Level

    Intermediate

  • Location

    Nantwich

  • Duration

    1 Day

To show users how to improve their Access databases. We will learn how to create more advanced queries, connect to other data sources and design friendlier user interfaces.

Facilities

Location

Start date

Nantwich (Cheshire)
See map
Charles House Princes Court Beam Heath Way, CW5 6PQ

Start date

On request

About this course

Users should be able to do the following within an Access database:-
- Create Tables
- Create simple Select Queries
- Create Forms and Sub Forms

An understanding of database design and relationships is recommended, although this topic is refreshed at the start of this course.

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

  • Microsoft Access

Course programme

Course Outline:

  • Database Design Refresher
  • Designing a database
  • Primary and Foreign Keys
  • Relationships and Referential Integrity

The Lookup Wizard

  • Using the Lookup Wizard
  • Pros and Cons of using Lookups
  • Amending a Lookup

Connecting to Other Data Sources

  • Importing Data
  • Linking Data
  • Connecting to Access Data
  • Connecting to Excel Data
  • Connecting to ODBC Data
  • Splitting a Database

Select Queries

  • Changing a Queries Join type
  • Finding unmatched data
  • Hiding duplicate data
  • Top Values
  • Parameter Queries

Using Functions in Queries

  • Iif() function
  • Date() function
  • DateAdd() function
  • Format() function

Other Queries Techniques

  • Crosstab Queries
  • Provide query parameters from a Form
  • Making a parameter optional

Form Design

  • Changing Form Properties
  • Tab Order
  • Conditional Formatting
  • Creating Switchboards
  • Using Command Buttons
  • Creating Search boxes

Report Design

  • Creating Summary fields
  • Creating Conditional Summaries
  • Using Sub Reports
  • Inserting Charts into Reports
  • Displaying parameters in a report

Microsoft Access Intermediate

Price on request