What email address or phone number would you like to use to sign in to Docs.com?
If you already have an account that you use with Office or other Microsoft services, enter it here.
Or sign in with:
Signing in allows you to download and like content, and it provides the authors analytical data about your interactions with their content.
Embed code for: BIS 445 DeVry Week 1 I Lab
Select a size
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/
Contact us at: SUPPORT@WISEAMERICAN.US
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 iLa
Downloading is very simple, you can download this Course here:
Contact us at:
Remember This! Connect to the iLab here.
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.
Submit the YourName_Lab1A_Questions.docx to the Week 1 iLab Dropbox.
Import comma delimited text file.
Review uploaded data.
Add records into a table.
Delete records in a table.
Modify records in a table.