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

Organizational behaviour, Rajender Kumar was a production worker at compete...

Rajender Kumar was a production worker at competent Motors Limited (CML) which made components and accessories for the automotive industry. He had worked at CML for almost seven ye

Group discussion - type of qualitative method, Group Discussion: The s...

Group Discussion: The second qualitative methods mentioned above is group discussions (Also referred to as focus groups). In this types of research method the researcher

Flatworms, how do faltworms adapt? how do they enteract with other organism...

how do faltworms adapt? how do they enteract with other organisms? hove do they move?

Method of product/service selection, what is method of product/service sele...

what is method of product/service selection

Explain the sources of international law, SOURCES OF INTERNATIONAL LAW ...

SOURCES OF INTERNATIONAL LAW  International law does not possess formal institutions responsible for creating laws; however, there are certain rules and methods which can help

The working cell, You observe a cell in a solution swelling until it bursts...

You observe a cell in a solution swelling until it bursts. You have seen an instance of osmosis in what?

What is the purpose of planning, Q. What is the purpose of planning? a....

Q. What is the purpose of planning? a. To verify the direction of an organization b. To provide a foundation for team work c. to reduce wastages in the future d. To ma

Hrn quiz 2 chapter 2, In order to add value to the human capital of the org...

In order to add value to the human capital of the organization, A. HR must have good metrics about the HR Side of the business. B. HR managers must be focused on reducing the tota

Management processes in the scor model, Question 1: Describe in detail ...

Question 1: Describe in detail the management processes in the SCOR model. Diagram & Definition of each process Ambit, Main aspects and functions of SCOR model

International business, VK Ltd a multi-product Company,

VK Ltd a multi-product Company,

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