subject

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 below. Set the LocationID field as the Primary Key, then save and close 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:
LocationName
4. Sandra exported her existing location data to a text file, and she asks you to 10. add this data to the tbilLocation table. Import the data as instructed below:
a. Specify the file Support NP_AC16_CS1-4a Locations. txt, available
b. Select the option to append a copy of the records to the tbilocation
c. In the Import Text Wizard dialog boxes, choose the options to import for download from the SAM website, as the source of the data. table. delimited data, to use a comma delimiter, and to import the data into the tbLocation table. Do not save the import steps.
d. Open the tbiLocation table in Datasheet View, and then resize the columns to best fit the data they contain.
e. Save and close the tbiLocation table.
5. Create a new table in Design View, and then set the field properties shown in Table 4 on the following page. The LevelID field should be the primary key for 11. the table. Save the table with the name tblLevel, and then close the table.

ansver
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 21.06.2019 22:30, ayoismeisjuam
What are compression artifacts? 1) visible defects in the picture caused by the nature of the compression algorithm. 2) numbers that tell a web server how much to compress a picture for faster transmission. 3) invisible defects in the picture preserved by lossless compression. 4) numbers that tell a photo editing program how much to compress a picture for faster transmission.
Answers: 3
image
Computers and Technology, 22.06.2019 02:00, alexabessin
Aisha has finished working on a word processing document that contains 15 pages. she has added some special elements in the first three pages, page 9 and 10, and page 15 from the document. she wants to print only these pages to see how they look. which option is the correct way to represent (in the print dialog box) the pages that aisha wants to print?
Answers: 3
image
Computers and Technology, 23.06.2019 11:00, jolleyrancher78
What are the possible consequences of computer hacking? what is computer piracy? describe some examples. what are the effects of computer piracy? what are the possible consequences of computer piracy? what is intentional virus setting? describe some examples. what are the effects of intentional virus setting? what are the possible consequences of intentional virus setting? what is invasion of privacy? describe some examples. what are the effects of invasion of privacy? what are the possible consequences of invasion of privacy? what is an acceptable use policy and what is the purpose of the acceptable use policy what is intellectual property and how can you use it?
Answers: 1
image
Computers and Technology, 23.06.2019 15:20, headshotplayzcod
In a game with three frames, where will the objects on layer 1 appear? a. next to the play area b. in the middle of the game c. behind everything else d. in front of everything else
Answers: 1
You know the right answer?
1. Much of the data that Sandra needs in the database is currently stored in other formats and locat...

Questions in other subjects:

Konu
Mathematics, 12.01.2021 20:10
Konu
Mathematics, 12.01.2021 20:10