1

Satriwithaya School

English Program

Course Syllabus for OT20284 Database Management (Microsoft Access)

Supplementary CourseLevel M32 periods / week

Class teachers:GeleyPeljor Semester 1 / 2017

Course Description:

This course is designed to provide students database application and design skills through the use of Microsoft Access database software. This course emphasizes the concepts to plan, create, and revise a database system by introducing and working with objects of MS Access, and provides the student the tools to effectively utilize those objects within various environments.

Learning Objectives:

By the end of the course, students will have demonstrated:

  1. Creating and Editing Access Tables.
  2. Creating and Editing Access Forms.
  3. Creating and Editing Access Reports.
  4. Creating and Editing Access Queries.
  5. Creating and Comprehending Relationships Within Tables.
  6. Creating and Utilizing Customized Objects.
  7. Integrating All Of The Above In Varied Contexts.

Learning Procedure:

  1. Engage, in which a student's interest is captured and the topic is established.
  2. Explore, in which the student is allowed to construct knowledge in the topic through facilitated questioning and observation.
  3. Explain, in which students are asked to explain what they have discovered, and the instructor leads a discussion of the topic to refine the students' understanding.
  4. Extend, in which students are asked to apply what they have learned in different but similar situations, and the instructor guides the students toward the next discussion topic.

5. Evaluate, in which the instructor observes each student's knowledge and understanding, and leads students to assess whether what they have learned is true.

Methods of assessment: / Grading: / Evaluation:

80: 20 / 70 : 30
  1. Formative (Before Mid Term)30points

1.1 (Test / Work) 15 points

1.2 (Test / Work) 15 points

  1. Mid Term20points
  2. Formative (After Mid Term)30points

3.1 (Test / Work) 15 points

3.2 (Test / Work) 15 points

  1. Final Exam 20 points

Texts, Supplies and Other Helpful Advice

1.

2.

3.

OT20284 Database Management (Microsoft Access)

Course Outline

Semester 1 / 2017

Week / Date / Topics / Period / Remark
1 / 15 – 19 May2017 / Database overview:
  1. Essential database terms and definitions
  2. ii. Essential database design principles
/ 2
2 / 22 – 25 May 2017 / Database files and structure:
  1. Structure of records
  2. Structure of fields
  3. Field and data types
/ 2
3 / 29 May – 2 June 2017 / Relational database concepts:
  1. Multiple tables within a single database
  2. Understanding and using primary keys
  3. Creating a relationships within a database
/ 2
4 / 5 – 9 June 2017 / Introduction to Access objects:
  1. Tables
/ 2
5 / 12 – 16 June 2017 /
  1. Queries
/ 2
6 / 19 – 23 June 2017 /
  1. Forms
/ 2
7 / 26 – 30 June 2017 /
  1. Reports
/ 2
8 / 3 – 7 July 2017 / Access objects: Tables in detail:
  1. Table designs
  2. Table modifications
  3. Table wizards
/ 2
9 / 10 – 14 July 2017 / Access objects: Queries in detail:
i. Query design / 2
10 / 17 – 19 July 2017 / ii. Simple queries
iii. Query syntax / 2
20 - 21 July 2017 / Mid Term Exam
11 / 24 – 28 July 2017 / Mid Term Exam
12 / 31 July – 4 Aug2017 /
  1. Formulas within queries
  2. Specialized queries
  3. Query wizards
/ 2
13 / 7 – 11 Aug2017 / Access objects: Forms in detail:
  1. Autoforms
  2. Form design
  3. Form wizards
/ 2
14 / 14 – 18 Aug2017 / Access objects: Reports in detail:
  1. Report Wizard
  2. Report Design
  3. Specialized report features and options
/ 2
15 / 21 – 25 Aug 2017 / Integrating Access with MS Office applications:
  1. Integrating Access with MS Word
/ 2
16 / 28 Aug – 1 Sep 2017 /
  1. Integrating Access with Excel
/ 2
17 / 4 – 8 Sep 2017 / Access with HTML Documents and the web / 2
18 / 11 – 15 Sep 2017 / Revision / 2
19 / 18 – 22 Sep 2017 / Final Exam
20 / 25 – 29 Sep 2017 / Final Exam

------