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 15 lines
1. Select Blank Access Database:
[CREATE ACCESS DB.JPG]
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]
5. Change the Files of Type to ODBC Database, and leave the file name blank. As soon as
# 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
At line 19 changed one line
source created earlier and click OK.
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.
At line 21 removed 10 lines
[ACCESS DSN SOURCES.JPG]
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]
At line 33 changed 7 lines
7. Click OK.
[ACCESS UNIQUE RECORD IDENTIFIER.JPG]
# Click OK.
At line 41 removed 8 lines
[ACCESS VIEW TABLE.JPG]
----
![Notes|Edit:Internal.CREATE+AN+ACCESS+DATABASE]
[{InsertPage page='Internal.CREATE+AN+ACCESS+DATABASE' default='Click to create a new notes page'}]
This page (revision-4) was last changed on 26-Nov-2021 10:22 by RForbesTop