access sam capstone project 1

View SAM Project Answer Keys

View the correct answers for SAM projects.

• Click SAM assignments .

• Click the file under Solution File to download it to your computer.
• Open the solution file.

Provide details on what you need help with along with a budget and time limit. Questions are posted anonymously and can be made 100% private.

Studypool matches you to the best tutor to help you with your question. Our tutors are highly qualified and vetted.

Your matched tutor provides personalized help according to your question details. Payment is made only after you have completed your 1-on-1 session and are satisfied with your session.

Access Modules 1-4 SAM Capstone Project

User Generated

jvgulbh2013

Description

Complete the Access capstone project for T1-T4

as soon as possible please

Unformatted Attachment Preview

Explanation & Answer

The database file needs to have you names i found th...

24/7 Homework Help

Stuck on a homework question? Our verified tutors can answer all questions, from basic  math  to advanced rocket science !

Similar Content

Related tags.

essay management informal numbers value privacy rights taks overland trucking Boston Crab Meat analytics educational case study digital

The Mayor of Casterbridge

by Thomas Hardy

Crime and Punishment

by Fyodor Dostoyevsky

The Outsiders

by S.E. Hinton

by William Shakespeare

Rules Of Civility

by Amor Towles

The Curious Case of the Dog in the Night Time

by Mark Haddon

by Herman Melville

Dandelion Wine

by Ray Bradbury

by Anonymous Anglo-Saxon poet

working on a homework question?

Studypool is powered by Microtutoring TM

Copyright © 2024. Studypool Inc.

Studypool is not sponsored or endorsed by any college or university.

Ongoing Conversations

Access over 20 million homework documents through the notebank

Get on-demand Q&A homework help from verified tutors

Read 1000s of rich book guides covering popular titles

Sign up with Google

Sign up with Facebook

Already have an account? Login

Login with Google

Login with Facebook

Don't have an account? Sign Up

New User? Register

Fill This Form To Receive Instant Help

Homework answers / question archive / Illustrated Access 2019 | Modules 1-4: SAM Capstone Project 1a Midwest Executive Professionals Improve a database by creating and modifying tables, queries, forms, and reports   GETTING STARTED Open the file IL_AC19_CS1-4a_FirstLastName_1

Illustrated Access 2019 | Modules 1-4: SAM Capstone Project 1a Midwest Executive Professionals Improve a database by creating and modifying tables, queries, forms, and reports   GETTING STARTED Open the file IL_AC19_CS1-4a_FirstLastName_1

Share With -->

Illustrated Access 2019 | Modules 1-4: SAM Capstone Project 1a

Midwest Executive Professionals

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

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

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.

Fill The Details Below To Receive Instant

Homework help, low cost option, download this past answer in few clicks, purchase solution.

Already member? Sign In

Custom new solution created by our subject matter experts

Get a quote.

GET ANSWER TO THIS QUESTION

100% UNIQUE SOLUTION WITHIN FEW HOURS

rated 5 stars

Purchased 7 times

View Answer

Sitejabber (5.0)

Trustpilot (4.9)

Google (5.0)

Related questions.

