Mastering Database Fundamentals Using Access 2000
(Microsoft Training Course: 1539) - 2 days - £1200 exc VAT

> Target Audience
This course is designed for users who are new to database applications.
> Course outline
  1. Introduction to Microsoft Access 2000
  2. Designing a Database
  3. Storing Data
  4. Getting Data
  5. Building Forms
  6. Building Reports
  7. Creating Data Access Pages
  8. Creating a Database Application

Supplementary InformationThis course has now retired and is no longer available. It is possible for us to run a closed Access 2007 course for more than two people. Please call for details.
Module 1: Introduction to Microsoft Access 2000
  • Getting started with Access
  • Overview of the book store application
  • Creating a database
  • Introduce the major features of Access
  • List the benefits of using Access 2000 to manage your data
  • Describe the purpose of database elements
  • Create a database by using the Database Wizard
  • Create a database application using the Database Wizard
  • Investigate the book store application case study
Module 2: Designing a Database
  • Designing reports, queries, and forms
  • Designing tables
  • Identify the requirements for a database, given a specification
  • Identify the objects that are required in the database
  • Organize data into tables
  • Identify fields in a table that uniquely define a row of data
  • Identify the relationships between the tables in a database
  • Identify the data validity requirements for each field
Module 3: Storing Data
  • Creating a table
  • Customizing a table
  • Adding and editing data in a table
  • Working with related tables
  • Create a table in Access by using the Access Table Wizard
  • Customize a table in Design view
  • Set field properties for a table
  • Edit and enter data into a table
  • View the contents of a table in Datasheet view
  • Import data from external sources
  • Define a one-to-many relationship between two tables
Module 4: Getting Data
  • Finding information in a table
  • Filtering data
  • Querying the database
  • Customizing a query
  • Use the Find command to search a table for data
  • Filter data by using the appropriate filter feature (by selection, by form etc)
  • Create a query by using the Simple Query Wizard
  • Customize a query in Design view
  • Use calculated fields in a query
  • Use criteria in a query to selectively retrieve records
Module 5: Building Forms
  • Creating a form
  • Customizing a form
  • Working with forms
  • Create forms by using the Access Form Wizard and the AutoForm feature
  • Customize the appearance of a form and its sections in Design view
  • Set form properties
  • Use simple controls on forms and create calculated fields
  • Use built-in functions on forms
  • Print a form
Module 6: Building Reports
  • Creating a report
  • Customizing a report
  • Enhancing a report
  • Create reports by using the Access Report Wizard and the AutoReport feature
  • Customize the appearance of a report, and its sections, in Design View
  • Preview and print a report
  • Set report properties
  • Enhance a report by sorting and grouping records
  • Apply conditional formatting to fields on a report
  • Use controls and built-in functions in a report
  • Export an Access report for viewing in a browser or in other Microsoft Office products.
Module 7: Creating Data Access Pages
  • Creating a data access page
  • Customizing a data access page
  • Working with a data access page
  • Create a data access page by using the wizard
  • Customize the appearance of a data access page in Design view
  • Create a data access page that supports data entry
  • Convert an HTM file into a data access page
  • Group records on a data access page
  • Sort records on a data access page
Module 8: Creating a Database Application
  • Adding a switchboard to a database
  • Defining startup options for a database application
  • Maintaining a database
  • Using a previous-version database in Access 2000
  • Create a switchboard for your database, and tie the elements together
  • Define startup settings for your database applications
  • Back up and restore your database
  • Compact and repair your database
> Pre-Requisites
No programming knowledge is required although familiarity with Microsoft Office products and the Windows environment is an advantage.
    > Purpose
    At the end of the course, students will be able to create an appropriate schema for a small-group database application; use Access wizards to create tables, queries, forms, and reports for a simple database; and customize tables, queries, forms, and reports in Design view.
    > Supplementary Information
    This course has now retired and is no longer available. It is possible for us to run a closed Access 2007 course for more than two people. Please call for details.