Microsoft Access 2007

Canada College
Montreal, Quebec, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a means
to evaluate learning. Upon successful completion of this course, students will be able to:
�Understand database concepts and terminology in Access 2007 .
�Design and create tables.
�Enter and manipulate data in tables.
�Use Access queries to select and analyze information in a table.
�Create data forms for viewing and inputting data.
�Create reports that summarize and group data.
�Perform database maintenance procedures.
Course description
Overview: Students will learn the basic skills necessary to begin using Access 2007 . They
will design and create databases, tables, queries, forms, and reports. This course contributes
toward the Microsoft Proficiency Guidelines for Access 2007 .
Prerequisites: Windows 95: Introduction; Windows 98: Introduction; or 98: Making the Transition,
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to create and use database objects, including tables, queries,
forms, and reports.
Target student: Students enrolling in this course should understand the basic concepts involved
in working with a personal computer (PC). For example, students should be familiar with terms
such as computer memory, data files, and program files. Students should also be familiar with the
components that make up the PC, including input, output, and storage devices. Students should
also be fairly comfortable working in the Windows environment. No prior knowledge of databases
or Access is assumed.
What’s next: Access 2007 : Level 1 is the first course in this series. Level 2 database designs
by using the principles of normalization and table relationships. Students also learn how to query
multiple tables for data that is used in customized forms and reports. Students who want to learn
advanced features can take the third course in this series, Access 2007 : Advanced. In that
course, students learn to create advanced queries, create more efficient forms and reports, and
work with macros. The final course in this series, Introduction to Application Design applications.
Course content
Lesson 1: Overview of Access 2007
�Introduction to Database Concepts and Terminology
�Introduction to Access 2007
�Database Planning and Design

Lesson 2: Creating Tables
�Examining a Table
�Creating a Table With the Table Wizard
�Creating a Table in Design View
�Types of Primary Keys
Lesson 3: Working with Tables
�Modifying a Table Using Design View
�Finding and Editing Records
�Filtering and Sorting Records
Lesson 4: Creating and Using Select Queries
�Creating a Select Query to View Specific Fields
�Specifying Criteria in a Query to View Specific Records
�Using Queries to Perform Calculations
�Joining Tables in a Query
Lesson 5: Creating and Using Forms
�Creating a Form With the Form Wizard
�Modifying the Form Design
�Using a Form to Locate and Organize Information
�Multiple-Table Forms
Lesson 6: Creating and Using Reports
�Creating a Report With the Report Wizard
�Creating a Report That Contains Totals
Lesson 7: Creating and Maintaining a Database
�Creating a Database
�Managing a Database and Its Objects
�Database Maintenance

...''

Phone:514-868-6262

School Address:

1118 Sainte Catherine West #403 Montreal, Quebec, H3B 1H5 Canada

Jobs & Resumes: Montreal
Houses & Roommates: Montreal

Simply Accounting
Accounting
Nursing Assistance
Esthetic and Beauty
Clinical Engineering
Office Automation
Judicial Secretary
Windows VISTA
Word 2007
Excel 2007
Microsoft Publisher 2007
Microsoft FrontPage 2007
Microsoft Outlook 2007
Microsoft PowerPoint 2007
Dreamweaver �Web Site Design
Bookkeeping
Medical Secretary
Multimedia
MCSE

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.