CIS 100 Study Guides -  CIS 100 - CIS Dept - Study Guides


 

Access 2007
Objectives

Students will have mastered the Access 2007 skills in this course when they can:

Access Chapter 1

Skills

 

SKILL 1

Open and Organize an Existing Database

SKILL 2

Modify Table Data Using a Form

SKILL 3

Modify a Query and Print the Results in a Report

SKILL 4

Format a Datasheet and Modify Table Design

SKILL 5

Modify Table Data and Use Find and Replace

SKILL 6

Sort Table Data and Hide Datasheet Columns

SKILL 7

Filter, Summarize, and Print a Datasheet

Omit SKILL 8

Create a Relational Database from a Template

SKILL 9

Add Records to Related Tables

Access Chapter 2

Skills

 

SKILL 1

Design a Relational Database and Build a Table in Datasheet View

SKILL 2

Build a Table in Design View

SKILL 8

Create a Form Using the Form Tool

Access Chapter 3

Skills

 

SKILL 1

Use the Simple Query Wizard to Create a Query

SKILL 3

Create a Query with Numeric and Date Criteria

SKILL 4

Create a Report Using the Report Wizard

SKILL 9

Group, Sort, and Filter Records in a Report

 


 

 

UFV_RGB_GIF15400.gif

For more information about CIS Department, contact cisinfo@UFV.ca
Technical questions re: the web site should be directed to cisweb@UFV.ca
Copyright © 2001 University of the Fraser Valley
Statement of Copyright & Disclaimer

This site best viewed with Netscape or I.E. 4.0 or later.