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:

CREATE ACCESS DB.JPG(info)

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.

LINK TABLES TO ACCESS.JPG(info)

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.

ACCESS DSN SOURCES.JPG(info)

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.

ACCESS LINK TABLES.JPG(info)

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.

ACCESS UNIQUE RECORD IDENTIFIER.JPG(info)

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

ACCESS VIEW TABLE.JPG(info)


Notes #

Click to create a new notes page