Microsoft Access 2003 Intermediate

Course

In Cardiff

£ 199 + VAT

Description

  • Type

    Course

  • Location

    Cardiff (Wales)

  • Duration

    1 Day

  • Start date

    Different dates available

Highly Experienced Instructor Detailed User-Friendly Manual Pre/Post Course Email Support Refreshments Attendance Certificate

Facilities

Location

Start date

Cardiff
See map
Castle Street, CF10 1SZ

Start date

Different dates availableEnrolment now open

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

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 8 years

Subjects

  • Access
  • Basic
  • IT
  • Basic IT training
  • Database
  • Database training
  • Basic IT
  • Microsoft Access

Course programme

The Knowledge Academy Microsoft Access 2003 Intermediate 1 day course covers the following topics:

Who Should Attend the Course?

This intensive training course will help delegates to build on their basic understanding of Access 2003, in order to produce more comprehensive and robust database applications. Students will get experience in the theory and application of creating a database; creating more complex queries; and enhancing data entry and reporting with forms and reports.

Course Outline

Database Design Basics

Database Normalisation: • The Rules of Normalization
Relating Tables: • One-to-One Relationships • One-to-Many Relationships • Many-to-Many Relationships
Referential Integrity: • Planning Relationships Between Tables • Orphan Records • Cascading Deletes • Cascading Updates

Advanced File Tasks

Using My Computer within Access: • Navigating with My Computer • Performing Basic Tasks with My Computer • Changing Views with My Computer • The My Places Toolbar
Database Management: • Repairing a Database • Compacting a Database • Backing up Your Database • Editing Database Properties
Saving Your Files: • Save As Dialogue • Object Properties • AutoRecover
Exporting Files: • Exporting to Word • Exporting to Excel • Exporting to Older Versions of Access • Exporting vs. Save As
Linking Files: • Linking to an Excel Spreadsheet • Linking to Another Database • Creating a Hyperlink • Inserting an OLE Object

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: • 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: • Adding a Control • The Control Wizard • Cutting, Copying, Pasting, and Moving a Control • Formatting a Control
Advanced Form Controls: • Modifying a Control’s Properties • Changing a Control’s Data Source • Changing a Control’s Default Value • Creating a Calculated Control • Using Form Properties
Formatting a Form: • Formatting Gridlines • Modifying the Font • Adding Images • Using AutoFormat

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 • Adjusting the Layout of your Report • Using AutoFormat
Common Report Tasks: • Adding a Photo • Adjusting Page Properties • Adding Headers and Footers • Adding Page Numbers • The Label Wizard

Working with Queries

Basic Queries: • Review of Queries • Creating a Query • Sorting a Query • Filtering a Query • Hiding Fields • AND/OR Operators • IIF Functions
Multiple Table Queries: • Creating a Multiple Table Query • Creating a Calculated Field • The Expression Builder • Using Queries to Summarize • Make-Table Queries
Management (Action) Queries: • Append Queries • Delete Queries • Update Queries • Exporting Queries

Additional information

  • Official Microsoft Access Training in luxury nationwide venues
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Learn how to use and apply Access by your accredited Microsoft Partner
  • Courses delivered by highly experienced certified Access instructors
  • Competitive pricing and unrivalled choice of course dates
  • All delegates are provided with an official detailed user-friendly manual
  • Includes pre & post course email support
  • Enhance your productivity at work
  • Book Online or Call 01344 203999 to speak to a Learning advisor today

Microsoft Access 2003 Intermediate

£ 199 + VAT