Create a new blank Access Database (using any version from Access 2007 to current) and name it [lastname] [initial] _ [student number] _ [course code] _ assign1.accdb (eg....

Create a new blank Access Database (using any version from Access 2007 to current) and name it [lastname] [initial] _ [student number] _ [course code] _ assign1.accdb (eg. genrichr_0050051005_cis1000_assign1.accdb).

Import the four sets of data from your firm’s Intranet (CIS1000 Study Desk).


The easiest and quickest way to import data into Access is by using the Import Text Wizard.  The following steps must be followed carefully to ensure the data is imported correctly:
Importing Tab Delimited Text files into Access (any version from Access 2007 to current) using the Wizard
1)    On the External Data tab, in the Import & Link group, click the Text File data source icon.
2)    In the Get External Data - Text File wizard popup, browse to find the ‘Assignment01 Text File Customers.txt’ text file and select the Import the source data into a new table in the current database option – then click OK.
3)    Select the Delimited – Characters such as commas or tab separate each field option on the first page of the wizard - then click Next.