Access

by Indicia Training Claim Listing

This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Indicia Training Logo

img Duration

1 Day

Course Details

Overview:

This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.

 

Introduction to Databases

  • Database concepts

  • Database Layout

  • Launching Access.

  • The Access Menu System

  • Dialog Boxes

  • Getting Help

  • Creating A New Database

  • Creating an Access Web App

  • Closing A Database (Vs Exit Access)

  • Opening A Database

 

Tables

  • Database Design.

  • Creating Tables Using The Table Wizard

  • Creating Tables In The Datasheet View

  • Creating Tables In The Design View

  • Data Types

  • Field Properties

  • Data Display Format Vs Input Mask

  • The Input Mask

  • Data Entry Problems

  • Moving And Copying Records

 

Working with Tables

  • Pasting Records

  • Sorting The Table

  • Deleting A Table

  • Table Layout Changes

  • Find

  • Replace

  • Wildcards

 

Queries

  • The Simple Query Wizard

  • The Design View

  • Modifying The Query

  • Using Basic Criteria

  • Additional Criteria

  • Parameters

  • Multiple Object Queries

  • Custom Calculations In A Query

  • Calculating Fields Continued

  • Grouping Fields

 

Introduction to Reports

  • Reports

  • The Report Wizard

  • Glasgow Branch

    5th Floor, Baltic Chambers, 50 Wellington Street, Glasgow

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy