Mis, management, Management Theories

Assignment Help:
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”.

Related Discussions:- Mis, management

The intervention strategy model, Problem example about the intervention str...

Problem example about the intervention strategy model

Marketing management, people have a peculiar behaviour over a product and w...

people have a peculiar behaviour over a product and why is it so

Steps in work sampling, 1.Decide what activates are defined as working not ...

1.Decide what activates are defined as working not working comprises all activities not specifically defined as working" 2. Observe the worker at selected intervals recording wh

Simplex method, use the simplex method to solve the LP problems: Max Z= 107...

use the simplex method to solve the LP problems: Max Z= 107x1+x2+2x3 subject to 14x1+x2-6x3+3x4=7 16x1+x2-6x3 3x1-x2-x3 x1,x2,x3,x4>=0

Dicipline, explain the principles of disciplining employees.what are the co...

explain the principles of disciplining employees.what are the consequences of enforcing discipline without prior information?

Organizational behaviour, How would you examine if there is any merit in th...

How would you examine if there is any merit in the remarks of various functional managers

Emerging trends, give an account of emerging trends in management

give an account of emerging trends in management

Protozoans, What are the general characteristics of protozoan?

What are the general characteristics of protozoan?

Advantages of field study, Advantages of Field Study: a. They are close ...

Advantages of Field Study: a. They are close to real and they cannot be criticized on the group that they are remote from real settings or are artificial. Field studies are more

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd