c2
Connect on:
  • Home
  • Course Centre
    • Project Management >
      • Professional Project Management
      • Project Management Essentials
      • Managing Project Requirements
      • Scheduling & Cost Control Project Managers
      • Project Leadership, Management & Communication
      • Risk Management for Project Managers
      • Negotiation Skills for Project Managers
      • Managing Remote Project Teams
      • Project Quality Management
      • Project Procurement Management
      • Earned Value Management
      • Professional Project Management - Best Practice
      • Professional Project Management - Exam Preparation
      • PRINCE2® Foundation & Practitioner
      • PRINCE2® Overview
    • Agile Project Management Courses >
      • Agile Project Management
      • Using Scrum in organistations
      • Certified ScrumMaster
    • Java >
      • Core Java Programming
      • Advanced Java Programming
      • Java Programming & XML
      • Java Networking
      • Java Virtual Machine (JVM)
      • Java & Java EE Open Source Testing Tools
    • Java Enterprise Edition (EE) >
      • Enterprise Java with Hibernate and Spring
      • Developing Java Web Applications
      • Java & Java EE Open Source Testing Tools
      • Spring Framework Development
    • C/C++ Programming >
      • C Programming Techniques
      • C++ Programming Fundamentals
      • C++ for C Programmers
      • Advanced C++ Programming
      • C++ & STL Design Patterns
      • Object Oriented C++ for Real-time Applications
    • Unix/Linux >
      • Linux Fundamentals
      • Linux Administration Essentials
    • Windows Server Courses >
      • Installing and Configuring Windows Server 2012
      • Windows Server 2008 - Server Administration
      • Configuring Windows Server 2008 Active Directory
    • .NET Courses >
      • ASP.NET MVC 4.0
    • Perl Programming Courses >
      • Perl Programming
      • Advanced Perl Programming
    • Python Programming Courses >
      • Python Programming
    • Database Courses >
      • MySQL for Developers
    • CompTIA >
      • CompTIA Network+
    • Scripting >
      • JavaScript - Introduction
      • JavaScript - Advanced
    • Data Analysis & Design >
      • Data Analysis & Design - Introduction
      • Data Analysis & Design with UML
    • Microsoft Office Courses >
      • Microsoft Word - Introduction
      • Microsoft Word - Intermediate
      • Microsoft Word - Advanced
      • Microsoft Access - Introduction
      • Microsoft Access - Intermediate
      • Microsoft Access - Advanced
      • Microsoft Excel - Introduction
      • Microsoft Excel - Intermediate
      • Microsoft Excel - Advanced
      • Microsoft Excel - Dashboards
      • Microsoft Excel - Macros
      • Microsoft Excel - Expert
      • Microsoft PowerPoint - Level 1
      • Microsoft PowerPoint - Level 2
      • Microsoft PowerPoint - Advanced
      • Microsoft Outlook - Introduction
      • Microsoft Outlook - To Manage Your Time Efficiently
      • Microsoft Project - Introduction
      • Microsoft Project - Advanced
      • Microsoft Publisher - Introduction
      • Microsoft Visio - Introduction
    • Solaris >
      • Solaris 10 Administration
  • Testimonials
  • About
  • Contact

Microsoft Access - Introduction

Course Description

This is a Microsoft Access Introduction course.  The teaching approach contains a mix of lectures, practical and one-to-one work and varies according to the people attending.  For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.

Course Duration

1 day

Course Objectives

On completion of this course delegates should be familiar with the basic features of Microsoft Access. 

Course Content

EXPLORING ACCESS
Databases Overview
Opening an Existing Database
Converting Existing Databases
The Access Window
Using Database Objects
Using the Object Window
Dialog Boxes and Task Panes
Working with Navigation Pane
Exiting Access
Security Warnings

CREATING DATABASE TABLES
Planning Database Tables
Methods for Creating Tables
Creating Tables in Design View
Data Types
Editing Table Structure in Design View
Setting a Primary Key

WORKING WITH DATA IN TABLES
Navigating Fields in Tables
Adding Records
Selecting Entire Records
Editing Records
Saving Records
Deleting Records

SETTING FIELD PROPERTIES
Limiting Field Size
Setting Number Formats
Setting Date/Time Formats
Setting Yes/No Formats
Setting Default Values
Validation Rules
Create a Lookup List Using the Lookup Wizard
Modifying Lookup Properties

USING SIMPLE QUERIES
The Query Wizard
Creating a Query in Design View
Opening a Query
Running a Query
Adding a Table to a Query
Join Types in a Query

MODIFYING QUERY RESULTS
Sorting a Query
Adding Simple Criteria to a Query
Hiding a Field in a Query
Adding New Records and Editing Data in a Query

CREATING BASIC FORMS
Using Form Tools to Create a Form
Using the Form Wizard
Navigating Records in a Form
Printing Records in a Form
Working With Data in a Form

EDITING FORMS AND REPORTS IN LAYOUTS
Moving & Sizing Controls 
Adding & Deleting Controls 

CREATING BASIC REPORTS
Create a Report
Viewing Reports
Printing a Report
Grouping Report Data

CREATING RELATIONSHIPS
Creating a Relationship between Tables
Setting Referential Integrity
Viewing Subdatasheets
Deleting a Relationship

Who should attend?

This is a course with a high level of practical content, aimed at those who have not used Microsoft Access perviously.  It is designed for candidates with widely differing experience and skill levels.

Pre-requisites

No previous experience of Microsoft Access is necessary, but candidates should have a good understanding of computer basics and be familiar with the Windows operating system.
Powered by Create your own unique website with customizable templates.