Microsoft Access
Level 1


Outcomes

Participants will learn the basic skills necessary to use a Microsoft Access Database.

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.
An introductory windows based spreadsheet package (such as Lotus 123 or Microsoft Excel) is strongly suggested


What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session



          Overview of Access
          Introduction to database concepts and terminology
          An introduction to Access
          Database planning and design

          Creating tables

          Examining a table
          Creating a table with the Table Wizard
          Creating a table in Design View
          Types of primary keys

          Working with tables

          Adding records
          Modifying the table design
          Finding and editing records
          Deleting, adding, and copying records and values
          Filtering and sorting records

          Using select queries

          Selecting fields and sorting records
          Refining the results of a query
          Using queries to perform calculations
          Joining tables in a query
          Creating and using forms
          Creating a form
          Modifying the form design
          Using a form to locate and organize information
          Multiple-table forms

          Creating and using reports

          Creating a report
          Creating a report that contains totals

          Database maintenance

          Creating a database
          Copying objects
          Using Windows Explorer
          Compacting a database



Performance-based objectives
  • Understand database components within Access
  • Design and create Database Tables
  • Perform data-entry and navigation within a table



This course is not available on our public schedule, call us on 1800 456 002 or EMAIL to book this course


 
About our courses About Us Contact Us Education Outlines Schedule By Course© iTeam 2017