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

Decision trees solved starting in present working in future., Decision tree...

Decision trees are solved by starting in the present and working  into the future. TRUE          FALSE

cost control and rent extraction, Think of a state where the regulator is ...

Think of a state where the regulator is uncertain as to the true cost of the regulated firm. Also, the firm (the firm's management) can work harder or less hard to control costs; i

Cost center, Cost Center: A unit, whether a department, process, piece...

Cost Center: A unit, whether a department, process, piece of equipment, or individual, within an organizations to which direct costs can be attributed.  In addition to straigh

MIS, How to prepare an estrategy plan for an organization.

How to prepare an estrategy plan for an organization.

Bridgestone, to increase sells marketing strategies in europe

to increase sells marketing strategies in europe

Common stock, Common Stock: Certificates that present ownership to cor...

Common Stock: Certificates that present ownership to corporation usually mature stock shareholders have the right to vote for the election of commercial directors. In privatel

Control or eliminate extraneous variance, Control or Eliminate Extraneous ...

Control or Eliminate Extraneous Variance: It means the control or elimination of the impact of other independent variables which are likely to influence the dependent

Hierarchy of needs, Hierarchy of Needs Probably the most well-know...

Hierarchy of Needs Probably the most well-known theory of motivation, Maslow's hierarchy of wants suggests that every human being has a hierarchy of five requirements. An

Socialization, definition, assumption & process

definition, assumption & process

Mg101, in relation to growing diversity of human resource what challenges d...

in relation to growing diversity of human resource what challenges does management pose

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