Database in Microsoft Access 2002 (non-audio)

Overview/Description
To provide a comprehensive overview of creating and working with databases in Microsoft Access 2002

Target Audience
End users wanting to become familiar with IT concepts; end users wanting to attain competency in the use of computers; end users wanting to attain competency in the use of word-processing, spreadsheet, database, presentation, web browsing, and e-mail applications; end users wanting to attain an ECDL or ICDL certification or equivalent; staff of businesses and public bodies needing to attain certification in computer proficiency; university or other students needing to attain a basic IT qualification; staff of public bodies or organizations seeking to reskill themselves for the technology-based workplace; staff at universities, schools, or other training centers teaching computer literacy skills

Prerequisites
None

Expected Duration
6:30 Hours

Objectives:

Database in Microsoft Access 2002 (non-audio)

  • explain what a database is and describe basic database structures.
  • plan a basic database.
  • launch Access 2002 and describe its interface.
  • open and use databases and work with the application interface in Access 2002.
  • customize toolbars in Access 2002.
  • create databases in Access 2002.
  • create a blank Access 2002 database and a database based on an Access 2002 template.
  • create tables in Access 2002.
  • create a table using the Access 2002 Table Wizard.
  • modify a table in Access 2002.
  • create forms and controls in Access 2002.
  • add controls to a form.
  • modify form controls and sections in Access 2002.
  • format form control properties in Access 2002.
  • enter and change database records in Access 2002.
  • manipulate database records.
  • enter and sort database records.
  • save, convert, and back up data in Access 2002.
  • create and modify queries in Access 2002.
  • create and specify a query in Access 2002.
  • create a query with multiple criteria and filter and sort its results.
  • apply filters in a query in Access 2002.
  • describe the different report types, report sections, and report controls and create a report using the Report Wizard in Access 2002.
  • add a field and a control to a report in Access 2002.
  • modify report controls and sections in Access 2002.
  • use report controls.
  • navigate and print reports in Access 2002.
  • create a report in Access 2002.


    • Course Number: 71990_eng