Mis, management, Problem description: Your company has a training program to send, Management Theories

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”.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

Mis, management, Management Theories

Related Discussions:- Mis, management

what is costco''s business model, What is Costco''s business mode

Sales management , approaches in management

Relevance of e-retailing, What are the relevance of e-retailing in differen...

Management accounting and finance 2, 1. INTRODUCTION 2. SIMILARITIES & DIFF...

Marketig, core concepts of marketing

Thesis, Litrature review on personnel management in public sector for susta...

Characteristics of management, Characteristics of management: 1. Manag...

Home inverse demand, Suppose that two national champions are active in the ...

Fundamental managment, what is the issues of financial manager?

Traditional management, explain the inadquacies of traditional model ofmana...

Write Your Message!

Featured Services

Online Tutoring

Project Development

Exam Preparation

Course Help

Assignment Help

Popular Subjects

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT