Microsoft Access Introduction

DURATION

1 days

LOCATION

Exeter – Devon, Central London, Bristol or onsite at your premises.

PREREQUISITES

Delegates should have attended the Introduction to Windows course or be proficient in the use of a personal computer using the Windows operating system.

Course Outline

Delegates will learn Database concepts including how to create a database. How to store, find, edit and retrieve a database. How to present information using the query and reporting facilities.

Subject areas (Please note, subject areas covered will depend on delegates ability and time available)

ACCESS DATABASE CONCEPTS

  • What is a database?
  • What is a relational database?
  • What is a table?
  • What is a record (row)?
  • What is a field (column)?
  • What is data?
  • Data types

A FIRST LOOK AT ACCESS

  • Opening Access
  • Exploring the Access window
  • The Ribbon (Toolbar)
  • Ribbon tabs
  • Groups & Dialog Box Launcher
  • Navigating – Quick keys (shortcut keys)
  • Navigating – Pointer keys & quick keys
  • Navigating – Mouse wheel
  • Contextual tabs
  • Minimising the Ribbon
  • Quick Access Toolbar
  • The Office Button
  • Microsoft Access Help

OPENING A DATABASE & SECURITY ISSUES

  • Opening a database
  • Security warnings
  • Trusted Locations – Trust Centre
  • Setting the default folder location within Access

CREATING A DATABASE & USING VIEWS

  • Creating a new database
  • Creating a new blank database
  • Saving a table
  • Adding and renaming fields
  • Using Datasheet View
  • Using Design View
  • Changing the view

TABLE MODIFICATION AND NAVIGATION

  • Adding Fields – Design View
  • Data Type – Overview
  • Data Type – Descriptions
  • Using the Attachment data type
  • Adjusting column width
  • Moving a column to rearrange the column order
  • Adding records to a table
  • Navigating through records within a table
  • Closing a database
  • Navigation Pane

FIELD PROPERTIES, VALIDATION & INPUT MASKS

  • Field Properties
  • Input Mask
  • Validation Rules
  • Field Properties – Guides Tables

MANIPULATING RECORDS & TABLES

  • Closing an Object – Table
  • Renaming an Object – Table
  • Editing data within a record
  • Deleting data within a record
  • Using the Undo command
  • Deleting a single record
  • Deleting multiple record
  • Save As – Database Object
  • Deleting a table

PRIMARY KEYS AND INDEXING

  • Defining a Primary Key
  • Indexing
  • Creating a single-field Index
  • Creating a multiple-field Index
  • Deleting multi-field indexes

FILTERING & SORTING

  • Text Filters
  • Applying a single filter
  • Clearing a single filter
  • Creating multiple filters
  • Clearing multiple filters
    Sorting

RELATIONSHIPS

  • Table relationships
  • One-to-many relationship
  • Many-to-many relationship
  • One-to-one relationships
  • Creating relationships between tables
  • Referential integrity
  • Cascade options
  • Cascade update related fields
  • Cascade delete related records
  • Enabling cascade options
  • Deleting relationships

ACCESS FORMS

  • Forms overview
  • Creating forms
  • Modifying forms
  • Modifying a form title
  • Modifying a form logo
  • Modifying a form label
  • Saving a form
  • Form View
  • Adding and formatting attachments
  • Modifying records
  • Deleting records
  • Adding records
  • Closing form
  • Opening forms
  • Deleting a form

ACCESS QUERIES

  • What are queries?
  • Creating a simple query
  • Adding criteria to a query
  • Running a query
  • Editing criteria in a query
  • Saving a query
  • Creating a two table query and sorting the results
  • Deleting a query

ACCESS REPORTS

  • What are reports?
  • Creating a simple report
  • Using the Report Wizard
  • Modifying the layout of a report
  • Widening a report column
  • Modifying the report title
  • Adding logos to a report
  • Autoformating a report
  • Modifying field names within a report
  • Inserting and formatting the date & time
  • Adding available fields to a report
  • Resizing reports for printing
  • Closing a report
  • Deleting a report

ACCESS PRINTING ISSUES

  • Considerations before printing
  • Print previewing
  • Which orientation, portrait or landscape?
  • Adjusting layout in Print Preview
  • Setting margins
  • Printing a complete table
  • Printing selected records
  • Printing a query or reports
  • Printing forms

TO BOOK

For more information or to book onto our Microsoft Access Introduction training course please contact us on 01392 824 022.

If there is aMicrosoft course that is not listed on our site, that you are interested in attending then please let us know and we can arrange one to one training onsite with our Trainer.

Still not convinced?
We can help you!

Fill out the form below and one of our IT specialists will contact you.



Testimonials

 

EmailFacebookTwitterSupport PortalAME Support Tool