Database Programming Syllabus for 2011-2012
Return to Syllabus List

Instructor Information

Course Information

Recording Policy

Disability Statement

Any student who, because of a disabling condition, may require some special arrangements in order to meet course requirements should contact disAbility Services (Student Service Center room 119, phone 371-5436) as soon as possible.

Statement for Mental Health and Advocacy & Resource Center:

As a student you may experience a range of issues that can cause barriers to learning, such as strained relationships, increased anxiety, alcohol/drug problems, feeling down, difficulty concentrating and/or lack of motivation. These mental health concerns or stressful events may lead to diminished academic performance or reduce a student's ability to participate in daily activities. Amarillo College offers services to assist you with addressing these and other concerns you may be experiencing. If you or someone you know are suffering from any of the aforementioned conditions, you can learn more about the broad range of confidential mental health services available on campus by calling the AC Counseling Center at 806-371-5900. The AC Counseling Center website is https://www.actx.edu/counseling/ . Also, if you are in need of social services (affordable housing, utilities, transportation, food, clothing, childcare, medical/dental/vision, legal), please call the AC Advocacy & Resource Center at 806-371-5439. The AC Advocacy & Resource Center website is https://www.actx.edu/arc

Amarillo College Tutoring for Success Policy:

Administrative Drop Policy

N/A

Student Withdrawal Procedures

N/A

Privacy Statement

The Amarillo College Privacy Policy is found at https://www.actx.edu/-amarillo-college-privacy-notice , and applies to all Amarillo College students.  If you have questions about this privacy statement or you believe that your personal information has been released without your consent, send email to humanresources@actx.edu .

Course

ITSE-2309-002 Database Programming

Prerequisites

BCIS 1305

Course Description

Database development using database programming techniques emphasizing database structures, modeling and database access.

Student Resources Student Resources Website

Department Expectations

\N

Occupational License Disclaimer

Hours

(3 sem hrs; 2 lec, 3 lab)

Class Type

Online Course

Syllabus Information

Textbooks

For this class, students must have:

Database Concepts, 5e, Kroenke and Auer, ISBN-10 0138018804, ISBN-13: 9780138018801

myitlab code with e-text or Exploring Office 2010 Vol. 1 and 2 textbooks  (a myitlab code can be used from a previous semester or class and is good up to one year.) 

*Please note you must have, or access to, Office 2010 Access software.

 Contact your instructor for questions

Supplies

Storage media (optional)

Student Performance

1. Define the structure of a database.
2. Design a database application and define all database components.
3. Create a database.
4. Demonstrate how to create and use modules for a database.
5. Demonstrate how to write and use a query for a database.
6. Demonstrate effective use of forms to create an interface between user and the database.
7. Demonstrate and use libraries of objects available for the database.
8. Design and use macros.
9. Design, execute, and print a report.

Introduction to database theory and applications. Techniques presented for planning defining, and designing a database plus procedures pertaining to queries, reports, control, and security.

In Access application: 

1. Understand the order of operations
2. Create a calculated field in a query
3. Create expressions with the Expression Builder
4. Use built-in functions in Access
5. Perform date arithmetic
6. Add aggregate functions to datasheets and queries
7. Create forms using the form tools
8. Modify a form
9. Sort records in a form
10. Identify form sections
11. Revise forms using form views
12. Identify control types in forms
13. Create reports using report tools
14. Modify a report
15. Sort records in a report
16. Identify report sections
17. Revise reports using report views
18. Identify control types in reports
19. Create a PivotTable
20. Add aggregate functions to a PivotTable
21. Modify a PivotTable
22. Create a PivotChart
23. Identify chart elements
24. Modify a PivotChart
25. Add calculations to a PivotTable
26. Workwith calculations in a PivotTable
27. Create a PivotTable
28. Add aggregate functions to a PivotTable
29. Modify a PivotTable
30. Create a PivotChart
31. Identify chart elements
32. Modify a PivotChart
33. Add calculations to a PivotTable
34. Create a PivotTable
35. Add aggregate functions to a PivotTable
36. Modify a PivotTable
37. Create a PivotChart
38. Identify chart elements
39. Modify a PivotChart
40. Add calculations to a PivotTable
41. Work with calculations in a PivotTable
42. Establish data validation
43. Create an input mask
44. Create and modify a lookup field
45. Set the tab order
46. Create a combo box control
47. Restrict edits in a form
48. Compare fields using a data macro
49. Create a query to display missing data
50. Create a missing data report
51. Create an aggregate report
52. Determine when to use an action query
53. Update data with an update query
54. Add records to a table with an append query
55. Create a table with a make table query
56. Delete records with a delete query
57. Create a parameter query to provide flexibility
58. Summarize data with a crosstab query
59. Find unmatched records with a query
60. Find duplicate records with a query
61. Create a Hyperlink field
62. Add an Attachment field
63. Add attachment controls to forms and reports
64. Export data to Excel
65. Export data to Word
66. Export data to a PDF or XPS document
67. Export objects to another Access database
68. Link to an Excel spreadsheet
69. Link to an Access table
70. Import a text file
71. Verify First Normal Form
72. Verify Second Normal Form
73. Verify Third Normal Form
74. Use the Database Documenter tool
75. Use the Performance Analyzer tool
76. Use the Table Analyzer tool
77. Use the Database Splitter tool
78. Create a menu system
79. Encrypt and password-protect a database
80. Digitally sign and publish a database
81. Save a database as an ACCDE file
82. Understand the purpose of a macro
83. Create a stand-alone macro
84. Use the Macro Builder
85. Attach an embedded macro to an event
86. Identify when to use a data macro
87. Create an event-driven data macro
88. Create a named data macro
89. Understand the fundamentals of SQL
90. Interpret an SQL Select Statement
91. Use an SQL Select Statement as a record source

Students Rights and Responsibilities

Log in using the AC Connect Portal

In order to receive your AC Connect Email, you must log in through AC Connect at https://acconnect.actx.edu .

If you are an active staff or faculty member according to Human Resources, use "Exchange". All other students, use "AC Connect (Google) Email".

Expected Student Behavior

Grading Criteria

Final grades will be assigned as indicated below:

A - Superior, Minimum of 90% average on exams and quizzes plus all homework turned in with a 90% average on that graded.

B - Good, Between 80% and 89.49% average on exams and quizzes plus all homework turned in with a minimum average of 80% on that graded.

C - Adequate, Between 70% and 79.49% average on all work.

D - Minimum, Between 60% and 69.49% average on all work.

F - Failing, Below 60% average on all work.

Student grade will be based on the following:

Assignments, chapter tests and exam dates are given to each student at the first class meeting. .It will be your responsibility to complete each assignment, and take exams on the scheduled dates.  No late work will be accepted.  The lowest Access Assignment and Database Concepts chapter test will be dropped at the end of the semester to allow for unavoidable situations that may arise.

Attendance

\

\

\

Calendar

Additional Information

 Important Dates to Remember