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 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.
- 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.
When you next reopen the database, you will view the table you have created:
Screen 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