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

We shall fight on the beaches techniques - Kill kapture - Tenchijin episodes - An frg provides activities and support that encourages - Wilson wonder's bonds have 12 years remaining - Oh my darling clementine history - Looking at movies an introduction to film fifth edition - Change management principles and methodologies - First vacuum tube computer - Which financial statement presents the results of operations - Qc makeup academy locations - 5014_ASS 2 # DRAFT 1 # Evaluation of Capital Projects # MBA # FLEXPAH CAPELLA - How to make npv profile in excel - Does the red cross sell blood overseas - Best practice aged care program active service model - Intel in costa rica case study - Should everyone go to college rhetorical analysis - Assetto corsa disable damage indicator - SWOT ANALYSIS - Canon lv wx320 review - Http www fbi gov wanted wanted_terrorists - The capability to inherit from more than one class is called ____ inheritance. - William shakespeare father occupation - Write system recommedation - The edelweiss hotel in vail colorado - 605 45 principal agent considerations - Unit 6 - How to grow avocado from cuttings - Next generation planning handbook - Toggle mechanism mechanical advantage - Grundfos sololift installation instructions - Condensed income statement wileyplus - Fujitsu fi 6140z driver - Jon stewart burn notice - Sconces two flambeaux definition - Where do squids live in the ocean - 1998 roman missal text - Technical English 7 - Disadvantages of two way anova - Http www teachingamericanhistory org neh interactives sectionalism lesson1 - Discussion Question - Managerial Accounting_Problem3 - Mode of delivery example - Home economics practical food studies assignment - Victim facilitation - Elevation of privilege eop card game - Imperial college london fees - Se habla espanol tanya barrientos essay - Ghtf sg3 n18 2010 - Sections 55 of the estate agents act 1980 - Apple's winning marketing strategy case study - The fur coat full short story - Japan - Command cruise control ap60b - What happens when two fruit companies merged riddle answer - Sap erp 6.08 global bike - Isilon nfs mount options - Current trip error fujitsu - William glasser theory of classroom management - 4.55 km in miles - Present condition of the australian rainforest - Mod 12 synchronous counter using d flip flop - Physical planning regulations uganda - Conductometric titration pre lab answers - Stem Cell. - Bren 626 stencil cutting machine - Essay - Advertising copywriting and layout - Dna replication worksheet true or false answers - Finances - Elearning course review checklist - Elon musk tesla patents pdf - Fanatec csr elite manual - Appearance and reality in merchant of venice - Breaking a social norm assignment - Analyzing asthma a statistics project - Deliverable 7 - Healthcare Intake Packet - British turkish lawyers association - Piper super cub drawings - E force bedlam lite 170 stringing instructions - Review academically reviewed articles - Wheel and axle simple machine diagram - Accounting for governmental & nonprofit entities edition - Importance of protozoa in agriculture - Sim not provisioned for voice optus - Communication skills workshop outline - Hierarchy chart programming - Change Theory - Discussion - 0.0104166667 - Chapter 6 summary of the giver - Confidence - Mayeroff caring ingredients - Extravagant hypothesis fallacy definition - The terms letter and memo are interchangeable. - Can eating insects save the world - Why is phenol red used in this experiment - Quadrennial homeland security review 2018 pdf - Decision making under certainty uncertainty and risk - The zoom slider is located on the ____