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

Save sam lab answer key

25/03/2021 Client: saad24vbs Deadline: 3 days

New Perspectives Access 2016 | Modules 1–4: SAM Capstone Project 1a

New Perspectives Access 2016 | Modules 1–4: SAM Capstone Project 1a

Sandra Coates Skating Club

Creating Tables, Queries, Forms, and Reports in a Database

GETTING STARTED
· Open the file NP_AC16_CS1-4a_FirstLastName_1.accdb, available for download from the SAM website.

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

· Support_NP_AC16_CS1-4a_Athletes.xlsx

· Support_NP_AC16_CS1-4a_SCSC.accdb

· Support_NP_AC16_CS1-4a_Locations.txt

· Support_NP_AC16_CS1-4a_Levels.txt

· 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
Sandra Coates Skating Club (SCSC) is committed to the development of skaters of all ages. It manages athlete and coach data for skating athletes located at various skating clubs throughout Pennsylvania. Sandra Coates is the founder and general chairperson of SCSC, and she has just received approval from the board of directors to replace SCSC’s manual system of managing data about athletes, coaches, and locations with a database. She has asked you to help her create objects in the database that she and other staff members can use to manage data about athletes, coaches, and their locations. Open the tblCoach table in Design View, and then make the following changes:

a. Move the LevelID field immediately after the CoachID field.

b. Delete the CertificationLevel field from the table. (Hint: If a warning message appears asking if you want to permanently delete the field and all the data it contains, click Yes.)

c. Save the table.

Switch to Datasheet View, enter the records shown in Table 1 below into the tblCoach table, and then close the table.

Table 1: New Records for the tblCoach Table

Coach ID

Level ID

Coach First Name

Coach Last Name

BGC Expiration

Certification Expiration

901900

BEG2

Angela

Pearson

12/31/2020

12/31/2020

901901

BEG1

Nora

Keller

12/31/2020

12/31/2020

Create a new table in Datasheet View. Save the table as tblAthlete, and then make the following changes in Datasheet View:

a. Change the data type of the ID field to Short Text, and then change the field name to AthleteID.

b. Add the following fields to the table in the order listed, and choose the Short Text data type for each field: LocationID, FirstName, LastName, Address, City, State, Zip, LevelID, and Gender.

c. Save the table.

Switch to Design View for the tblAthlete table, and then set the field properties shown in Table 2 below.

Table 2: Field Properties for the tblAthlete Table

Field Name

Data Type

Description

Field Size

Other

AthleteID

Short Text

Primary key

5

Caption: Athlete ID

LocationID

Short Text

Foreign key

4

Caption: Location ID

FirstName

Short Text

20

Caption: First Name

LastName

Short Text

30

Caption: Last Name

Address

Short Text

35

City

Short Text

35

State

Short Text

2

Default Value: PA

Zip

Short Text

10

LevelID

Short Text

Foreign key

4

Caption: Level ID

Gender

Short Text

M, F

1

Add a new field to the tblAthlete table, immediately after the Zip field. Use the field name BirthDate, the Date/Time data type, the Short Date format, and the caption Birth Date.

Move the LevelID field so that it is located immediately after the AthleteID field. Save and close the table.

Much of the data that Sandra needs in the database is currently stored in other formats and locations, so you need to import it into the database. Use the Import Spreadsheet Wizard to add data to the tblAthlete table from an Excel spreadsheet as follows:

a. Specify the file Support_NP_AC16_CS1-4a_Athletes.xlsx, available for download from the SAM website, as the source of the data.

b. Select the option to append a copy of the records to the tblAthlete table.

c. In the Import Spreadsheet Wizard dialog boxes, choose the Athlete worksheet, and then import to the tblAthlete table. Do not save the import steps.

Import the structure of the tblLocation table in the database Support_NP_AC16_CS1-4a_SCSC.accdb, available for download from the SAM website, into the current database. Do not save the import steps.

Open the tblLocation table in Design View, and then update the field properties shown in Table 3 below. Set the LocationID field as the Primary Key, then save and close the tblLocation table.

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:

