The information listed below is subject to change. Please review the course syllabus within your online course at the start of class.
The competencies you will demonstrate in this course are as follows:
The module outcomes that will permit you to demonstrate course competencies are:
Outcomes | Competencies | |
---|---|---|
1 | Create, open and close a database | A |
2 | Create and use tables, queries, forms, and reports | A, C |
3 | Design a database to satisfy a collection of requirements | B |
4 | Create queries using Design view, use text and numeric data in criteria | C |
5 | Create and use parameter queries, compound queries and crosstab queries | C |
6 | Sort data and join tables in queries | C |
7 | Create a report and a form from a query | C |
8 | Export data from a query to another application | C |
9 | Perform calculations and calculate statistics in queries | C |
10 | Customize the Navigation Pane | B, C |
11 | Add, change, delete, search and filter records | C |
12 | Use delete and action queries to delete and update records | C |
13 | Specify validation rules, default values and formats | A, B, C |
14 | Create and use lookup fields | C |
15 | Specify referential integrity | B, C |
Outcomes | Competencies | |
---|---|---|
1 | Create, modify, and print Reports and Forms | B, C |
2 | Add fields to reports or forms, group and sort data | B, C |
3 | Add totals and subtotals to a report | B, C |
4 | Format and move controls | B, C |
5 | Create and modify a form with a subform in Design view | B, C |
6 | Use the input Mask Wizard | B, C |
7 | Add Yes/No, Long Text, OLE Object and Attachment fields and use in a query | B, C |
8 | Create a form with a datasheet | B, C |
9 | Create a database using an Access Template | A, B, C |
Outcomes | Competencies | |
---|---|---|
1 | Create and relate additional tables and create queries for reports | B, C |
2 | Create reports in design view and add fields and text boxes | C |
3 | Update multiple report controls and group and ungroup report controls | B, C |
4 | Add and modify a sub-report and modify section properties | C |
5 | Include a conditional value in a report and add totals and subtotals | C, E |
6 | Add combo boxes for searching and selection lists in forms | C |
7 | Add command buttons and modify buttons and combo boxes in a form | C |
8 | Add a calculated field and sub-form in a Form | C, E |
9 | Insert, modify and format a Chart in a Form | C |
10 | Add, modify and format a calculated field, subform, chart | C |
Outcomes | Competencies | |
---|---|---|
1 | Create and modify macros, sub macros, and a menu form with command buttons and with an option group | E |
2 | Use an IF statement in a macro | E |
3 | Create datasheet forms, user interface macros, navigation forms, data macros, and control layouts | B, C, E |
4 | Use the Arrange tab to modify control layouts on forms and reports | B, C |
5 | Use table, database, and field properties | B, C |
6 | Create custom categories and groups in the Navigation Pane | C, E |
7 | Create indexes, custom data type parts, database for a template, custom template, custom web app, custom views for a web app. | C, D |
8 | Encrypt a database and set password, lock and split a database. | E |
9 | Explore careers in Databases and describe database management systems. | A, B, C, D, E |
Outcomes | Competencies | |
---|---|---|
1 | Create SQL queries, including fields, multiple tables and multiple criteria. | D |
2 | Utilize aggregate functions in SQL queries and group the results | D |
3 | Join tables in SQL queries | D |
4 | Compare SQL queries with Access-generated SQL | D |
5 | Describe functional dependence and identify when one column is functionally dependent on another | A, B |
6 | Convert an un-normalized relation to first normal form, first normal to second normal form, and second normal to third normal form. | B, C |
7 | Design a database using diagrams | A, C |
For every credit hour, students should plan to spend an average of 2-3 hours per week for course-related activities in a 15-week course. For example, a 3 credit hour course would average an average 6-9 hours per week to read/listen to the online content, participate in discussion forums, complete assignments, and study the course material. For 10 and 6-week courses, the amount of time per week will be higher so all course competencies, module outcomes, and assignments will be covered.
Aside from typical reading assignments, this course has the following (Please Note: This list is subject to change based on the discretion of the instructor facilitating this course.):
Mark all Module due dates on your calendar for this class. You may submit assignments AHEAD of schedule. Late assignments will not be accepted without prior approval.
Assignment | Points | % |
---|---|---|
Discussions (5 @ 30 points each) | 150 | 15% |
SAM Assignments (10 @ 10 points each) | 100 | 10% |
SAM Projects (10 @ 50 points each) | 500 | 50% |
Capstone (5 @ 50 points each) | 250 | 25% |
TOTAL | 1000 | 100% |
A = 90 to 100% | B = 80 to 89% | C = 70 to 79% | D = 60 to 69% | F = 59% and below |
CCCOnline goes to great lengths to assure the quality of your online learning experience. You can expect the following from our courses: