Microsoft Access 97
Beginners Course
What is a Database Programme?
There is no doubt that Microsoft Access is a large, advanced database program and most people will need some help when learning to use it. A database is simply a collection of information, or data. For example, the names and addresses of customers and suppliers, or details about the books in a library could all be called databases. A database program, such as Microsoft Access, is simply a tool for organising, storing and retrieving the information in a database. It provides a way of entering new details or changing existing details, different ways of sorting and extracting the information, and a method of printing reports about your data.

You will learn about:
  • Getting Started
    the Microsoft Access window
    using the menu system
    using the Office Assistant
  • Navigating The Database
    moving between fields/records
    moving straight to a record
    switching between windows
  • Changing & Adding Records
    changing records
    adding new/additional records
    deleting records
  • Filtering Records
    filtering using part of a field
    clearing existing filter criteria
    entering additional criteria
  • Understanding The Database
    the database window
    creating a new form
    form, design and datasheet views
  • Tables
    the database view
    finding and sorting records
    adding/deleting/editing records
  • Querying The Database
    types of queries
    query based on one/two/three table(s)
    changing the query
  • More About Queries
    action queries
    choosing the query type
    an update query
  • Reports
    running an existing report
    sending reports to Microsoft Word & Excel
    saving and closing the report
  • Managing A Database
    how to back up a database
    compacting the database
    repairing a database
  • Views, Toolbars & Options
    customising toolbars
    scrolling a worksheet
    the different views

By The End Of This Course You Will Be Able To:
  • Start and exit Access

  • Use the simple Sort options to order records in a form or a table.

  • Use the Main Switchboard and Database window to open forms, tables, reports and queries, as appropriate.

  • Use the menus, toolbar buttons and some shortcut key combinations.

  • Hide and show the Office Assistant; reset the Office Assistant tips.

  • Navigate the database, moving between windows, records and fields.

  • Use Find to search for a particular record or group of records in a form or a table.

  • Manage the database; compact and repair it
  • Open and close a database.

  • Change and add records in either a form or a table; delete records.

  • Set filter criteria to select a sub-set of records using Filter By Selection, Filter Excluding Selection, Filter For and Filter By Form.

  • Understand the structure of the sample database.

  • Work with tables, changing the design, printing the datasheet and using print preview.

  • Query the database using simple select queries that extract specific data from the database, and also action queries that change the data

  • Produce reports using AutoReport and the Report Wizard; send reports to Microsoft Word and Excel.

Trainer(s)
Our trainers are all "Quality Assured" and have a wealth of practical experience in the field of computer applications with qualifications to match. We are using the latest in purpose written Information Technology training courseware.

Having learnt all of the above, you will be able to produce professional looking databases and save them for future use.

GOOD LUCK!

Back | Register | Home | E-Mail