CREATE AN ACCESS DATABASE#
Under the Start/Programs/Microsoft Access menu choice, select Access. You will be prompted to Create A New Database.- Select Blank Access Database:
- 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) and the file type should be as shown below:
- You will be prompted to Create Table Design View, which creates tables in the Access database.
- Under File select Get External Data/Link Tables, select Link Tables and you will be prompted to choose a table source.
- Change the Files of Type to ODBC Database, and leave the file name blank. As soon as
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.
- 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.
- Click OK.