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

Healthy myles fitness center

14/11/2020 Client: papadok01 Deadline: 24 Hours

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

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.pngNew Perspectives Access 2016 | Module 2: SAM Project 1a

Healthy Myles Fitness Center

UPDATING TABLES, ADDING RECORDS, AND CREATING RELATIONSHIPS

GETTING STARTED
· Open the file NP_AC16_2a_FirstLastName_1.accdb, available for download from the SAM website.

· Save the file as NP_AC16_2a_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 Project, you will also need to download and save the following support files from the SAM website:

· Support_NP_AC16_2a_Clients.accdb

· Support_NP_AC16_2a_Location.txt

· Support_NP_AC16_2a_Billing.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
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. You have already set up the basic structure of the database, and you are now updating some information and creating relationships to make information more useful and easier to locate.

Open the tblTrainer table in Design View, and then set the field properties shown in Table 1 on the next page. Be sure to set the TrainerID field as the primary key for the table.

Table 1: tblTrainer Table – Field Properties

Field Name

Data Type

Description

Field Size

Other

TrainerID

Short Text

Primary Key

Caption: Trainer ID

FirstName

Short Text

20

Caption: First Name

LastName

Short Text

25

Caption: Last Name

Interests

Long Text

Add a new field to the table after the Interests field. Use the following options (some of which may already default to the values shown below):

a. Field name: Minors

b. Data Type: Yes/No

c. Format Property: Yes/No

d. Caption Property: Accepts Minors

e. Default Value: No

Delete the College field from the table. Save the tblTrainer table. (Hint: Click the Yes button when warned that you are about to delete one record, and click Yes again if you are warned about potential data loss.) Switch to viewing the tblTrainer table in Datasheet View.

While viewing the tblTrainer table in Datasheet View, move the Interests field to the left of the HireDate field.

While viewing the tblTrainer table in Datasheet View, update the following records to indicate that these trainers will accept clients who are minors: Randy Lee (TrainerID 312), Raj Patel (TrainerID 612), and Carson Garner (TrainerID 708). Save and close the table.

Create a new table in the database with the name tblClient by importing the structure of the tblClient table in the file Support_NP_AC16_2a_Clients.accdb, available for download from the SAM website, into the current database. Do not save the import steps.

Open the tblClient table in Design View, and then update the field properties using the information in Table 2 on the next page. Be sure to set the ClientID field as the primary key for the table. When you have finished, save the tblClient table.

Table 2: tblClient Table – Field Properties

Field Name

Data Type

Description

Field Size

Other

ClientID

Short Text

Primary Key

6

Caption: Client ID

State

Short Text

2

Default Value: NY

Zip

Short Text

10

Phone

Short Text

15

Gender

Short Text

F (Female), M (Male)

1

Switch the tblClient table to Datasheet view, then add the records shown in Table 3 below. Close the tblClient table when you are finished.

Table 3: tblClient Table – Records

Client ID

FirstName

LastName

Address

City

State

Zip

Phone

Birth Date

Gender

A10025

Alfred

Pineda

465 Grant St.

Buffalo

NY

14213

716-555-4815

12/15/1964

M

B10216

Maria

Johnston

701 Washington St.

Buffalo

NY

14203

716-555-9855

2/28/1971

F

Your supervisor exported his existing location data to a text file, and he asks you to add this data to the tblLocation table. Import the data as follows:

f. Specify the file Support_NP_AC16_2a_Location.txt, available for download from the SAM website, as the source of the data.

g. Select the option to append a copy of the records to the tblLocation table.

h. In the Import Text Wizard dialog boxes, choose the option to import delimited data, to use a comma delimiter, and to import the data into the tblLocation table. Do not save the import steps. Open the tblLocation table in Datasheet view to confirm that the data imported properly, then close the table.

Use the Import Spreadsheet Wizard to add data to the tblBilling table from an Excel spreadsheet as follows:

i. Specify the file Support_NP_AC16_2a_Billing.xlsx, available for download from the SAM website, as the source of the data.

j. Select the option to append a copy of the records to the tblBilling table.

k. In the Import Spreadsheet Wizard dialog boxes, choose the Sheet1 worksheet, and then import to the tblBilling table. Do not save the import steps. Open the tblBilling table in Datasheet view to confirm that the data imported properly, then close the table.

Add the tblTrainer, tblBilling, and tblClient tables to the Relationships window. Use the mouse to resize the field list for each table shown in the Relationships window so all fields are visible in the field list. Define a one-to-many relationship between the primary tblTrainer table and the related tblBilling table using the TrainerID field. Choose the options to enforce referential integrity and to cascade updates to related fields.

