exam2_CIS_250_rev_notes

exam2_CIS_250_rev_notes - CIS 250 Access Exam Review You...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CIS 250 Access Exam Review You will be responsible for the following objectives: Understand the different types of database formats. Discuss the advantages/benefits for databases. Know the steps for planning and designing your database. Define the basic units of data organization within the context of a database. Discuss the use of primary and foreign keys; know how to create a primary key. Identify the objects in an Access database. Understand the ways to create and change databases, tables, forms, reports, and queries and be able to perform those actions. Distinguish between the different Access views. Illustrate you understand the various methods of sorting and filtering records. Be able to discuss relationships and the importance of referential integrity in database table maintenance; know how to establish relationships and enforce referential integrity. Understand various field properties and field types; be able to perform the same
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/10/2012 for the course CIS 250 taught by Professor Wright during the Summer '09 term at S. Alabama.

Ask a homework question - tutors are online