A Table is normally created with a Primary Key or Index to arrange the records into certain order to view or process. Primary Key or Index can have one or more fields, in order to make the Key Values Unique, if this is not possible with a single field.
Indexing and Sorting with VBA
Posted On 28 Jan 2010 By a.p.r.pillai. Under Process Controls.
No Comments
MS-Access And Data Processing-2
Posted On 22 Nov 2009 By a.p.r.pillai. Under Process Controls.
This is the continuation of earlier Article published on this subject last week. Click here to visit that Page.
Last week we have explored the sample data processing methods and tried to approach the same problem in different ways to arrive at the same result. Reports are the main output component that goes to the User with critical information for analysis of business activities and for making serious business decisions. Transforming raw data into meaningful form and providing them on Reports is a real challenge of any Project.
4 Comments
MS-Access and Data Processing
Posted On 15 Nov 2009 By a.p.r.pillai. Under Process Controls.
Designing Forms or Reports can be learned quickly by mastering the usage of Design Tools available in MS-Access, keeping aside the programming aspects. But, data processing is something that demands diversity in each Project and cannot be standardized. The data Table design is very important and these must be carefully planned and created for easier retrieval of information as well as to avoid duplication. Proper relationships must be established between Tables to join related information together.
7 Comments
Seriality Control Finding Missing Numbers
Posted On 10 Oct 2008 By a.p.r.pillai. Under Process Controls.
It is part of the Accounting/Auditing activity to maintain control over usage of important Documents like Cheque Books, Receipt Vouchers, Cheque Payment Vouchers, Local Purchase Orders and so on. Usage ... Continue Reading
No Comments
