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

Average daily number of garments held overnight, Average daily number of ga...

Average daily number of garments held overnight is a.  15.71 b.  71.42 c.  65.71 d.  68.57 e.  none of the above.

What is scientific management, Scientific management: It is a managemen...

Scientific management: It is a management approach formulated by Frederick. W. Taylor and others (1890 - 1930). It has the idea to develop the best method for performing any ta

Hrm, concept,prospective and importance of hrm in a growing organization?

concept,prospective and importance of hrm in a growing organization?

Organization and operations management, An organization may be defined as a...

An organization may be defined as a group of people working in a group to achieve a common goal. The employees of the organization form different teams and work accordingly to comp

Linear planning programming, a paper mill produce two grades of paper viz....

a paper mill produce two grades of paper viz., x and y. because of raw material restriction,it cannot produce more than 400 tons of grade x and 300 tons of grade y paper in a week

Microbiology, state 2 ways tuberculosis can be caught

state 2 ways tuberculosis can be caught

Engineering project management, You are the project manager for a pharmaceu...

You are the project manager for a pharmaceutical company. You are currently working on a project for a new drug your company is creating. A recent change in a law governing drug te

Centralization, Centralization: Concentrating decision making at a ...

Centralization: Concentrating decision making at a single point in the company makes the company more centralized. Central Bank: Central bank is the national b

Vales, what is the differnce of customer value and the value the customer g...

what is the differnce of customer value and the value the customer gains from owing

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