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
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
II. Course Specification
Course Type
Program Requirement
Credit Hours Narrative
3 Credits
Semester Contact Hours Lecture
15
Semester Contact Hours Lab
45
Prerequisite Narrative
ADMN 204
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