Wednesday, March 23, 2011

Starting the Databases task - databases CSV imports

Open Access
Name Database - Click CREATE
Click External Data
Click Text File (a CSV is a text file where info is split with commas)
Find CSV file - Click OK
IMPORT 2 / 4 = NEXT-TICK-NEXT-TICK-NEXT-FINISH
Double Click the NEW TABLE (e.g. J8Prods)
Click HOME - Click VIEW - CLick Design View
Copy Data Types from Exam paper (e.g. Currency, Boolean = YES/NO)
PRINT SCREEN you Data Types for the examiner (Paste into WORD to Print)

No comments:

Post a Comment