Getting Started with Microsoft Access

Who is this course for?

This course presumes no prior knowledge. It will benefit you if you are new to databases and want to learn how to build databases, design tables, forms, queries and reports or if you are self-taught and want to fill in the gaps.

What are the benefits

This practical “hands-on” 2 day course is designed to provide you with a thorough understanding of database design. This foundation course begins with the basics and builds step by step knowledge. On completion of this course, you will understand and be able to use the design techniques involved in building a database, creating tables, input forms, extracting data and creating basic reports.

Course Video

Enquire about this course

Course Enquiry

Please type your full name.
Invalid email address.
Invalid email address.
Invalid Input

Course Duration

2 Days

Course Content

Introduction to Databases

  • Getting started with Access
  • Database concepts and terminology
  • Flat file database v relational database
  • Ground rules for database design
  • Getting started in Access
  • Getting help

Table Design

  • Manually creating Tables in Design View
  • Creating Tables in Datasheet View
  • The Table Wizard
  • Sorting Fields
  • Modifying the Table structure
  • Data types
  • Indexes
  • Default values
  • Data Validation rules
  • Input masks

Tables and Data

  • Adding and editing data
  • Navigating, adding, editing and deleting records
  • Finding and replacing data
  • Sorting and filtering records
  • Filtering by selection
  • Importing and exporting Data
  • Freezing and unfreezing columns
  • Finding and replacing data
  • Using Wildcards

Relationships

  • Relational database concepts
  • Relational database design
  • Creating relationships
  • Database integrity and validation
  • Adding Primary Keys

Queries

  • Creating select queries
  • Working with the Query Wizard
  • The Query Design View
  • Setting Criteria
  • Refining the results of a query
  • Multiple table queries
  • Parameter queries 

Form Design

  • Introduction to Form Design
  • Form Wizards
  • The Toolbox controls
  • Creating Main and sub forms 

Reports and Printing

  • The Report Wizard
  • Previewing and printing reports

Importing, Exporting and Linking Objects

  • Importing Access objects
  • Exporting Access objects
  • Linking Access objects

What our users say

 

  • A very good course, trainer had good knowledge and delivered well
  • I like the fact that you have selected topics/functions on the basis of their interest/possible use - course is much more than pertinent and a better use of time
  • Very friendly and helpful trainer
  • Ray is the only IT Trainer who has ever inspired me with enough confidence to learn effectively
  • It was very good, I really enjoyed it and learnt a lot
  • I will definitely use the Pivot Tables at work in the future! Thank you for such a great training day!
  • Will ensure my team all attend (they all work remotely)
  • Exactly what I was hoping to learn, thanks

  • Contact Us
  • 44 (0) 208 681 1485
  • 44 (0) 7794 0689 6985

E Mail Us