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 - Intermediate

Course Description

This is a Microsoft Access Intermediate 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

Building on a delegates basic knowledge of Microsoft Access, this course intoruces delegates to more advanced topics such as security, relationships, forms, reports and macros.

Course Content

TABLES
Applying and modifying data types
Modifying column data types
Formatting Text data type
Formatting Hyperlink data type
Formatting Currency data type
Formatting Date/Time data type
Database object naming conventions
Converting between data types
Changing a field to a different data type
Creating and editing a lookup in a field or column
Creating a lookup from values in a table or query
Creating a lookup from values you type in
Creating a validation rule within a field
Creating an input mask in a field
Setting a required field

RELATIONSHIPS
Creating a relationship
Deleting a relationship
Creating a one-to-one relationship
Creating a one-to-many relationship
Creating many-to-many relationships
Applying an inner join
Applying an outer join
Setting referential integrity
Setting cascading options
 
QUERIES
Enabling the content
Creating and using a query to update data in a table
Creating an Update Query
Creating a Delete Query
Creating a Make-Table Query
Creating an Append Query
Using Aggregate Functions
Summing column values using the SUM function
Averaging column values using the AVG function
Finding maximum column values using the MAX function
Using wildcards as parameters
Creating an arithmetic calculation within a query
Finding duplicates using the Find Duplicates Query Wizard
Creating a parameter query
Finding Null values

FORMS
Creating an unbound control
Creating a bound control
Creating a form header and footer area
Numbering a form page
Adding a subform to a form
 
REPORTS
Placing a control on a report
Creating an arithmetic control
Using common functions in a report
Concatenating (combining) values within an expression
Creating page headers and footers
Creating report headers and footers
Grouping records on a report
Forcing page 

USING MACROS
Creating a new macro
Running a macro
Attaching a macro to a form control

IMPORTING, EXPORTING AND LINKING DATA

Importing from an Excel spreadsheet
Exporting data to a text file
Exporting data as an Excel spreadsheet file
Linking external data to a database
Linking to an Excel worksheet

Who should attend?

Aimed at those people who wish to take themselves one step further in the use of Microsoft Access.  This course provides candidates with practical experience of the topics listed in the course outline.  On completion, candidates should have an excellent knowledge of basic concepts and a working knowledge of some advanced features.

Pre-requisites

Those attending should have good understanding of Microsoft Access to an introductory level, be competent Windows users and be familiar with the basics of file and disk management.
Powered by Create your own unique website with customizable templates.