|
Standard |
Posted: 09/10/07
|
R State Standard |
£ Institutionally Developed |
College: n/a |
CIS 2229
– Comprehensive Database Techniques
Provides a study of databases. Topics include: advanced database
management concepts, development of macros, data integration concepts,
development of user interfaces, relational database concepts, troubleshooting
databases.
|
Competency
Areas: |
Hours |
|
|
Advanced
Database Management Concepts |
Class |
4 |
|
Development
of Macros |
D. Lab |
4 |
|
Data
Integration Concepts |
P.
Lab/O.B.I. |
0 |
|
Development
of User Interfaces |
Credit |
6 |
|
Relational
Database Concepts |
|
|
|
Troubleshooting
Databases |
|
|
|
Prerequisite:
SCT 100 |
|
Corequisite: |
|
Course Guide |
|
Competency |
After completing this section,
the student will: |
Hours |
||
|
Class |
D. Lab
|
P. Lab/ O.B.I. |
||
|
ADVANCED DATABASE CONCEPTS |
16 |
28
|
0 |
|
|
Designing
and creating databases |
Plan,
create, modify, save, and print a database. |
|
|
|
|
Entering
and Editing Data |
Enter
records. |
|
|
|
|
|
Navigate
through records. |
|
|
|
|
|
Modify
data. |
|
|
|
|
Designing
and using forms |
Create
and modify a custom form. |
|
|
|
|
|
Add and
modify controls. |
|
|
|
|
|
Modify
format properties. |
|
|
|
|
|
Print a
form. |
|
|
|
|
|
Plan and
create subforms. |
|
|
|
|
Working
with records |
Locate
data. |
|
|
|
|
|
Find a
record. |
|
|
|
|
|
Sort
records. |
|
|
|
|
|
Filter
records. |
|
|
|
|
Creating
queries |
Create,
modify, and save a multi-table select query. |
|
|
|
|
|
Specify
criteria in a query. |
|
|
|
|
|
Display
records in a subdatasheet. |
|
|
|
|
|
Print
query results. |
|
|
|
|
|
Create a
parameter query. |
|
|
|
|
|
Create
action query. |
|
|
|
|
|
Create
multiple table queries. |
|
|
|
|
|
Set
crosstab query. |
|
|
|
|
|
Create
calculated field. |
|
|
|
|
|
Use
concatenation in queries |
|
|
|
|
Designing
and using reports |
Create,
modify, and preview reports. |
|
|
|
|
|
Create
grouped report from query. |
|
|
|
|
|
Modify
report properties. |
|
|
|
|
|
Use
calculated control in a report. |
|
|
|
|
|
Customize
report headers and footers. |
|
|
|
|
|
Create
and modify charts. |
|
|
|
|
Using
database tools |
Set and
modify a database password. |
|
|
|
|
|
Encrypt
and decrypt a database. |
|
|
|
|
DEVELOPMENT
OF MACROS |
4 |
2
|
0 |
|
|
Creating
and using macros |
Create
macros. |
|
|
|
|
|
Create a
command button. |
|
|
|
|
|
Run
macros using controls. |
|
|
|
|
|
Create a
conditional macro. |
|
|
|
|
DATA
INTEGRATION CONCEPTS |
4 |
2
|
0 |
|
|
Data
integration |
Exporting
database objects. |
|
|
|
|
|
Integrating
database with spreadsheet. |
|
|
|
|
|
Using
spreadsheet data with database. |
|
|
|
|
|
Integrating
with the Internet. |
|
|
|
DEVELOPMENT OF USER INTERFACES
|
4 |
2
|
0 |
|
|
Creating
user interfaces |
Creating
the user interface. |
|
|
|
|
|
Assigning
items to the user interface. |
|
|
|
|
|
Formatting
the user interface. |
|
|
|
|
|
Using the
user interface. |
|
|
|
RELATIONAL DATABASE
CONCEPTS
|
4 |
2
|
0 |
|
|
Establishing
table relationships |
Establishing
one-to-many relationships. |
|
|
|
|
|
Enforcing
referential integrity. |
|
|
|
|
|
Adding
additional tables to a relationship. |
|
|
|
|
|
Specifying
join properties for relationships. |
|
|
|
|
TROUBLESHOOTING
DATABASES |
8 |
4
|
0 |
|
|
|
Using the
application’s help system. |
|
|
|
|
|
Using
Internet Help. |
|
|
|
|
|
Using
technical support. |
|
|
|
|
Suggested Resources |
Books:
Microsoft Office Access 2003:
Essentials Course, ISBN: 1591360307, Marotti, Course
Technology
Microsoft Office Access 2003:
Comprehensive Concepts and Techniques, CourseCard
Edition
ISBN: 1-4188-4363-6, Shelly, Cashman, Pratt, Last, Course Technology
SAM 2003 Assessment and Training
3.1, ISBN: 1-4239-1261-6, Course Technology