You would have to spend time and money to gather information about database design, schema, connections, validations - UI side and Server side. Heard of software consultants getting $ 100 /hr jobs in USA?
You can even enforce data integrity using the Unique Constraint and Foreign Key Constraint objects. Many have mastered Cloud Programming and are enjoying the benefits. A foundation book to Master Accounting Software Development, VB. Detailed explanation of the Accounting domain for programmers is included. A thorough understanding of the contents will enable you to grasp the topics covered in the accompanying books quite easily. Net, C# and SQL Server as the tools, you will learn to build a Multi Tier Web Application as recommended by Microsoft. Master Application Development and your Career is secure.This is because, the accounting domain is dealt with great detail in this book. You will learn implementing inline Grid View control, Transaction Management for a layered Web Application, build Data Access component and a Business Layer component. You will be able to develop a Web ERP application including all the five modules and learn how to use the Tree View control and Grid View control to implement transactions such as Purchase Invoice, Sales Order and Sales Invoice. Net programming and is the data access technology for Microsoft OS based hand held devices and web applications. This is simply because, Application Development is needed by every organization and developers with domain expertise and technical knowledge are in short supply.Thank you Rob Dog888 and gigemboy, According to your post, I got to know that if I want to change the linked table's path at run time, I have to use VBA. " Chr(13) "Curr.: [" Cur Dir() "]" Chr(13) "Starting dir: [" Fullpath(path_or_pfile) "]" End Function Public Function Fullpath(strb As String) As String On Error Go To Oops Err Dim k As Long k = Len(strb) While (Mid$(strb, k, 1) 1) k = k - 1 Wend Fullpath = Left$(strb, k) Exit Function Oops Err: Msg Box Err. Description & vbcrlf & "Fullpath()" End Function And then you have to make queries with constant database names WITHOUT PATH, for example: SELECT * FROM Table1 IN 'DATASRC. MDB].[Table1] Later, you can set current directory to anywhere but DATASRC. Microsoft has an elegant technique using a module within dbase that is called upon AUTOEXEC.OKEY But If I want to change the path for the linked table to relative path in MS Access database with MS Access. https://support.microsoft.com/en-us/...crosoft-access I haven't tried it yet, but it seems like the "cleanest" solution (this is only the 3rd thread I've read on the subject, so this is most likely already posted "somewhere" on the web).Concepts and development steps are logicaly laid out, eliminating the need for a trainer.