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

Sociology questions about social media - 2-2 - APA Title & Reference Page - Management - Static systems bedhead trunking - Module 2: Generic Types of Business Processes and IT Systems - Christophe rault sciences po - Aco vs ppo - Pwm duty cycle vhdl - Mcdonald's marketing case study - Sample soap note nurse practitioner - Nursing - Tim o brien style of writing - How do waves cause erosion and deposition - Golden research thoughts journal - Paragraphs and essays 13th edition pdf - Enron ethics case study - S1 discrete random variables - How to calculate outcomes - Johnson and johnson stock buyback - Www testingforschools com customer id - If mc002 1 jpg what is the value of x - English - D2 - 494 glenhuntly road elsternwick - Quantitative Decision Making - Lab1 - Just a discussion question not a paper 100 words. - Mr tapp princess royal hospital - Discussion question, 350 words and 2 references. - Section properties of circle - Po box 960 archerfield qld 4108 - UNIT DISCUSSION 2: Chapters 3 and 4 (week 3 and 4): Cognitions and Brain (development)... - Angry white man t shirt - Paper - Hershey's organizational chart and organizational structure - Boom and bitner 1981 - Foreshadowing in the cask of amontillado - Introduction to dc circuits lab - Molar heat of combustion formula - Assignment 05.03 analyzing an argument - Dinner at the homesick restaurant chapter 9 summary - Aanotated and research on cyber - Camero shots and angles - MNC Strategy Paper - Mary maxfield they say i say - Benefits of a computerised accounting system - NURS561PROMPT2REPLY - Country of origin codes - Science Technology Presentation - Week 3 Assignment: Case Study – Mobilizing the Masses - Information technology equipment safety general requirements - Psyc - I have a dream speech questions pdf - Percentage change represents the relative change between the - Module 02 Discussion - Congressional Contributions to Universal Healthcare - Best sentence starters for essays - Unsw future students ambassador - Scorecard Analysis: Individual Presentation - Wollongong council clean up - Diversity Issues in Criminal Justice _ Chapter 9. - Vendor management plan template - Barium nitrate and sodium sulfate balanced equation - American revolution - Healthy and unhealthy food speech - Global supply chain management simulation v2 - Three room dwelling nutshell solution - Nike information system case study - Countable and uncountable sets in discrete mathematics - 5/1 - Oi and oy spelling rule - Et enterprises ltd uxbridge - Tutor - Skeletal and muscular system worksheet - Cbrn powerpoint presentation - How is odysseus an epic hero essay - Essay english - Data dictionary in dbms ppt - Buehler aged care clarinda - Mountain dew harvard case study - The first step in the screening process for potential markets and sites is to ________. - Fin 534 homework set 3 - The effects of madd social policies on human services delivery - Virtual capacitor experiment answers - Adele esl corner grammar - Aesthetically pleasing in a sentence - Japanese decision making style - Dummit and foote chapter 10 solutions - Maxwell relations chemical potential - Evidence of seafloor spreading - Commonwealth bank mobile eftpos - Www yougetsignal com tools visual tracert - Vitamin a has a molar mass of 286.4 - Literature assignments - Bsbcmm401 make a presentation assessment answers - Mazoon college student login - Security Architecture and Design - Project - Newspaper seller problem simulation excel - Suitable sites for venipuncture - Bose einstein condensate nobel prize - What makes a human services worker a professional