!!!CREATE AN ACCESS DATABASE
Under the Start/Programs/Microsoft Access menu choice, select Access. You will be prompted to Create A New Database.

1. Select Blank Access Database:
[{Image src='CREATE ACCESS DB.JPG' width='350'}]

2. You will then be prompted to Create AND Save The Database.
*For clarity, a folder has been created at the root of C: called DSN (Data Source) that would hold all MS Access databases and Mail Merge documents. The file extension will be *.mdb (Microsoft Database).

3. You will be prompted to Create Table Design View, which creates tables in the Access database.

4. Under File select Get External Data/Link Tables, select Link Tables and you will be prompted to choose a table source.
[{Image src='LINK TABLES TO ACCESS.JPG' width='400'}]

5. Change the Files of Type to ODBC Database, and leave the file name blank. As soon as
you select ODBC Database you will be taken to a list of DSN sources; select the data
source created earlier and click OK. 

[{Image src='ACCESS DSN SOURCES.JPG' width='400'}]

You will next be prompted to select the tables you wish to link with in the database. We will select P2K.P2K_HR_VEODBC, which is a view of P2K HR functions.



6.  Click on OK.
[{Image src='ACCESS LINK TABLES.JPG' width='400'}]

You will next be prompted to Select A Unique Record Identifier. This is a database field
that specifically identifies the record as unique. The only choice is ID, the row_id.


7. Click OK.
[{Image src='ACCESS UNIQUE RECORD IDENTIFIER.JPG' width='400'}]


When you next reopen the database, you will view the table you have created:
[{Image src='ACCESS VIEW TABLE.JPG' width='400'}]


[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.CREATE+AN+ACCESS+DATABASE] 	
[{InsertPage page='Internal.CREATE+AN+ACCESS+DATABASE' default='Click to create a new discussion page'}] 	

}]