BIS 445 DeVry Week 1 I Lab

Downloading is very simple, you can download this Course here:

http://wiseamerican.us/product/bis-445-devry-week-1-ilab/

Or

Contact us at:

SUPPORT@WISEAMERICAN.US

BIS 445 DeVry Week 1 iLab

BIS445

BIS 445 DeVry Week 1 iLab

Part a: Using action queries in SQL

Note! Submit your assignment to the Dropbox located on the silver tab at the top of this page. (See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

Remember This! Connect to the iLab here.

iLAB OVERVIEW

Scenario and Summary

You have been requested to import a comma delimited text file into an existing SQL 2008 database. Using the SQL 2008 Import Utility, you will create field mappings for a new SQL 2008 table and then upload your text file into this new table. After you upload your text file, you will perform some action queries to add, delete, and modify data in your new table.

Upon completing this lab, you will be able to:

Import text file data into an existing SQL 2008 database and create a new SQL 2008 table.

Use action queries to add, delete, and modify data.

Deliverables

Submit the YourName_Lab1A_Questions.docx to the Week 1 iLab Dropbox.

Section Deliverable Points
Part A Import comma delimited text file. 6
Part B Review uploaded data. 6
Part C Add records into a table. 6
Part D Delete records in a table. 6
Part E Modify records in a table.