Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Modules 1 4 sam capstone project 1a

13/10/2021 Client: muhammad11 Deadline: 2 Day

Improve a database by creating and modifying tables, queries, forms, and reports

GETTING STARTED
Open the file IL_AC19_CS1-4a_FirstLastName_1.accdb, available for download from the SAM website.

Save the file as IL_AC19_CS1-4a_FirstLastName_2.accdb by changing the “1” to a “2”.

If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:

Support_AC19_CS-1-4a_Industries.xlsx

Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

Midwest Executive Professionals is a firm that connects professional job seekers with job openings. You work in the Research Department of Midwest Executive Professionals as a research analyst. You are developing an Access database application to help manage and analyze companies, jobs, applicants, and job placements facilitated by your company. In Design View of the Applications table, modify the table with the following instructions:

Add a new field after the ApplicationDate field named FollowupDate with a Date/Time data type.

Use ApplicationID to rename the ID field. Save and close the Applications table.

In Datasheet View of the JobSeekers table, complete the following instructions:

Delete the record for Richard Marlay (JobSeekerID 14).

Edit John to be Jonathan for JobSeekerID 10.

Enter a new record into the table using the information in Table 1. Close the JobSeekers table.

Table 1: New Record for JobSeekers Table

JobSeekerID

(AutoNumber will automatically number this field)

FirstName

Leonardo

LastName

Eagan

Phone

5551118887

In the Navigation Pane, make Industries the new name for the Categories table.

Use the import wizard to append the records from the Support_AC19_CS-1-4a_Industries.xlsx to the Industries table. Do not save the import steps. (Hint: If a warning message appears, Click Open.)

Create a new table in Table Design View with the following specifications:

Enter Employees as the name of the new table.

Add a new field named EmployeeID with the Number data type. Set it as the Primary key field.

Add two new fields named EmployeeFirst and EmployeeLast in the order shown. They should have the Short Text data type and field size properties of 20.

Add a new field named Email with the Hyperlink data type. Set the Required property to Yes.

Add a new field named Salary with the Currency data type. Set the Default Value property to 45000.

Add a new field named Extension with the Short Text data type. Update the Input Mask property using the Input Mask Wizard. Select the Extension input mask and update the field to 9999, so that 9999;;_ is the final input. Accept the default in the last window. Save the table and then close it.

In Datasheet View of the JobSeekers table, complete the following options:

Delete the Comments field. (Hint: It currently does not have any data.)

Move the Phone field to be the last field in the datasheet.

Sort the records in ascending order by LastName. Save and close the JobSeekers table.

Create a new query in Design View using the Companies and Jobs tables with the following options:

Select the CompanyName and Industry fields from the Companies table and the JobTitle and StartingSalary fields from the Jobs table.

Join the tables using the CompanyID field from the Companies table and the Company field from the Jobs table.

Save the query, using HighSalaries as the name.

With the HighSalaries query still open in Design View, add criteria to select only those records where the StartingSalary is greater than or equal to 50000, save the query, switch to Datasheet View as shown in Figure 1, and then close it.

Figure 1: HighSalaries Query in Datasheet View

Use the Simple Query Wizard to create a new query with the following options:

Use the JobSeekers and Applications tables.

Select all four fields from the JobSeekers table and the ApplicationDate field from the Applications table.

Create a detail query.

Use ApplicationDates as the title for the query. Save and close the query.

In Design View of the ApplicationListing query, modify the query with the following options:

Add criteria to select all records with Administrative Assistant or User Support Director as the JobTitle.

Sort the records in ascending order by LastName, and then by FirstName. Run the query to display it in Datasheet View as shown in Figure 2, and then save and close it.

Figure 2: ApplicationListing Query in Datasheet View

In Design View of the DirectorSeptember query, add criteria using wildcard characters to select all records with Director anywhere in the JobTitle field and an ApplicationDate greater than or equal to 9/1/2018. Run the query to display it in Datasheet View as shown in Figure 3, and then save and close it.

Figure 3: DirectorSeptember Query in Datasheet View

Use the Form Wizard to create a new form with the following options:

Select all of the fields from the Jobs table.

Choose a Columnar layout.

Use JobsEntry as the title. Save and close the JobsEntry form.

Use the Report Wizard to create a new report with the following options:

Select all of the fields from the Companies table.

Group the records by Industry.

Sort the records in ascending order by CompanyName.

Use a Stepped layout and a Portrait orientation.

Use CompanyListing as the title. Preview, save, and close the report.

Open the JobSeekerEntry form in Form View, enter Jacob as the FirstName value for the first record to replace Jack, and then add a new record in the main form with the information in Table 2.

Table 2: New Record for JobSeekerEntry Form

JobSeekerID

(AutoNumber field will automatically increment)

FirstName

Camilla

LastName

Escobar

Open the JobSeekerEntry form in Layout View and modify it with the following options:

Right-align the text in the JobSeekerID, FirstName, and LastName labels.

Edit the FirstName label to read First Name and use Last Name to rename the LastName label.

Delete the Close command button in the Form Footer section.

With the JobSeekerEntry form still open in Layout View, modify it with the following options:

