Access 2003: Creating Queries


 

Description:

As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 database. This includes managing Access data, establishing table relationships, planning a database and building its structure, and controlling data entry. In this course, you will examine how to query the database and find and join data. You will also explore creating flexible queries.Creating Queries is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries. It also introduces the student to integrating Access data with other applications such as Microsoft® Office Word 2003 or Microsoft® Office Excel 2003. Additionally, it is designed for students pursuing the Microsoft® Office Specialist (MOS) certification for Access, and it is a prerequisite to taking more advanced courses in Access.

This course carries the following professional education credits: 0.2 CEUs. For more information on accreditation bodies, please visit www.elementk.com/products/certification-and-accreditation.

 

Objectives:

  • In this course, you will query the database, find and join data, and create flexible queries.

Hardware and Software Required:

  • Browser Microsoft Internet Explorer 7 (or higher)
  • Browser Mozilla Firefox 2 (or higher)
  • Browser Apple Safari 2 (or higher)
  • Operating System Microsoft Windows 2000, XP, Vista, or Windows 7
  • Operating System Apple Mac OS X 10.4 (or higher)
  • Processor Pentium III 1 GHz (or better)
  • Processor Macintosh Intel-based or PowerPC G4 (or better)
  • RAM 512 MB (1 GB or more recommended)
  • Internet connection 256K (broadband recommended)
  • Adobe Flash Player 8 (current version recommended)
  • Adobe Reader 7 (or higher)
  • Other requirements may apply to supplemental offline activities. Omitting these optional activities does not affect course completion.

 




User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-A203-CQ
  • Duration: 1 hours 49 minutes
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend