Mis, management, Management Theories

Problem description:
Your company has a training program to send employees out for basic computer skills. As a new employee with database application experience, you are asked to help HR build a training database to record employee information, training courses, and course enrollment information. You will show your employer your skills on creating a database, building tables and queries, and generating reports.
 
Requirements:
To store employee training information, the database includes three tables, employees, courses, and enrollments. The relationships among them are shown as below. You need to set up relationships, create queries, and generate reports.
 

 
Instructions and requirements:
1. Download the database from Blackboard (BlackboardàAssignmentàhw2à DB.Training.accdb). Right click the file à save on your computerà open it.
2. Set up relationships among these three tables as above (database toolsàrelationships).
3. Set up queries to solve the following three problems.
a. Display the information of the courses (CourseID, Description, Hours, and Prerequisites) which cost more than $150. Name the query as CourseCost.
b. Display the information of the employees (EmployeeNo, LastName, FirstName, DepatNo, Title, Email, and DataHired) who are sales person and locate in San Francisco. Name the query as SalesSF.
c. Display the information of the employees (EmployeeNo, LastName, FirstName, DepatNo, Title, Location, Email, and DataHired) who registered for either Access1 or Access2. Name the query as EmployeeAccess.
4. Generate two reports.
a. Employee information (open employ table). You need to
- Group the employee according to different locations.
- Order the employee first based on their last name, and second based on their first name.
- Change the title to “Employee Information”.
b. Employee who registered for Access class (open EmployeeAccess query). You need to
- View the data by Courses
- Group the employee according to different locations.
- Order the employee first based on their last name, and second based on their first name.
- Change the title to “Employees Registering Access Course”.
Posted Date: 3/10/2012 8:35:47 PM | Location : United States







Related Discussions:- Mis, management, Assignment Help, Ask Question on Mis, management, Get Answer, Expert's Help, Mis, management Discussions

Write discussion on Mis, management
Your posts are moderated
Related Questions
what are the advantages and disadvantages of forced choice

Explain State jurisdiction State jurisdiction concerns essentially the extent of each State's right to regulate conduct or consequences of events. A state has the competence

GENERAL PRINCIPLES OF MANAGEMENT  Thinkers, experts and writers on scientific  management have evolved useful principles to have practical guidance for management operations.

what are the effects of environment on the organization

Control or Eliminate Extraneous Variance: It means the control or elimination of the impact of other independent variables which are likely to influence the dependent

Q. What is recruitment and planning? Goal oriented one, Dynamic, Process, Primary to other management Functions Recruitment is the process of inducing probable candidates ap

A 1- year Canadian bond with a face value of 5000 can be purchased at 4800. a)    Determine the nominal interest rate in Canada. b)    If the Canadian dollar is predicted to de

1. Make proposal that are designed to meet the specific current and future requirements of an organisation, industry or sector. Justify your answers with the example used previousl

Is marginal costing analysis and marginal costing is similar

Researches are now saying that efforts to simplify work tasks have negative results for both companies as well as employees. Do you agree? Why/Why not?