CREATE AN ACCESS DATABASE
Back to current versionRestore this version

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:

2. You will then be prompted to Create AND Save The 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.

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.

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.

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.

When you next reopen the database, you will view the table you have created: