Microsoft Access 2007 - Level 2

Progressive Training & Development

Short course

In Southwark

Price on request

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Location

    Southwark

  • Duration

    1 Day

This course takes you deeper into each of the Access objects. You learn about table relationships, queries that perform an action, and look a little more closely at some of the form and report functionalities.

Facilities

Location

Start date

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

About this course

Must have attended Access Level 1,
or be confident with what tables, queries, forms and reports
are, as well as using wizards to create each object.

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

DESCRIPTION
This course takes you deeper into each of the Access objects. You learn about table relationships, queries that perform an action, and look a little more closely at some of the form and report functionalities.

PREREQUISITES
Must have attended Access Level 1, or be confident with what tables, queries, forms and reports are, as well as using wizards to create each object.


ADVANCED FILE TASKS
  • Using My Computer within Access
  • Database Management
  • Saving Your Files
  • Exporting Files

    • Exporting to PDF or XPS
    • Exporting to Word or Excel
    • Exporting to Other Destinations
    • Using Saved Exports
    • Exporting to a CAB File
    • Exporting to Older Versions of Access

  • Linking Files

    • Linking to an Excel Spreadsheet
    • Linking to Another Database
    • Linking to a SharePoint Site
    • Other Types of Linked Documents
    • Creating a Hyperlink
WORKING WITH TABLES
  • Customizing Tables

    • Understanding Field Properties
    • Adding a Primary Key to a Table
    • Indexing a Field
    • Inserting, Deleting, and Moving Fields
    • Importing a Table from another Source

  • Formatting Tables

    • Formatting Number Fields
    • Formatting Text Fields
    • Adding Field Descriptions
    • Changing Field Data Types
    • Adding Captions

  • Controlling Table Data Entry

    • Setting a Default Value
    • Setting a Required Value
    • Creating and Using Input Masks
    • Creating and Removing Table Relationships

  • Managing Table Data Entry

    • Using the Table Design Tab
    • How to Validate Data
    • Creating a Lookup Field
    • Modifying a Lookup Field
    • Creating a Value List
    • Modifying a Value List
WORKING WITH FORMS
  • Basic Form Controls
  • Advanced Form Controls
  • Formatting Your Form
    • Formatting Gridlines
    • Modifying the Font
    • Adding Logos
    • Changing the Layout

  • Formatting Controls
  • Formatting Records
WORKING WITH REPORTS
  • Organizing Report Data
    • Adding and Removing Fields
    • Using Report Sections
    • Changing Section Properties
    • Grouping and Sorting in a Report
    • Changing Group Properties
    • Using Calculated Controls in a Report

  • Formatting Reports
    • Formatting Gridlines
    • Modifying the Font
    • Adding Logos
    • Changing the Layout
    • Using AutoFormat

  • Common Report Tasks

    • Adding a Photo
    • Adjusting Page Properties
    • Adding Headers and Footers
    • Adding Page Numbers
    • Using the Label Wizard
WORKING WITH QUERIES
  • Basic Queries
    • Review of Queries
    • Creating a Query
    • Sorting a Query
    • Filtering a Query
    • Hiding Fields
    • Using AND OR Operators
    • Use of IIF Functions

  • Multiple Table Queries
    • Creating a Multiple Table Query
    • Creating a Calculated Field
    • Using the Expression Builder
    • Using Queries to Summarize

  • Advanced Queries
    • Creating a Parameter Query
    • Using Parameter Queries
    • Creating Crosstab Queries
    • Using Crosstab Queries
    • Using Make-Table Queries

  • Management (Action) Queries
    • Append Queries
    • Delete Queries
    • Update Queries
    • Exporting Queries

See related categories

Microsoft Access 2007 - Level 2

Price on request

The best Access courses

See all

See all