Add the Phone field to the form and position it just below the Last Name label.

Change the font color for the Phone label to Automatic (black).

Apply a quick style, Colored Outline – Blue, Accent 1 (first 1st row second 2nd column of Theme Styles gallery) to the Close command button in the Form Header section. Display the form in Form View as shown in Figure 4, and then save and close it.

Figure 4: JobSeekerEntry Form in Form View

Open the JobListing report in Layout View and add conditional formatting so that any StartingSalary value greater than or equal to $70,000 is formatted using Green 3 background color (7th column, 4th row in the Standard Colors pallete). Save the JobListing report.

With the JobListing report still open in Layout View, modify it with the following options:

Change the background color of the Starting Salary label in the Page Header section to the same color, Green 3 (7th column 4th row in the Standard Colors palette).

Group the two labels in the Report Header section together in a tabular layout. Save and display the report in Report View as shown in Figure 5, and then close it.

Figure 5: JobListing Report in Report View

In Layout View of the JobSeekerListing report, modify it with the following options:

Change the Theme Colors to Green .

Change the Theme Fonts to Franklin Gothic. Display the report in Report View as shown in Figure 6, and then save and close it.

Figure 6: JobSeekerListing Report in Report View

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Quick Finance Master
Calculation Guru
Top Academic Guru
Instant Assignment Writer
Buy Coursework Help
Math Exam Success
Writer Writer Name Offer Chat
Quick Finance Master

ONLINE

Quick Finance Master

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$50 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$47 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$44 Chat With Writer
Instant Assignment Writer

ONLINE

Instant Assignment Writer

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$16 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$25 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$20 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Communicable disease article hcs 457 - Coe lesson plan template gcu - The old oaken bucket poem questions and answers - Portals and Banner Ads - Putting the brakes on teenage driving speech analysis - Sean hennessy tumble dryer - Strategic management 9th edition dess pdf - Anzca primary exam curriculum - Magnets for ears for weight loss - If poem by rudyard kipling pdf - Given the linear program max 3a 4b - Wechsler fundamentals academic skills report - Consists of several layers of cells allowing an expandable lining - Skinpen by bellus medical for sale - Hendrich ii fall risk model pdf - Aims and objectives ppt - Language attitude questionnaire sample - Concept Paper - Finding childcare essay - The judgement kafka sparknotes - When was the poem war photographer written - Nelson mandela long walk to freedom ppt - Point loma nazarene university essay prompt - Chemical equation of elephant toothpaste - Imo sample papers for class 7 - What is psychoanalysis in literature - Racism in othello act 4 - There is a design methodology called rapid prototyping - Analytical research - Recorded services provided on account journal entry - Escalation of Commitment and Ethics in Decision Making - Comparative politics today a world view notes - Dawn alcohol water ice melt snopes - How long did johnny cash spend in prison - Cry havoc and let slip the dogs of war speech - Supply chain management walmart case study - Enitity Relationship diagram - Ict equipment list for office - Grandma's experiences leave a mark on your genes - Atkins or fadkins answers - Marius reflects the problems of the late republic in that he - 66/18 cecilia street marrickville - Mendelow's power interest grid - Dr nicole goddard oncologist canberra - Which of the following is an insurable risk - Raf recruitment and retention pay - System analysis and design template - 1/15 vernon street nundah - Caulfield blood donor centre - Mountain view community hospital er diagram - Boy in striped pyjamas chapter summary - Relyx ceramic primer instructions - How to hire ghost writers UK for my homework? - Prince charles palliative care - Example of a refutation - Financial and managerial accounting edition williams - Clc 004 market research test answers - 25 gatwick road bayswater north - Weber genesis silver 8133 parts - A pump draws water from a reservoir - Whistleblower claims accounting shenanigans at successfactors - The Presentation - Roman jakobson on linguistic aspects of translation pdf - Unit 5 IP Monitoring and Evaluating New Programs - How to test for non reducing sugars - According to geertz the core of religion is - Passengers on a carnival ride move at constant speed - Sodium borohydride reduction of 2 methylcyclohexanone - Bombardier erp implementation case study - Gsu panther id lookup - Project 1 - Dan murphys phillip island - Cost sheet of amul pdf - Crisis management - Baby you re a firework song - Ipv6 fundamentals 2nd edition pdf - Computer security basics 2nd edition pdf download - Westwood one minute addition and subtraction test - Assignment - Mva to mw power factor - 69 hall street semaphore - Margaret atwood happy endings essay - Azim premji leadership style ppt - Social learning theory career counseling - What is a stopple fitting - 2 x 2 perceptual positioning map - Expertise in nursing practice caring clinical judgement and ethics - Description of a walk robert gray annotations - Internet Marketing - Calhoun community college bookstore - English 1302 - Pestilent park rage 2 storage containers - Mississippi burning film techniques - A level biology exam questions by topic cie - Solve the recurrence relation - History 2A - Discussion Questions - Apt asia pacific telecommunity - Macroeconomics principles and policy edition answers - The ______ states that two species cannot coexist indefinitely in the same niche.