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

17/12/2020 Client: saad24vbs Deadline: 7 Days

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


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

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:

Homework Guru
Best Coursework Help
University Coursework Help
Helping Hand
Top Essay Tutor
Writer Writer Name Offer Chat
Homework Guru

ONLINE

Homework Guru

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

$112 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$110 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$112 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$110 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

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

Thatto heath cycle shop - Discussion for Module 5: Leadership Environment - As nzs 4815 current edition - Example of a precipitation reaction - Quality management principles ppt - As calm as simile - A major purpose of closing entries is to - Marketing domain meaning - Asset disposal form template - Communicating using video conferencing and E-GROUP - Ccs uc 200 kit - Electrocomp's management realizes that it forgot to include two - Stopping Out Shopping - Lucian k. truscott iv net worth - Best lens for dental photography - Molander corporation is a distributor of a sun umbrella - What year is othello set in - Math homework forum - The importance of user technology security education within organizations - What is the theme observed in the literary works - Mean value theorem taylor series - Crowned and uncrowned gear teeth - Roman mosaic templates to print - Flipped classroom book pdf - Ystems Perspective and Social Change - Computation - Issues in psychological testing worksheet - Lpc technical bulletin tb 210 - Gestalt therapy dream work - How to teach physics effectively - Respond 43 - Employee training and development raymond noe 6th edition - Pearson vue test centre leeds - Super copy co. is an office supply store. the company uses a perpetual inventory system. - Are amazon go stores profitable - Months in french song - City of women - Business paper - W4 Journa - Business research management - Ethical standards for human service professionals - Rubber belongs to which type of vegetation - 5 kingdoms of cells - GOVT 480 DB FORUM 3 THREAD DUE 9/11/2020 - Double staggered piquet list - Mathematics - Dictionary yahoo hong kong - Sources of error in a circuit lab - Asme viii div 2 - Powerpoint - Kent state ice skating - Earobics free online games - Zlateh the goat plot diagram - Case Study 1: Acceptable Use Policy - 3 pages needed - Homework - Sd card breakout board - Wall street journal review of the given link - How to analyse poems - King's conceptual system - Six methodological components of gestalt therapy - Uses radioisotopes in imaging techniques and the importance of these techniques - How to make an array in mips - Westjet organizational structure - Korman company has the following securities in its portfolio - Carol ann duffy eurydice analysis - Discussion q for swarm - Economic and business - How does partnership working deliver better outcomes - Organisational culture and its impact on employees behaviour ppt - Research paper and ppt for info security - Charlotte the harlot lay dying - My love is like a red red rose poem analysis - Todd harbaugh age - BW Texas Gov't Opinon Essay Unit 3 - Greek word translated to mean "diligence in the pursuit of moral and physical excellence”. - International retinal research foundation - Direct vs indirect interview - English Editing Needs Suggested by the Read Aloud - Psychology - Gokul rajaram iit jee rank - Style lessons in clarity and grace answer key - Combating fake news in the digital age joanna m burkhardt - Home video game industry case study - Peer review essay worksheet - Internet Programming by Murach ( asp.net Core MVC) QUIZ - Customer a with a bronze service level package - CC W 7 D - Extra Credit - How have electronic media and their convergence transformed journalism - Case project 10-2: restricting registration - Arriva bus times milton keynes 8 - Dynamic and pitch ranges expanded and tempi varied dramatically because - Culture in Nursing DQ 14 student reply Vanessa Camano - What was the human toll of the great depression - Absolute location of asia - Human Resource Management_ppt3 - Tidal river camping map - Nitrogen at an initial state of - The case for the contingent exclusionary rule