COURSE NUMBER: SA_Maj6
TITLE: HANDS-ON with DATABASE
DEPARTMENT / PROGRAM: BS SECRETARIAL ADMINISTRATION
SEMESTER AND SCHOOL YEAR: 2nd Semester, SY 2007-2008
INSTRUCTOR: MS. IRLYN JANETTE E. LOMBOY
COURSE DESCRIPTION
This course provides fundamental concepts, principles and hands-on experience on database and information system design using MS ACCESS 2003. It is designed as the first database course for Secretarial students who do not have database experiences
COURSE OBJECTIVES (DESIRABLE OBJECTIVES)
Towards the end of the course, students are expected to / able to:
Acquire an in-depth understanding of the fundamental concepts and theories on database and information systems
To understand the general process of database design and development using MS ACCESS 2003
COURSE OUTLINE AND TIMEFRAME
INTRODUCTION
MS Access Fundamentals
http://databases.about.com/od/access/l/aaaccess1.htm
What's New in Access 2003
http://en.wikipedia.org/wiki/Microsoft_Access
http://www.superwarehouse.com/Microsoft_Access_2003/077-02870/pf/319199
BASIC ELEMENTS of MS ACCESS 2003
Understanding the Access Program Screen
http://www.brainbell.com/tutorials/ms-office/Access_2003/Understanding_The_Access_Program_Screen.htm
Using Menus
http://news.office-watch.com/t/n.aspx?a=502
Using Toolbars
http://office.microsoft.com/en-us/access/HA100365441033.aspx
Filling Out Dialog Boxes
http://office.microsoft.com/en-us/access/HA010714971033.aspx
DATABASES & TABLES
Introduction to Databases
http://www.databasejournal.com/sqletc/article.php/1428721
Starting Access and Opening a Database
http://www.brainbell.com/tutorials/ms-office/Access_2003/Starting_Access_And_Opening_A_Database.htm
Tour of a Table
http://en.wikipedia.org/wiki/Table_(database)
Properties of the fields
http://www.teacherclick.com/access2003/t_5_1.htm
Adding, Editing, and Deleting Records
http://www.brainbell.com/tutorials/ms-office/Access_2003/Adding,_Editing,_and_Deleting_Records.htm
Keystroke and Right Mouse Button Shortcuts
http://office.microsoft.com/en-us/access/results.aspx?qu=keystroke+OR+shortcuts&sc=9&av=ZAC110
http://office.microsoft.com/en-us/access/HP030898861033.aspx?pid=CH062526051033
Opening and Modifying Database Objects
http://www.brainbell.com/tutorials/ms-office/Access_2003/Opening_And_Modifying_Database_Objects.htm
Relationships
http://www.teacherclick.com/access2003/t_6_1.htm
Working with Multiple Windows
http://www.brainbell.com/tutorials/ms-office/Access_2003/Working_With_Multiple_Windows.htm
FORMS ,QUERIES & REPORTS
Tour of a Form
http://www.vtc.com/products/Microsoft-Access-2003-tutorials.htm
Tour of a Query
http://www.teacherclick.com/access2003/t_10_1.htm
Tour of a Report
Previewing and Printing a Database Object
http://support.microsoft.com/default.aspx/ph/2509?sid=72
Selecting Data
http://www.brainbell.com/tutorials/ms-office/Access_2003/Selecting_Data.htm
Cutting, Copying, and Pasting Data
http://www.brainbell.com/tutorials/ms-office/Access_2003/Cutting,_Copying,_and_Pasting_Data.htm
OTHER BUTTONS & SHORTCUTS
Using Undo
http://www.brainbell.com/tutorials/ms-office/Access_2003/Using_Undo.htm
Checking Your Spelling
http://www.brainbell.com/tutorials/ms-office/Access_2003/Checking_Your_Spelling.htm
Getting Help
http://www.brainbell.com/tutorials/ms-office/Access_2003/Getting_Help.htm
Changing the Office Assistant and Using the Button
http://www.brainbell.com/tutorials/ms-office/Access_2003/Changing_The_Office_Assistant_And_Using_The_Button.htm
http://msdn2.microsoft.com/en-us/library/aa218526(office.11).aspx
Using the Zoom Box
http://www.brainbell.com/tutorials/ms-office/Access_2003/Using_The_Zoom_Box.htm
Closing a Database and Exiting Access
http://www.brainbell.com/tutorials/ms-office/Access_2003/Closing_A_Database_And_Exiting_Access.htm
REQUIRED READINGS
SUGGESTED READINGS
COURSE REQUIREMENTS
Assignments, Quizzes, Exams, Project, Blogs, Links,forums, Tree Planting
CONSULTATION HOURS
____________________
Friday, April 18, 2008
Course Outline / Syllabus
COURSE NUMBER: SA_Maj6
TITLE: HANDS-ON with DATABASE
DEPARTMENT / PROGRAM: BS SECRETARIAL ADMINISTRATION
SEMESTER AND SCHOOL YEAR: 2nd Semester, SY 2007-2008
INSTRUCTOR: MS. IRLYN JANETTE E. LOMBOY
COURSE DESCRIPTION
This course provides fundamental concepts, principles and hands-on experience on database and information system design using MS ACCESS 2003. It is designed as the first database course for Secretarial students who do not have database experiences
COURSE OBJECTIVES (DESIRABLE OBJECTIVES)
Towards the end of the course, students are expected to / able to:
Acquire an in-depth understanding of the fundamental concepts and theories on database and information systems
To understand the general process of database design and development using MS ACCESS 2003
COURSE OUTLINE AND TIMEFRAME
INTRODUCTION
MS Access Fundamentals
What's New in Access 2003
BASIC ELEMENTS of MS ACCESS 2003
Understanding the Access Program Screen
Using Menus
Using Toolbars
Filling Out Dialog Boxes
DATABASES & TABLES
Introduction to Databases
Starting Access and Opening a Database
Tour of a Table
Properties of the fields
Adding, Editing, and Deleting Records
Keystroke and Right Mouse Button Shortcuts
Opening and Modifying Database Objects
Relationships
Working with Multiple Windows
FORMS ,QUERIES & REPORTS
Tour of a Form
Tour of a Query
Tour of a Report
Previewing and Printing a Database Object
Selecting Data
Cutting, Copying, and Pasting Data
OTHER BUTTONS & SHORTCUTS
Using Undo
Checking Your Spelling
Getting Help
Changing the Office Assistant and Using the Button
Using the Zoom Box
Closing a Database and Exiting Access
REQUIRED READINGS
SUGGESTED READINGS
COURSE REQUIREMENTS
Assignments, Quizzes, Exams, Project, Blogs, Links,forums, Tree Planting
CONSULTATION HOURS
____________________
TITLE: HANDS-ON with DATABASE
DEPARTMENT / PROGRAM: BS SECRETARIAL ADMINISTRATION
SEMESTER AND SCHOOL YEAR: 2nd Semester, SY 2007-2008
INSTRUCTOR: MS. IRLYN JANETTE E. LOMBOY
COURSE DESCRIPTION
This course provides fundamental concepts, principles and hands-on experience on database and information system design using MS ACCESS 2003. It is designed as the first database course for Secretarial students who do not have database experiences
COURSE OBJECTIVES (DESIRABLE OBJECTIVES)
Towards the end of the course, students are expected to / able to:
Acquire an in-depth understanding of the fundamental concepts and theories on database and information systems
To understand the general process of database design and development using MS ACCESS 2003
COURSE OUTLINE AND TIMEFRAME
INTRODUCTION
MS Access Fundamentals
What's New in Access 2003
BASIC ELEMENTS of MS ACCESS 2003
Understanding the Access Program Screen
Using Menus
Using Toolbars
Filling Out Dialog Boxes
DATABASES & TABLES
Introduction to Databases
Starting Access and Opening a Database
Tour of a Table
Properties of the fields
Adding, Editing, and Deleting Records
Keystroke and Right Mouse Button Shortcuts
Opening and Modifying Database Objects
Relationships
Working with Multiple Windows
FORMS ,QUERIES & REPORTS
Tour of a Form
Tour of a Query
Tour of a Report
Previewing and Printing a Database Object
Selecting Data
Cutting, Copying, and Pasting Data
OTHER BUTTONS & SHORTCUTS
Using Undo
Checking Your Spelling
Getting Help
Changing the Office Assistant and Using the Button
Using the Zoom Box
Closing a Database and Exiting Access
REQUIRED READINGS
SUGGESTED READINGS
COURSE REQUIREMENTS
Assignments, Quizzes, Exams, Project, Blogs, Links,forums, Tree Planting
CONSULTATION HOURS
____________________
Subscribe to:
Posts (Atom)