Home PC Basics Microsoft Office Microsoft Outlook Misc. Contact Us

Sterling Computer Courses

*

Microsoft Access 2000 - Level 2

Duration: Approx. 3 hours.

This product is an online product and is a Single user, 1 Year licence.

Screenshots:

(click on a screenshot for a bigger picture) Images are representative of this product.

Screenshot - Click Me Screenshot - Click Me Screenshot - Click Me

Overview:

This intermediate course strives to broaden and develop the basic database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. Some other skills students will learn include working with tables and data, working with HTML and hyperlinks, using the Query Wizard, and customizing reports. Students will also learn how to maintain databases by backup, as well as how to compact and repair them. In addition, students will learn techniques designed to make data entry in Access databases faster, easier, and less error-prone. The material is presented through explanatory text, real-world scenarios, interactive steps, and questions to test and reinforce the material covered.

Learn To:

This course covers the following topics:

  • Looking At Access
  • Opening Database Objects
  • Print Database Objects (tables, forms, reports, queries)
  • Modify Field Properties
  • Use Multiple Data Types
  • Modify Tables Using Design View
  • Use The Lookup Wizard
  • Use The Input Mask Wizard
  • Use Form Sections (headers, footers, detail)
  • Use A Calculated Control On A Form
  • Use The Office Clipboard
  • Create A Calculated Field
  • Create And Modify A Multi-table Select Query
  • Move And Resize A Control
  • Modify Format Properties (font, style, font size, color, caption, etc.)
  • Use The Control Toolbox To Add Controls - Reports
  • Use Report Sections (headers, footers, detail)
  • Use A Calculated Control In A Report
  • Save A Table, Query, Form As A Web Page
  • Add Hyperlinks
  • Backup And Restore A Database
  • Compact And Repair A Database


    • Objectives:

    Once you have completed this course, you will be able to:

  • Use the Lookup and Input Mask wizards
  • Add calculated controls to forms
  • Create and work with queries
  • Customize reports
  • Create Web documents


    • Price:


    Normal Price: £80.00 (excl. VAT)

    Special Offer Price: £50.00 (excl. VAT)

    YOU SAVE: £30.00 (37.5%)

    To purchase this online course, click the "Buy Now" button below. If you have bought a course from us before please enter your username before clicking "Buy Now". If you are a new customer, leave this field blank.

    Existing customer username (e.g.C4U9283479)


    Related Links:

    To contact us, please e-mail: contact@sterlingcomputercourses.co.uk

    Sterling Computer Courses.co.uk is a division of:

    Sterling Consultancy (UK) Ltd
    10 Wheatcroft Business Park
    Landmere Lane, Edwalton
    Nottingham
    NG12 4DG

    Telephone: 0115 984 9940 | Fax: 0115 921 5352