This page (revision-4) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 1 KB RForbes to previous
3 26-Nov-2021 10:22 1 KB JEscott to previous | to last
2 26-Nov-2021 10:22 1 KB JEscott to previous | to last
1 26-Nov-2021 10:22 1 KB JEscott to last

Page References

Incoming links Outgoing links
CREATE AN ACCESS DATABASE
CREATE AN ACCESS DATABASE

Version management

Difference between version and

At line 3 changed 6 lines
# 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).
#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
1. Select Blank Access Database:
[{Image src='CREATE ACCESS DB.JPG' width='350'}]
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.
[{Image src='LINK TABLES TO ACCESS.JPG' width='400'}]
5. Change the Files of Type to ODBC Database, and leave the file name blank. As soon as
At line 10 changed 2 lines
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.
source created earlier and click OK.
At line 19 added 9 lines
[{Image src='ACCESS DSN SOURCES.JPG' width='400'}]
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.
[{Image src='ACCESS LINK TABLES.JPG' width='400'}]
At line 15 changed one line
# Click OK.
7. Click OK.
[{Image src='ACCESS UNIQUE RECORD IDENTIFIER.JPG' width='400'}]
At line 37 added 10 lines
[{Image src='ACCESS VIEW TABLE.JPG' width='400'}]
[{If var='loginstatus' contains 'authenticated'
----
![Discussion|Edit:Internal.CREATE+AN+ACCESS+DATABASE]
[{InsertPage page='Internal.CREATE+AN+ACCESS+DATABASE' default='Click to create a new discussion page'}]
}]
This page (revision-4) was last changed on 26-Nov-2021 10:22 by RForbesTop