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
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]
Semester Contact Hours Lecture
15
Semester Contact Hours Lab
45
Grading Method
Letter grade
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