Chat with us, powered by LiveChat Using Microsoft Access and complete a Project activity. The project will ask you to download instructions and starter files for you to use for this project. Wi | WriteDen

Using Microsoft Access and complete a Project activity. The project will ask you to download instructions and starter files for you to use for this project. Wi

Using Microsoft Access and complete a Project activity. The project will ask you to download instructions and starter files for you to use for this project. Within the instructions, there are screenshots of what your end file should look like. 

New Perspectives Access 2016 | Module 1: SAM Project 1a

C:UsersakellerbeeDocumentsSAM DevelopmentDesignPicturesg11731.pngNew Perspectives Access 2016 | Module 1: SAM Project 1a

Healthy Myles Fitness Center

CREATING a table, query, form, and report

GETTING STARTED

Open the file NP_AC16_1a_FirstLastName_1.accdb, available for download from the SAM website.

Save the file as NP_AC16_1a_FirstLastName_2.accdb by changing the “1” to a “2”.

0. 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 Project, you will also need to download and save the following support file from the SAM website:

· Support_NP_AC16_1a_Equipment.accdb

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

You are employed at Healthy Myles Fitness Center and are in charge of consolidating the company’s records and other important information into a database. The owners expect that the database will help them run the business more smoothly. You start by setting up the basic structure of the database.

Create a new table in Datasheet View:

a. Save the table as tblClient. (Hint: Do not type the period.)

b. Change the name of the ID field in the tblClient table to ClientID. (Hint: Do not type the period.)

c. Change the data type of the ClientID field to Short Text.

d. Create the following fields in the table, using the Short Text data type, in the order shown: FirstName, LastName, Address, City, State, and Zip. (Hint: Do not type the period.)

With the tblClient table still open in Datasheet View, enter the records shown in Table 1 on the next page. (If necessary, resize the Address field to best fit the data it contains.) Close the tblClient table, saving if necessary.

Table 1: tblClient Table Records

ClientID

FirstName

LastName

Address

City

State

Zip

A10027

Jenny

Lin

220 Delaware Ave.

Buffalo

NY

14202

B18423

Adam

Smith

266 Elmwood Ave.

Buffalo

NY

14222

Open the tblLocation table in Datasheet View, and then update the table as described below:

e. Change the name of the ID field to LocationID. (Hint: Do not type the period.)

f. Change the data type of the LocationID field to Short Text.

g. Save the table, but do not close it.

With the tblLocation table still open in Datasheet View, change the data type of the LocationOpened field to Date/Time. Save, but do not close, the table.

With the tblLocation table still open in Datasheet View, enter the records shown in Table 2 below into the tblLocation table. Close the tblLocation table.

Table 2: tblLocation Table Records

LocationID

LocationName

LocationOpened

Address

City

State

ZipCode

Phone

301

Elmwood

5/2/2014

1400 Elmwood Ave.

Buffalo

NY

14216

716-555-1212

308

Sheridan

1/5/2015

5200 Sheridan Dr.

Buffalo

NY

14221

716-555-7621

You have been provided with a support file that contains a table with additional equipment data. The tblEquipment table has the same design as the tblGym table in the support file. Copy all the records from the tblGym table in the file Support_NP_AC16_1a_Equipment.accdb, available for download from the SAM website, and paste them at the end of the tblEquipment table in the current database. Close the tblEquipment table.

Use the Simple Query Wizard to create a query based on the tblTrainer table as described below:

h. Include the FirstName, LastName, and Specialty fields (in that order) from the tblTrainer table in the query.

i. Name the query qrySpecialties, and then close the query.

You now want to create a simple form to allow employees to update information on the trainers employed at Healthy Myles Fitness Center.

j. Use the Form tool to create a simple form based on the tblTrainer table.

k. Save the form with the name frmTrainer. (Hint: Do not type the period.)