• New Perspectives Access 2019 Module 9 SAM Project 1b Ridgedale College CREATING ACTION QUERIES AND MODIFYING THE NAVIGATION PANE GETTING STARTED Open the file NPAC199bFirstLastName1
• New Perspectives Access 2019 Module 3 End of Module Project 1 Homestead Partners Creating and Improving Queries GETTING STARTED Open the fileNPAC19EOM31FirstLastName1
• Shelly Cashman Access 2019 Module 4 SAM Critical Thinking Project 1c Personal Insurance Inc
• Shelly Cashman Access 2019 Module 10 SAM Project 1a Personal Insurance Inc
• Illustrated Access 2016 Module 8 SAM Project 1a Dive Trips Database ANALYZING DATA WITH REPORTS GETTING STARTED bull Open the file ILAC168aFirstLastName1
• Business Intelligence at Super Skateboard Builders SSB Inc
• New PerspectivesAccess 2016 Module 5 SAM Project 1b GRMH Recreation Centers CREATING SPECIALIZED QUERIES AND ENHANCING A DATABASE GETTING STARTED Open the fileNPAC165bFirstLastName1
• Fees and services change to respond to customers39 needs
• Shelly Cashman Access 2016 Module 8 SAM Project 1b All Around Outside Maintenance MACROS NAVIGATION FORMS CONTROL LAYOUTS GETTING STARTED Open the file SCAC168b FirstLastName 1
• New Perspectives Access 2019 Module 1 Sam Project 1a Global Human Resources Consultants CREATING AND MODIFYING TABLES AND OTHER DATABASE OBJECTS GETTING STARTED Open the file NPAC191aFirstLastName1

Help in Homework

• Don't have an account. Register Now
• Forgot Password?. Reset Password

Please enter your email address and we'll send you instructions on how to reset your password

• Already have an account? Log In

The Ohio State University

• BuckeyeLink
• Search Ohio State

2024 Annual Engineering Design Showcase

The Annual Engineering Design Showcase is a culmination of senior undergraduate capstone design projects from all engineering disciplines. Individual students or student teams present their projects and selected findings to industry, the OSU community and the general public. The Capstone Design Showcase is coordinated and administered by the Department of Engineering Education (EED) in collaboration with capstone faculty throughout the College of Engineering.  This year's Engineering Design Showcase was held on April 23, 2024. More than 200 student groups presented, 24 of which featured BME students. 

For their senior  capstone projects  undergraduate students in engineering collaboratively work toward developing innovative solutions to real world problems identified by local sponsors. These multidisciplinary capstone projects offer students the opportunity to apply the knowledge they gained in their coursework through hands-on experience, collaboration, project management and direct interaction with industry and clinical professionals. Some of the capstone projects include industry sponsors, like MedforAll which focuses on providing technologies for supporting individuals with developmental disabilities at their homes. Alexis Ortiz-Rosario , associate professor of practice who teaches capstone courses has been collaborating with MedforAll for five years for BME capstone projects.

Professor of Practice Mark Ruegsegger , who teaches a Senior Design Capstone course and helped organize the Design Showcase shared “This was undoubtedly one of our strongest years in the Senior Design Capstone course! We had 24 student teams, 7 engineering mentors (4 BME, 3 MAE) and 20+ clinical and industry partners. The teams worked well together while solving open-ended, real-world medical problems. Several teams collaborated with Computer Science and Engineering teams to integrate hardware and software, and three teams were part of a pilot program that involved 4 th year OSU medical students as the clinical liaison of the project.  This course is successful because of the dedication of the students to making device prototypes that will have real impact for potential users.”

BME Student Capstone Projects

All of the BME capstone projects offered creative applications of student knowledge to create innovative solutions to real-world problems. Students at the Engineering Design Showcase were eager to share their solutions, as well as what they wish they had more time to improve in their designs. It was clear that students came away from these projects with a deeper understanding of the challenges in developing medical devices, the importance of user-centered testing, and a deepened appreciation for genuine collaboration.

Amplify Bio Multi-Dose Dry Powder Inhaler: Fluids

Student Team: Kevin Dunn, BME; Riley Hildebrant, BME; Jake Lausner, BME; Matt Lin, BME

Faculty Mentor: Lauren Eichaker

Amplify Bio Multi-Dose Dry Powder Inhaler: Housing

Student Team: Skylar Lynch, BME; Alex Poh, BME; Emily Yi, BME; Lizzie Kemerer, BME; Quentin Walker, BME

Amplify Bio Multi-Dose Dry Powder Inhaler: Reservoir

Student Team: Zach Alleman, BME; Liz Breda, BME; David Fraas, BME; Kira Katterle, BME

