Hello ppl, i am designing a system in access but need help please can you help me.
The main purpose of this system is to enter customer details such as their base number, account details and KIBS date, expiry date, etc. Upon entering this information in the Access form, Citibank would like to transfer this information in Excel spreadsheet. Furthermore, they would like to mail merge with Word where they can create a template for customers. The dates and the account in the template would be obtained from the Access Forms.
The following input, process and output is required from the system:
INPUT and PROCESS
· Base number (unique for each customer and can have more than one account number, but there can be more than one base for certain customers)
· Customer name
· Account no
(What the user wants is to have a drop down menu next to account number, whereby the user can select one of the three options, No account, Single account, or multiple account. On clicking the option, say No account it should be displayed next to the account number. This information should be reflected in the spreadsheet. This is the same with single account, where an account number is displayed. With multiple accounts, more than one account should be displayed next to account number.)
· Same data for all accounts? (tickbox) (After entering the multiple account numbers, the user can tick on “same data for all accounts box”. This means that multiple accounts have the same customer, say Abdullah and instead of them typing each account number individually with same details, they can simply click on this box)
Auhtorisation details
· Name of authoriser
· Power
· Engagement authorised - preferably a drop down menu with listed docs, such as guarantee, letter of credit, Credit Agricole so user simply selects the one they require;
· Source document (authorising the power)
OUTPUT
The output required from the system:
· A spreadsheet in Excel
· Letter template in Word (linked)
Spreadsheet
The following fields need to be included in the spreadsheet:
Customer name—Base no.—Acc. No. KBIS Date—Authoriser*-- Power—STATUT Date—process verbal date*-- other docs—Comments
--Authoriser * (there is more than authorised signatory for one deal and can be 10 or more, so I would like to create rows or something that can store this info in excel. As making columns for each signatory will be long and use up space within spreadsheet; but this information needs to be displayed)
--Process verbal date * (This is a date which can be more than one, so would like this to be displayed without taking too much space.)
Microsoft Word
The following fields need to be included in Microsoft letter template:
Customer name – Base no. – A/c no—Authorised signatories
OVERALL PROCESS
A customer sends details to the bank, such as base number, account no. and name of authorised signatories (people who are authorise to sign the documents on behalf of the company) to Citibank. Citibank then stores this information manually in files. However, if for any reason, the bank wants to request some documents from them, they have to search manually which is time consuming. This is where this system is helpful. So they can enter all the information details and update their records.
I hope I have explained the procedure for the system and the requirements. Please I need help in relationships and the methods. I will very very grateful and will not forget this favour.
The main purpose of this system is to enter customer details such as their base number, account details and KIBS date, expiry date, etc. Upon entering this information in the Access form, Citibank would like to transfer this information in Excel spreadsheet. Furthermore, they would like to mail merge with Word where they can create a template for customers. The dates and the account in the template would be obtained from the Access Forms.
The following input, process and output is required from the system:
INPUT and PROCESS
· Base number (unique for each customer and can have more than one account number, but there can be more than one base for certain customers)
· Customer name
· Account no
(What the user wants is to have a drop down menu next to account number, whereby the user can select one of the three options, No account, Single account, or multiple account. On clicking the option, say No account it should be displayed next to the account number. This information should be reflected in the spreadsheet. This is the same with single account, where an account number is displayed. With multiple accounts, more than one account should be displayed next to account number.)
· Same data for all accounts? (tickbox) (After entering the multiple account numbers, the user can tick on “same data for all accounts box”. This means that multiple accounts have the same customer, say Abdullah and instead of them typing each account number individually with same details, they can simply click on this box)
Auhtorisation details
· Name of authoriser
· Power
· Engagement authorised - preferably a drop down menu with listed docs, such as guarantee, letter of credit, Credit Agricole so user simply selects the one they require;
· Source document (authorising the power)
OUTPUT
The output required from the system:
· A spreadsheet in Excel
· Letter template in Word (linked)
Spreadsheet
The following fields need to be included in the spreadsheet:
Customer name—Base no.—Acc. No. KBIS Date—Authoriser*-- Power—STATUT Date—process verbal date*-- other docs—Comments
--Authoriser * (there is more than authorised signatory for one deal and can be 10 or more, so I would like to create rows or something that can store this info in excel. As making columns for each signatory will be long and use up space within spreadsheet; but this information needs to be displayed)
--Process verbal date * (This is a date which can be more than one, so would like this to be displayed without taking too much space.)
Microsoft Word
The following fields need to be included in Microsoft letter template:
Customer name – Base no. – A/c no—Authorised signatories
OVERALL PROCESS
A customer sends details to the bank, such as base number, account no. and name of authorised signatories (people who are authorise to sign the documents on behalf of the company) to Citibank. Citibank then stores this information manually in files. However, if for any reason, the bank wants to request some documents from them, they have to search manually which is time consuming. This is where this system is helpful. So they can enter all the information details and update their records.
I hope I have explained the procedure for the system and the requirements. Please I need help in relationships and the methods. I will very very grateful and will not forget this favour.
