Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

HI there, im working on a project and am stuck on question 7. Can someone please help? 1.Much of the data that Sandra needs in

HI there, im working on a project and am stuck on question 7. Can someone please help?

1.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.

2.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.

3.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.

Table 3: Field Properties for the tblLocation Table

Field Name

Data Type

Description

Field Size

Other

LocationID

Short Text

Primary key

4

Caption: Location ID

LocationName

Short Text

50

Caption: Location Name

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Accounting For Governmental And Not-for-Profit Organizations

Authors: Paul Copley

14th Edition

1260570177, 978-1260570175

More Books

Students also viewed these Accounting questions