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-001 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

Hybrid

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 and a myitlab code (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

\