Smart Accountants
Financial Analyst
Finance Professor
Top Essay Tutor
Isabella K.
Coursework Assignment Help
Writer Writer Name Offer Chat
Smart Accountants

ONLINE

Smart Accountants

I have read your project details. I can do this within your deadline.

$31 Chat With Writer
Financial Analyst

ONLINE

Financial Analyst

I have read your project details. I can do this within your deadline.

$146 Chat With Writer
Finance Professor

ONLINE

Finance Professor

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$62 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have read your project details. I can do this within your deadline.

$166 Chat With Writer
Isabella K.

ONLINE

Isabella K.

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$119 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

I will cover all the points which you have mentioned in your project details.

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

A doll's house macaroons quotes - Identity authority and learning to write in new workplaces - Financial accounting comprehensive problem 2 - Employee management system python code - Tijuana bronze machining case - Tweenies karaoke boom boogie - Tonga toys manufactures and distributes a number - BUS 633 WEEK 1 ASSIGMENT - The assembly consists of two red brass c83400 copper rods - CLA 1 Paper - Data Analysis & Business Intelligence - CT2 Essay - Learn labview in 6 hours - Junit Test Cases - HA570 Unit 9 Assignment - Separation of photosynthetic pigments by paper chromatography lab report - Jouranl Assingment - Fire alarm acceptance test checklist - 10 pages of write up on a given topic - Value of levered firm calculator - Qsps dh 1 60 - Nasm 75 day study planner pdf - Please respond if you can complete it in 7 hours, Please see the doc attached and respond - Apple ethics and social responsibility - Why is tennis scored 15 30 40 - Intimate frontiers sparknotes - Cheadle mosque ramadan timetable - Sexual encounters of the floral kind worksheet - Assignment-1 - (Rok) week 10 discussion eco100 - If 1200 cm2 of material is available - 1876 glenelg highway wannon - The strange thing about the johnsons budget - Disney information systems - RACIAL JUSTICE REFORM AND PRO SPORTS. - Religion Analysis - John cheston net worth - Tblt on bank statement - Art HUM 2200 - Wave interference phet lab answer key - Bread dough rising experiment - Mcdonald's monopoly case study - How to wrap text in lucidchart - Developing a biblical worldview means that we must remain faithful - Specific heat capacity of polystyrene - Computer network lab manual using packet tracer - Singles table tennis rules - Strategic profile and case analysis purpose - Analysis of lou gehrig's farewell speech - British council food lesson - Elevation of privilege eop threat modeling card game - Roman underground heating system - Critical thinking 12th edition moore pdf free - Ncopds army - 2014 in roman numerals - Wbs for a coffee shop - Discovery Report - Dawn lingua bought three yards - K2 training ctg login - Firestone ride rite air bags warranty - Ppt on mcdonalds marketing strategies - Which of the following statement is true about variable expenses - Discussion Board - Harlem night song analysis - Blanchard zigarmi & zigarmi 1985 - Financial Accounting Data - Jesus hopped the a train sparknotes - Write a prescription - The first law of thermodynamics states that you cannot obtain - Religion- Reflection Paper 2 - Introducing new coke case study - English - Recommended +27835179056 unquestionable ABORTION clinic & pills durban NAMIBIA Ladysmith Winterton Dundee Greytown Muden Wasbank - Brown girl brownstones summary sparknotes - Keynows - Creditors claims on assets - What is an ethnic enclave answers - D7 - Gantt chart for coffee shop - Police organization and management issues for the next decade - What is gunning fog index - Colleges prepare for life freeman hrabowski - Epidemiology Discussion 3 - Www lafarge co ke - Threat Modeling - Laws of indices calculator - What is a fuselage - Bmaa sigma - Icd 10 code for finger laceration with tendon involvement - Blood brothers analysis gcse - +91-8890675453 love marriage problem solution IN Kakada - Danny carey isolated drums - Webstore - Extraction of caffeine from tea lab report discussion - Computer science homework help - Tawuniya visit visa health insurance - Discussion question - Work - Mid semester break latrobe - Week three project ADHD - Hard bop characteristics