Access Introduction

Software: Microsoft Access

Training Course: Introduction to Microsoft Access

Location: London

To Book Call: 0700 233 6600 or click here

Summary: This course provides an introduction to Microsoft Access, part of the Microsoft Office Suite of programs. The course will identify and describe the component features that make up Microsoft Access and introduce you to working with them.

Pre-requisites: All attendees to Microsoft Access Courses must be proficient with basic Mouse, Keyboard and Windows skills. If you are new to Microsoft products, in particular Microsoft Access, we suggest that you spend a little time looking over the basic toolbar and menu options. An understanding of Database concepts is beneficial but not essential.

Duration: 1-Day
Start & Finish Times: 10am to 5pm

Objectives: This hands-on course will enable participants to identify and describe the component features that collectively make up Microsoft Access. Participants will be able to build database objects including Tables, Queries, Simple Forms and Reports.

Who should attend: Our ‘Microsoft Access Introduction’ course is designed for busy people who need to know how to get the best from Access from the outset. If you are required to use Access simply for Data Input, or need to progress to build your own Tables and Queries, this course will point you in the right direction.

Overview Introduction to Access Course Content

Getting Started with Microsoft Access: What Is a Database? What Is a Relational Database? Starting Access. Looking at the Access Database Window. Access Database Objects.

Starting an Access Database: Planning Content. Planning Structure. Creating a Database Using a Wizard. Saving Databases.

Working with Tables: Looking at Tables. Creating Tables with Wizards. Entering, Editing, and Deleting Data. Formatting Columns and Rows. Moving Columns. Freezing and Hiding Columns. Adding Fields. Using Input Masks. Validating Data Entry. Setting Primary Key Fields. Understanding Data Types. Printing Tables.

Working with Forms:  Look at simple Forms. Design View of a Form. Viewing Forms. Deleting Records from Forms. Creating Forms with a Wizard. Formatting Forms.

Finding, Filtering, and Sorting:  Choosing Filters or Queries. Finding Records. Finding and Replacing Data. Sorting Query Results. Sorting Table Records.

Working with Queries: Looking at Queries. Creating New Queries with a Wizard. Viewing Queries in Design View. Specifying Query Criteria. Querying with Wildcards.

Working with Reports: Look at Reports. Creating New Reports with a Wizard. Formatting Reports in Design View.