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.
- 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.
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.
ACCESS UNIQUE RECORD IDENTIFIER.JPG
When you next reopen the database, you will view the table you have created:
Notes #
Click to create a new notes pageScreen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation