User Account

All Pages

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

Strategies of teamwork, recommendation of issues in team

recommendation of issues in team

Register systems, Register Systems The earliest method of chargin...

Register Systems The earliest method of charging books for home use was a relatively simple one of writing the author, title and borrower's name in a 'Day book'. A 'Day b

Planning function in Management, Hi, I have to do an assignment on Planning...

Hi, I have to do an assignment on Planning function in orgnisation, I am finding it difficult. If anyone can help me on this it would be really appreciated. Regards, Iman

What are the characteristics of management, CHARACTERISTICS OF MANAGEMENT ...

CHARACTERISTICS OF MANAGEMENT 1. Management is good oriented. It achieves the organizational goals by coordination of the efforts of the personnel. 2. Management works as a

Lean management, I want an essay of 500 words on lean management.

I want an essay of 500 words on lean management.

How does a crm help business to grow, CRM methods that go beyond technology...

CRM methods that go beyond technology, helping companies attain and retain customers, build lasting relationships, improve loyalty, gain insight, and execute customer-focused metho

Analysis what suites you and your client best, In line with the integrative...

In line with the integrative approach of this unit you are asked to choose a topic which reflects the skills needed to be a successful International Manager.  You are asked to comb

SELECTION PROCESS, what is the steps of humman resource management SELECTIO...

what is the steps of humman resource management SELECTION PROCESS

The service facility is a combination , The service facility is a combinati...

The service facility is a combination of a. Arrival rates and service rates. b. Servers and customers. c. Queue length and queue discipline. d. Channels and phases.

Haberlers ( neo classical theory), Plz give explanation to this breifly

Plz give explanation to this breifly

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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