CIS 2021 - Databases

Clock Hours: 70

Delivery Mode
on-ground

Prerequisites: PC Operator Certificate

Industry Certifications Microsoft Office User Specialist

Course Description:
This course provides a comprehensive presentation of Microsoft Access. Topics include creating, querying, and maintaining a database; creating a data access page, reports, forms, combo boxes; using OLE fields, hyperlinks, and subforms; creating an application system using the Switchboard Manager, creating a report using design view, working with charts and PivotTable objects, administering a database system, specifying user-level security, and Access data in other applications.

Student Learning Outcomes:

Define database related terms.
Determine appropriate data inputs/outputs for a database.
Create databases and tables.
Enter, edit, and delete records in datasheets and forms.
Navigate through records in a table, query, or form.
Modify table structures and field properties.
Add input masks and lookup fields.
Create and modify queries including multi-table queries.
Find, sort, and filter records.
Create and modify an index.
Create and display forms and reports.
Modify form and report properties (including font, style, font size, color, caption) of controls.
Use and modify form and report sections (headers, footers, and detail).
Use calculated controls in queries, forms, and reports.
Establish relationships and enforce referential integrity.
Print and preview reports.
Effectively use Import and export data.
Backup, restore, compact, and repair a database.
Create a simple data access page.