Mullan Technology
Home Links Contact Us
About Us Tech Used Samples Support Training
Mullan Technology


News
 
Microsoft Access Introduction Training in Belfast Northern Ireland 20 & 21 December OR On your Own Premises - 2 Day Course

17 February 2014
 

Our 2 day Introduction to MS Access course is suitable for complete beginners to Microsoft Access.

 

Navigate through and utilise your database more effectively with Microsoft Access training at Mullan Training

Prerequisites

A working knowledge of Windows is required, or our Introduction to MS Windows course. No experience of MS Access is required.

Benefits

At the end of this course you will have a good working knowledge of MS Access. You will feel more confident using Access, and be able to create a database from scratch.

Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and, ultimately create reports.

After completing this course you will be prepared to attend the Advanced MS Access training course.


Course Content

 

Views Available Within Access

§          Table    

§          Query   

§          Report

§          Form

§          Switch Between Design View and Datasheet View/ Form View/ Preview/ Run

 

 

Create New Database File

§          Why Create a File First

§          Object Naming Rules

 

 

Database Tables – Create

§          Field Names

§          Data Types - corresponding field properties and how they differ according to the data type selected

§          Primary Key Fields

§          Format

§          Caption

§          Required

§          Input Mask

§          Validation rule

§          Indexing

§          Create lookups to standardise data entry

 

 

Database Tables – Manipulate Records

§          Sort Records

§          Delete Records & Fields

§          Use Find & Find And Replace

§          Rename Fields

§          Use The Filter/ Sort Facility  (By Selection, By Form, Advanced Filter/ Sort)

 

 

Define Relationships

§          Establish Relationships (One-Many, One-One)

§          Enforce Referential Integrity

§          Cascade Update/ Delete Related Fields

 

 

Microsoft Access Training wiht Mullan Training in Belfast City Centre

 

 

Forms

§          Why To Use The Form To Input Data

§          Create With And Without The Wizard

§          Form Types -  MultiTable, Columnar, Justified, SubForms

§          Move Labels And Fields Around The Form (Together And As Individual Items)

§          Align Objects, Snap To Grid

§          Adjust “Fineness” Of Grid

§          Adjust The Form Size

§          Select And Move/ Resize Multiple Objects

§          Set Background Fill, Text Colour

§          Sections Of A Form

§          Toolbox (Combo Box, Command Buttons, Drawing Tools, Pointer)

§          Introduce Command Buttons

 

 

Queries

§          Select

§          Parameter

§          CrossTab

§          Summary

§          Incorporate Calculated Fields

 

 

Reports

§          Create Reports Using The Wizard

§          Display Specific Records

§          Sort Records By Specified Fields

§          Apply Page Header/Footer

§          Specify Layout Of The Report

§          Specify Grouping Levels

§          Calculated Fields

§          Create Parameter Report

 

 

Create User Interface

§          How To Create A Database That Will Allow Non-Access Users To Enter/ View Data & Run Reports

§          Create Splash Screen

  §         Use Of The Autoexec Macro & StartUp

 

Please do not hesitate to contact us if you would like to:

  • Discuss course content   OR
  • Have us review your own database(s) prior to your booking or attending
 

 

Discounts on Public Courses

·     held  at Mullan Training suites – opposite Europa hotel

·     full price for 1st delegate  

·     10% reduction  2nd delegate

·     20% for 3rd and subsequent delegates

 
 
Related Links

www.mullantraining.com/courseoutlines/viewdetails.asp?CourseID=11