ADMN 215 Database Essentials*

In this course students will continue to use an electronic database as a tool to manage and store information for reference, reporting and analysis

Credits

3

Semester Contact Hours Lecture

15

Semester Contact Hours Lab

45

General Education Competency

[GE Core type]

ADMN 215Database Essentials*

Please note: This is not a course syllabus. A course syllabus is unique to a particular section of a course by instructor. This curriculum guide provides general information about a course.

I. General Information

Department

Information Technology

II. Course Specification

Course Type

Program Requirement

General Education Competency

[GE Core type]

Credit Hours Narrative

3

Semester Contact Hours Lecture

15

Semester Contact Hours Lab

45

Grading Method

Letter grade

Repeatable

N

III. Catalog Course Description

In this course students will continue to use an electronic database as a tool to manage and store information for reference, reporting and analysis

IV. Student Learning Outcomes

Upon completion of this course, a student will be able to:

  • Students will demonstrate the proper use of database terminology and design principles.
  • Students will use a relational database management system to build more complex tables, queries, reports, forms and objects

V. Topical Outline (Course Content)

Use Compound Criteria in a Query Create a Query Based On More Than One Table Use Wildcards in a Query Create A Calculated Filed In A Query Calculate Statistics and Group Data in a Query Create a Crosstab Query Create a Parameter Query Create and Use a Form to Add and Delete Records Filter Records Use the Form Wizard Modify a Form in Layout and Design View Create a Report Modify a Report in Design and Layout View Group Data in a Report Change Data Types Create a Lookup Field Set Field Properties Create Data Validation Rules and Validation Text Create Calculated Fields in a Query Use Aggregate Functions in a Query Find Duplicate and Unmatched Records in a Query Create Make Table, Append, Delete and Update Queries Modify Join Types Create a Form in Design View Change and Add Controls Create a Report Based On a Query Create a Report in Design View Add Controls to a Report Create Split and Multi-Page Forms Create and Modify a Subreport Create an Alphabetic Index Create a Standalone Macro Add Multiple Actions to a Standalone Macro Create an Embedded Macro Create a Macro Group Create a Data Macro Import and Export to Other Applications Link to Another Access Database Create a Navigation Form Use Access Analysis Tools Encrypt and Decrypt Databases Create and Modify a Query in SQL View

VI. Delivery Methodologies