Medforall Remote Vital Monitoring: Hardware

Student Team: Elliot Limpach, BME; George Worly, BME; Lili Hurst, BME; Nathan Waltz, BME

Faculty Mentor: Alexis Ortiz-Rosario

Remote Vital Monitoring: Software

Student Team: Charlie Lenk, BME; Zoe Kayafas, BMA; Daniel Kimnach, BME

Remote Vital Monitoring: Housing

Student Team: Eli Wiertel, BME; Jackson Beeching, BME; Devin Medved, BME

Remote Vital Monitoring: Integration

Student Team: Mabel Lee, BME; Anoushka Dasi, BME; Amiri Diop-West, BME

Student Team: Srujan Jaladi, BME; Peter Kowalski, BME; Ryan Leo, BME; Chethana Yerramsetty Prashant, BME

Faculty Mentor: Tanya Nocera

Student Team: Lara Schober, BME; Roxanne Vermette, BME; Kyle Watts, BME; Lizzy Woodhouse, BME

Student Team: Ethan Hessick, BME; Rachel Horvath, BME; Avneesh Pradhan, BME

Student Team: Eli George, BME; Steven Maouri, BME; Ben Wang, BME; Samuel Heinz, BME

Faculty Mentor: Ayanga Hereid

Student Team: Ian Campbell, BME; Joe Farroha, BME; Lauren Gastineau, BME; Allison Smith, BME; Allen Crimmel

Student Team: Lauren Lubin, BME; Abigail Lupo, BME; Maddie Lyon, BME; Sydney Ripsky, BME; Sydney Wiggins, BME

Faculty Mentor: Mark Ruegsegger

Student Team: Sam Harmeyer, BME; Josh Henke, BME; Ahmad Madhwala, BME; Beckham Retzler, BME; Matthew Starkey, BME

Student Team: Garrett Herb, BME; Louie Melaragno, BME; Aspen Schneller, BME; Michael Terveer, BME

Student Team: Balaji Kurapati, BME; Mitchell Lewis, BME; Neil Ott, BME; Arian Seighali, BME; Dominic Veltri, BME

Student Team: Belquis Mbayu, BME; Danny Meringolo, BME; Bobby Smallwood, BME; Keely Yeargin, BME

Faculty Mentor: Tony Luscher

Student Team: Katie Jones, BME; Claire Loos, BME; Michelle Mosko, BME; Jillian Mundo, BME; Esther Ku, BME

Student Team: Harrison Andary, BME; Ryan Lang, BME; Christopher Santiago, BME

Student Team: Adia Holtman, BME; Matt Mlawski, BME; Taylor Nguyen, BME; Joseph Tinapple, BME

Student Team: Kyle Borah, BME; Andrew Gruber, BME; Ethan Lehmkuhl, BME; Mitchell Pittman, BME

Student Team: Ross Aiello, BME; Trinity Dort, BME; Chikamnele Nkwocha, BME; Jason Rosario, BME; Megan Zukowski, BME

Faculty Mentor: David Hoelzle

Student Team: Morgan Crews, BME; Anthony Elbon, BME; Nikhil Nandyala, BME; Emma Randall, BME; Amalin Suwaid, BME

Student Team: Zuhaib Jama, BME; Adam King, BME; Alaina Scavuzzo, BME; Grant Schrieber, BME; Sajah Tahat, BME

Student Team: Grace Dunn, BME; Pranav Kandula, BME; Steven Price, BME; Adrienne Vala, BME; Mariah Walker, BME

Student Team: Isha Davit, BME; Celine Ertin, BME; Nathaniel Heuman, BME; Joey Rancitelli, BME; Armon Sekhavat, BME

More photos from the 2024 Engineering Design Showcase can be accessed via OneDrive with an Ohio State login

Story by Rebecca Hudgins, Department Coordinator for BME | [email protected]

Related News