Switch the frmTrainer form to Form View, use the navigation buttons to navigate to the third record (with the TrainerID field value 454), and then change the Certification field value to ACSM. (Hint: Do not type the period.)

With the frmTrainer form still open in Form View, navigate to the last record (with the TrainerID field value 709) in the frmTrainer form, and then change the Specialty field value to Strength Training. (Hint: Do not type the period.) Navigate back to the first record in the tblTrainer table, and then close the form.

Use the Report tool to create a report based on the tblEquipment table. Save the report as rptEquipmentList, then close the report.

You decide to adjust the formatting of the rptTrainer report to make it easier to read and to make it fit on one page.

l. Open the rptTrainer report in Layout View, and then reduce the width of the TrainerID column so it is approximately as wide as the text “TrainerID” in the column heading, or 0.8".

m. Select the text box that appears below the TrainerID column (and contains the number 9) in the rptTrainer report. Then use the mouse to resize the height of the text box slightly so that it is tall enough to completely display the value it contains, or approximately 0.27" high, as shown in Figure 1 on the next page. Save the report.

n. Select the text box that appears below the Specialty column and that contains the text “Page 1 of 1”. Use an arrow key to move the text box to the left so that its left edge vertically aligns with the left edge of the Specialty column above it. Right-align the text. View the report in Print Preview to see the changes you made. Save and close the report.

Figure 1: rptTrainer Report

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.

2

,

EquipmentID Description Category
E163 Abdominal Bench Strength Training
E379 Leg Press Machine Strength Training

,

IfSuccessful_Status GA_Status_Icon SAM_Logo
true
false
ID FirstName LastName AssignmentGUID UserID
false Delvone Scott {38238291-49A6-45D2-90BA-415490986000} {38238291-49A6-45D2-90BA-415490986000}
ID FirstName LastName ProjectName SubmissionNum MaxScore Score EngineVersion
ID StepNumber Description IfSuccessful StepScore StepMaxScore ErrorText ActionName StepActionOrder
EquipmentID Description Category
E142 Nordic Treadmill Cardio
E497 Sirius Rower Cardio
ID LocationName LocationOpened Address City State ZipCode Phone
TrainerID FirstName LastName Specialty Certification HireDate
146 Jennifer Young Personal Trainer ACE 3/19/14
312 Randy Lee Strength Training NSCA-CSCS 9/27/13
454 Josh Martinez Sports Medicine NATA 11/9/15
585 Cam Williams Sports Medicine NASM 6/10/14
612 Raj Patel Personal Trainer NSCA-CPT 1/4/11
693 Sandy Larson Personal Trainer PTA Global 2/11/15
704 Melissa Rogers Strength Training NSCA-CSCS 6/15/15
708 Carson Garner Personal Trainer NSCA-CPT 2/25/13
709 Richard Sanderson Sports Medicine NASM 6/1/12
SELECT DISTINCTROW * FROM tblTrainer;
SELECT [FirstName] & " " & [LastName] AS StudentName, [_GradingReport].ProjectName, "Submission #" & [SubmissionNum] AS SubmissionCt, [_GradingReport].Score, [_GradingReport].MaxScore, "Score is: " & [Score] & " out of " & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & ". " & [Description] AS Step, [_GradingReportSteps].[StepScore] & "/" & [_GradingReportSteps].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingIcons].GA_Status_Icon, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingIcons].SAM_Logo, [_GradingReportSteps].Description, [_GradingReport].EngineVersion FROM _GradingReport, _GradingIcons INNER JOIN _GradingReportSteps ON [_GradingIcons].[IfSuccessful_Status] = [_GradingReportSteps].IfSuccessful;

HOW OUR WEBSITE WORKS

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of 
HIGH QUALITY & PLAGIARISM FREE.

Step 1

To make an Order you only need to click ORDER NOW and we will direct you to our Order Page at WriteDen. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
 Deadline range from 6 hours to 30 days.

Step 2

Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Discounts

Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.