Assignment PMIS

.

No.	Topics	Assignment issued	Assignment submitted	Comments
1	Yesser Project Presentation	17/11/2008	29/11/2008
2	Hotel Data base	10/1/2009	19/1/2009

___________________________________________________________________________________



Assignment 1:

Presentation about Yesser Project
1. Read and understand about the topic that chosen for you, write it in word and power point file, with taking the requirements (see below) into consideration
2. Email me the following: word file and power point file
3. Bring to my office the hard copy of the word file only


Objective of this assignment:
1. To get some knowledge about Yesser project
2. To be aware of the MIS future of Saudi Arabia
3. To be more familiar with Ms Word and Power point and this will help you for future assignments.


Word File format requirement:
1. Cover page: put your name, title, lecturer name, date, Course title (Design it as you like)
2. Header: Course title
3. Footer: your name
4. Reference: Superscript on the title (highlight the word then right click -> Fonts -> Superscritp)
5. Page numbers


Power point file format requirement:
1. First slide: put your name, title, lecturer name
2. Second Slide: Outline (Main points)

Your Title

PID	Title
110	About the program: Overview
112	About the program: Organizational structure
113	Strategy and Plan Actions
114	Interoperability framework
115	Government Service bus
116	Government Secure Network
117	e-Government Implementation rules
118	Transformation Measurement Mechanism
101	About the program: Overview
102	About the program: Organizational structure
103	Strategy and Plan Actions
104	Interoperability framework
105	Government Service bus
106	Government Secure Network
107	e-Government Implementation rules
108	Transformation Measurement Mechanism
109	Strategy and Plan Actions

___________________________________________________
Assignment 2:

Building database for a hotel

1. Follow the sheet given in class to Create database system for hotel
2. Each group has to email me the access file
3. Each student individually has to come to my office for grade evaluation

Objective of this assignment:

1. To know how the database works and its benifets
2. To know how to create tables, forms, queries
3. To know how table relationship works throgh lookup fields


You will be asked some of the following questions during grade evaluation:

1. How to create a new database?
2. How to create table?
3. In the table view, What is the differences between "Design view" and "Datasheet view"?
4. How to add new field in a table?
5. How to change the datatype of the fields?
6. How to delete, rename a table?
7. How to filter record?
8. How to create Query?
9. How to create forms?
10. In the forms, What are the differences between "Design view", "Form view" and "Layout view"?
11. How to create Reports?
12. How to print a report?
13. How to create lookup column? (which display a list of values that you can choose from)?
14. How to create lookup column in a table? (Relationships)