Define a one-to-many relationship between the primary tblClient table and the related tblBilling table using the ClientID field. Choose the options to enforce referential integrity and to cascade updates to related fields. Figure 1 below shows the completed Relationships window. Save and close the Relationships window.

Figure 1: Relationships Window

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

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:

Buy Coursework Help
Quality Homework Helper
Finance Homework Help
Custom Coursework Service
Writer Writer Name Offer Chat
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

I have a Master’s degree and experience of more than 5 years in this industry, I have worked on several similar projects of Research writing, Academic writing & Business writing and can deliver A+ quality writing even to Short Deadlines. I have successfully completed more than 2100+ projects on different websites for respective clients. I can generally write 10-15 pages daily. I am interested to hear more about the project and about the subject matter of the writing. I will deliver Premium quality work without Plagiarism at less price and time. Get quality work by awarding this project to me, I look forward to getting started for you as soon as possible. Thanks!

$55 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

Hey, Hope you are doing great :) I have read your project description. I am a high qualified writer. I will surely assist you in writing paper in which i will be explaining and analyzing the formulation and implementation of the strategy of Nestle. I will cover all the points which you have mentioned in your project details. I have a clear idea of what you are looking for. The work will be done according to your expectations. I will provide you Turnitin report as well to check the similarity. I am familiar with APA, MLA, Harvard, Chicago and Turabian referencing styles. I have more than 5 years’ experience in technical and academic writing. Please message me to discuss further details. I will be glad to assist you out.

$55 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

To an athlete dying young questions and answers - 8week6 Indiv - Uncollected goods left for repair - Eng 122 week 1 content quiz - ¿son mexicanos los amigos de ustedes? (puertorriqueños) - Module 2_DisasterRecovery - Jerry seinfeld dad season 1 - Help - Political Cartoon - Perception and individual decision making case study - Determine the machine’s second-year depreciation using the double-declining-balance method. - Https mycampus phoenix edu login asp - Horizontal expansion of job - ADR - Thank you letter assignment - How to calculate mass in physics - Determination of ethanol in wine by gas chromatography - 4-45 Cost Accumulation and Allocation - Internal resistance of a cell experiment conclusion - Is a surd a rational number - Mgt 450 week 1 assignment - Probability statistical inference hogg pdf - How to calculate reticulocyte count - ANSWER TO PEER, SIMILARITIES LESS 5%, REFERENCES 1, APA 6 - Ray bradbury the last night of the world analysis - One of your customers is delinquent on his accounts - Our vanishing night by verlyn klinkenborg - Serial murder - Paragraph describing a cave - Review test - Pka1 and pka2 of maleic acid - SLO's - The crisis no 1 analysis - Amp letter of compliance - Writing compare and contrast essay between baseball and football - Organic chemistry 9th edition - Canadian writer's handbook essentials edition pdf - Quick answer - Human Resource Management_ppt3 - Conflict resolution paper example - Push pull legs workout routine pdf - Powerpoint Statistics - A spherical concave mirror has a radius - Film Analysis - PLUGGED IN - Skin Disorders - Macbeth wading through blood quote - Is 96 a prime or composite number - How do you pronounce humuhumunukunukuapua a - For Essays Guru - - Jack welch ge case study - Acc 202 final project presentation to investors - Conveyor belt project part 3 - 4 concepts of nursing theory - Pope water timer instructions - Guess the sweet quiz - 7 habits of highly effective teens activities - Simnet ju - Office 2010 box plot - CIS450 Discussion Mod 5: - Uva ltac - Week 4 6640 - New employee request form - Nutrition assignment for nursing - Midland energy case study - Contextual meaning of the underlined phrases - The strategic role of operations management - Politics and the Patient Protection and Affordable Care Act - Writing logically thinking critically exercise 6a - 6 year old child observation report - Essay dos and don'ts - Project Power Point - Plot segmentation example - 3 4 6 in simplest form - Erosion and deposition worksheet - Big bad wolf dressed as grandma - Cowra freight sydney depot - Rachael ray sauteed red cabbage - What are the defining characteristics of the phylum porifera - Cdu semester 2 start date - Instalar tonos gratis para teléfonos móviles - The eagle has landed dog whistle - Curtin artificial reef map - A baseball in the air - Cinema symbolism pdf - Domain analysis model example - Assessment health and illness beliefs - Right hand rule positive or negative - How to write a personal creed - Importance of employee life cycle - Main causes of fire in nhs - Love the lingo vce english language - Written Assignment - Ethnic Strife In The U.S (Sociology) - The fifth month of the year - Www encarta msn com encnet features dictionary dictionaryhome aspx - Public Speaking-4 - Netflix value chain analysis 2017 - Udavum karangal anna nagar - 1 page essay single - Describe strength and weakness of hotel marketing - Perie process