GCE Edexcel Applied ICT Unit 7 Using Database Software January 2010
Scroll to see replies
diggingupworms
put a present check on the contract date
a format check on the phone model 3 letters followed by 2 numbers
combo box and the package type
imput mask on the phone number
thats what i did anyway
a format check on the phone model 3 letters followed by 2 numbers
combo box and the package type
imput mask on the phone number
thats what i did anyway
Could you please explain this further. I don't understand the present check, format check, combo box and imput mask.
arbie
Could you please explain this further. I don't understand the present check, format check, combo box and imput mask.
so you dont understand validation?
present check: Is Not Null in the validation area
format check: is like [a-z] meaning letter and # meaning number
combo box-go into lookup click combo box, then value list, and then list all the things eg if its salutation then miss;mr;mrs separating everything with a semi colon
imput mask-you click the [...]button in the imput mask feild and go through the steps
diggingupworms
so you dont understand validation?
present check: Is Not Null in the validation area
format check: is like [a-z] meaning letter and # meaning number
combo box-go into lookup click combo box, then value list, and then list all the things eg if its salutation then miss;mr;mrs separating everything with a semi colon
imput mask-you click the [...]button in the imput mask feild and go through the steps
present check: Is Not Null in the validation area
format check: is like [a-z] meaning letter and # meaning number
combo box-go into lookup click combo box, then value list, and then list all the things eg if its salutation then miss;mr;mrs separating everything with a semi colon
imput mask-you click the [...]button in the imput mask feild and go through the steps
I would just like to thank you for explaining it in greater detail. I appreciate it.
Guini
Anyone explain activity 3 who's already doing it/completed it, please? would be greatly appreciated by all of my class!
You have to create a form or forms so you can set up a contract for a new or exsisiting customer. What ive done is do two forms one for the customer details- name, address etc and the other form for the contract details. Then im gonna link the 2 with a macro which will close the customer form and then open the contract form.
Thisisafakeaccount
Hey RNS 
To calculate this, you have to understand various date functions.
One of these is DateDiff. - Press F1 in access to bring up Access help if you are stuck, make sure u only set it to Offline mode, because anything you find on the net will not be available in the exam.
The formula to calculate how many months have passed is;
DateDiff("m"[ContractDate],Date())
I had problems putting this in, it is correct, just sometimes you have to do DateDiff( then click ContractDate from ur tables, then enter "m" where it says expression.
This formula is only part of it however, there are two other parts.
The second is Months Left.
This one is simple: 12-[MonthsGone]
In order to do this, you must of calcualated the first one and got it working correctly.
The third is the hardest.
Iif([MonthsLeft]="1","Contract Expires in one month")
That means, If months left equals one, then the contract expires in one month.
These are used in your forms to show contracts near expiry. Use them however you wish, but I suggest to set up Conditional Formatting on the last formula to say "If Field Value is Equal To "Contract Expires in one month" then set the bacground colour to red.
Hope this helps
To calculate this, you have to understand various date functions.
One of these is DateDiff. - Press F1 in access to bring up Access help if you are stuck, make sure u only set it to Offline mode, because anything you find on the net will not be available in the exam.
The formula to calculate how many months have passed is;
DateDiff("m"[ContractDate],Date())
I had problems putting this in, it is correct, just sometimes you have to do DateDiff( then click ContractDate from ur tables, then enter "m" where it says expression.
This formula is only part of it however, there are two other parts.
The second is Months Left.
This one is simple: 12-[MonthsGone]
In order to do this, you must of calcualated the first one and got it working correctly.
The third is the hardest.
Iif([MonthsLeft]="1","Contract Expires in one month")
That means, If months left equals one, then the contract expires in one month.
These are used in your forms to show contracts near expiry. Use them however you wish, but I suggest to set up Conditional Formatting on the last formula to say "If Field Value is Equal To "Contract Expires in one month" then set the bacground colour to red.
Hope this helps
hi,
So does this formula join up together? and where abouts do you enter this formula?
Thanks
this is just an help for activity 3
Before creating the the form you have to make the expiry date for each contract date. I have explained a-z above pls pass it to the ppl who may concern
1. add a field in contract table called Expiry date Then put the validations as contract date.
2. Then create an update query Select the contract table and package table
3. select the expiry field and in the row "updateto" type "DateAdd("m",[Duration],[ContractDate])" as mentioned on the Update.jpg in the attached file, save it then run it will update the expiry date
4. Now create the the form in wizard
5. Put all the fields in the customer table and all the fied in the contract table except the customerID and PhoneID and select the Phone table and input the PhoneID and Name And Click next and Finish the wizard
6. You will have A form with Subform adjust the field size and make a nice interface
7. Then create a new macro On the first action select "openform" Select the form name as the form that u made nw and in data mode to "add"
8. Then create another form in design view name it as "frmMain"and create a command button and select the macro that u have created and Name it as "New Customer"(i assume that u knw that)
9. Nw you compled the 1st process Add a contract using new customer
10. the a bit hard one creating the contract frm an existing customer
11. I have shown the steps in the screen shots a which I have attached, try to undestand
12. After the 4th Step just close the querry and say "yes"
13. Finally create the button on the frmMain and link to the that macro
Task completed
If you want more about contact me
Images are uploaded below *mark that final link is to 1st image*
http://img682.imageshack.us/img682/6475/updatej.jpg
http://img163.imageshack.us/img163/5282/mcrnewcustomer.jpg
http://img707.imageshack.us/img707/8763/5ststep.jpg
http://img85.imageshack.us/img85/1883/4ststep.jpg
http://img689.imageshack.us/img689/417/3ststep.jpg
http://img686.imageshack.us/img686/1152/2ststep.jpg
http://img686.imageshack.us/img686/6333/ststep.jpg
Before creating the the form you have to make the expiry date for each contract date. I have explained a-z above pls pass it to the ppl who may concern
1. add a field in contract table called Expiry date Then put the validations as contract date.
2. Then create an update query Select the contract table and package table
3. select the expiry field and in the row "updateto" type "DateAdd("m",[Duration],[ContractDate])" as mentioned on the Update.jpg in the attached file, save it then run it will update the expiry date
4. Now create the the form in wizard
5. Put all the fields in the customer table and all the fied in the contract table except the customerID and PhoneID and select the Phone table and input the PhoneID and Name And Click next and Finish the wizard
6. You will have A form with Subform adjust the field size and make a nice interface
7. Then create a new macro On the first action select "openform" Select the form name as the form that u made nw and in data mode to "add"
8. Then create another form in design view name it as "frmMain"and create a command button and select the macro that u have created and Name it as "New Customer"(i assume that u knw that)
9. Nw you compled the 1st process Add a contract using new customer
10. the a bit hard one creating the contract frm an existing customer
11. I have shown the steps in the screen shots a which I have attached, try to undestand
12. After the 4th Step just close the querry and say "yes"
13. Finally create the button on the frmMain and link to the that macro
Task completed
If you want more about contact me
Images are uploaded below *mark that final link is to 1st image*
http://img682.imageshack.us/img682/6475/updatej.jpg
http://img163.imageshack.us/img163/5282/mcrnewcustomer.jpg
http://img707.imageshack.us/img707/8763/5ststep.jpg
http://img85.imageshack.us/img85/1883/4ststep.jpg
http://img689.imageshack.us/img689/417/3ststep.jpg
http://img686.imageshack.us/img686/1152/2ststep.jpg
http://img686.imageshack.us/img686/6333/ststep.jpg
this is just an help for activity 3
Before creating the the form you have to make the expiry date for each contract date. I have explained a-z above pls pass it to the ppl who may concern
1. add a field in contract table called Expiry date Then put the validations as contract date.(i mean the validations same as contract date
that is select the data type as date/time and select the format as short date)
2. Then create an update query Select the contract table and package table
3. select the expiry field and in the row "updateto" type "DateAdd("m",[Duration],[ContractDate])" as mentioned on the Update.jpg in the attached file, save it then run it will update the expiry date
4. Now create the the form in wizard
5. Put all the fields in the customer table and all the fied in the contract table except the customerID and PhoneID and select the Phone table and input the PhoneID and Name And Click next and Finish the wizard
6. You will have A form with Subform adjust the field size and make a nice interface
7. Then create a new macro On the first action select "openform" Select the form name as the form that u made nw and in data mode to "add"
8. Then create another form in design view name it as "frmMain"and create a command button and select the macro that u have created and Name it as "New Customer"(i assume that u knw that)
9. Nw you compled the 1st process Add a contract using new customer
10. the a bit hard one creating the contract frm an existing customer
11. I have shown the steps in the screen shots a which I have attached, try to undestand
12. After the 4th Step just close the querry and say "yes"
13. Finally create the button on the frmMain and link to the that macro
Task completed
If you want more about contact me
Images are uploaded below *mark that final link is to 1st image*
http://img682.imageshack.us/img682/6475/updatej.jpg
http://img163.imageshack.us/img163/5...ewcustomer.jpg
http://img707.imageshack.us/img707/8763/5ststep.jpg
http://img85.imageshack.us/img85/1883/4ststep.jpg
http://img689.imageshack.us/img689/417/3ststep.jpg
http://img686.imageshack.us/img686/1152/2ststep.jpg
http://img686.imageshack.us/img686/6333/ststep.jpg
Before creating the the form you have to make the expiry date for each contract date. I have explained a-z above pls pass it to the ppl who may concern
1. add a field in contract table called Expiry date Then put the validations as contract date.(i mean the validations same as contract date
that is select the data type as date/time and select the format as short date)
2. Then create an update query Select the contract table and package table
3. select the expiry field and in the row "updateto" type "DateAdd("m",[Duration],[ContractDate])" as mentioned on the Update.jpg in the attached file, save it then run it will update the expiry date
4. Now create the the form in wizard
5. Put all the fields in the customer table and all the fied in the contract table except the customerID and PhoneID and select the Phone table and input the PhoneID and Name And Click next and Finish the wizard
6. You will have A form with Subform adjust the field size and make a nice interface
7. Then create a new macro On the first action select "openform" Select the form name as the form that u made nw and in data mode to "add"
8. Then create another form in design view name it as "frmMain"and create a command button and select the macro that u have created and Name it as "New Customer"(i assume that u knw that)
9. Nw you compled the 1st process Add a contract using new customer
10. the a bit hard one creating the contract frm an existing customer
11. I have shown the steps in the screen shots a which I have attached, try to undestand
12. After the 4th Step just close the querry and say "yes"
13. Finally create the button on the frmMain and link to the that macro
Task completed
If you want more about contact me
Images are uploaded below *mark that final link is to 1st image*
http://img682.imageshack.us/img682/6475/updatej.jpg
http://img163.imageshack.us/img163/5...ewcustomer.jpg
http://img707.imageshack.us/img707/8763/5ststep.jpg
http://img85.imageshack.us/img85/1883/4ststep.jpg
http://img689.imageshack.us/img689/417/3ststep.jpg
http://img686.imageshack.us/img686/1152/2ststep.jpg
http://img686.imageshack.us/img686/6333/ststep.jpg
MightyBlyth
hi,
So does this formula join up together? and where abouts do you enter this formula?
Thanks
So does this formula join up together? and where abouts do you enter this formula?
Thanks
First create a query using the design view then select the contract table
in the field type this "MonthsGone: DateDiff("m"[ContractDate],Date())"
Then in the new field "Months Left:12-[MonthsGone]" , in the new field type "info:Iif([MonthsLeft]="1","Contract Expires in one month"
Then double click the Contract ID
there u r
can anyone tell possible inputs, outputs and processes for activity one please, exam tomorrow!:|
farzidh
this is just an help for activity 3
Before creating the the form you have to make the expiry date for each contract date. I have explained a-z above pls pass it to the ppl who may concern
1. add a field in contract table called Expiry date Then put the validations as contract date.
2. Then create an update query Select the contract table and package table
3. select the expiry field and in the row "updateto" type "DateAdd("m",[Duration],[ContractDate])" as mentioned on the Update.jpg in the attached file, save it then run it will update the expiry date
4. Now create the the form in wizard
5. Put all the fields in the customer table and all the fied in the contract table except the customerID and PhoneID and select the Phone table and input the PhoneID and Name And Click next and Finish the wizard
6. You will have A form with Subform adjust the field size and make a nice interface
7. Then create a new macro On the first action select "openform" Select the form name as the form that u made nw and in data mode to "add"
8. Then create another form in design view name it as "frmMain"and create a command button and select the macro that u have created and Name it as "New Customer"(i assume that u knw that)
9. Nw you compled the 1st process Add a contract using new customer
10. the a bit hard one creating the contract frm an existing customer
11. I have shown the steps in the screen shots a which I have attached, try to undestand
12. After the 4th Step just close the querry and say "yes"
13. Finally create the button on the frmMain and link to the that macro
Task completed
If you want more about contact me
Images are uploaded below *mark that final link is to 1st image*
http://img682.imageshack.us/img682/6475/updatej.jpg
http://img163.imageshack.us/img163/5...ewcustomer.jpg
http://img707.imageshack.us/img707/8763/5ststep.jpg
http://img85.imageshack.us/img85/1883/4ststep.jpg
http://img689.imageshack.us/img689/417/3ststep.jpg
http://img686.imageshack.us/img686/1152/2ststep.jpg
http://img686.imageshack.us/img686/6333/ststep.jpg
Before creating the the form you have to make the expiry date for each contract date. I have explained a-z above pls pass it to the ppl who may concern
1. add a field in contract table called Expiry date Then put the validations as contract date.
2. Then create an update query Select the contract table and package table
3. select the expiry field and in the row "updateto" type "DateAdd("m",[Duration],[ContractDate])" as mentioned on the Update.jpg in the attached file, save it then run it will update the expiry date
4. Now create the the form in wizard
5. Put all the fields in the customer table and all the fied in the contract table except the customerID and PhoneID and select the Phone table and input the PhoneID and Name And Click next and Finish the wizard
6. You will have A form with Subform adjust the field size and make a nice interface
7. Then create a new macro On the first action select "openform" Select the form name as the form that u made nw and in data mode to "add"
8. Then create another form in design view name it as "frmMain"and create a command button and select the macro that u have created and Name it as "New Customer"(i assume that u knw that)
9. Nw you compled the 1st process Add a contract using new customer
10. the a bit hard one creating the contract frm an existing customer
11. I have shown the steps in the screen shots a which I have attached, try to undestand
12. After the 4th Step just close the querry and say "yes"
13. Finally create the button on the frmMain and link to the that macro
Task completed
If you want more about contact me
Images are uploaded below *mark that final link is to 1st image*
http://img682.imageshack.us/img682/6475/updatej.jpg
http://img163.imageshack.us/img163/5...ewcustomer.jpg
http://img707.imageshack.us/img707/8763/5ststep.jpg
http://img85.imageshack.us/img85/1883/4ststep.jpg
http://img689.imageshack.us/img689/417/3ststep.jpg
http://img686.imageshack.us/img686/1152/2ststep.jpg
http://img686.imageshack.us/img686/6333/ststep.jpg
Thank you, your awesome!
t_seb
no the bank stuff goes into the customer table
you sure?
cause on the scenario it says the bank details are taken from the customer once the contract is made
animaniac109
I have nearly finished the exam, and understand most of it. So I am willing to help anyone out. Won't give any clues to people who haven't started the exam yet, but will help out people who are already into it. Just with small bits that you don't understand
hey can u say wat r the inputs process and outputs in act1
Quick Reply
Related discussions
- 24th January 2022 BTEC IT Level 3 Unit 1 (Information Technology Systems)
- IAL repeats cash in.
- Choosing a Software MSc
- How to Recover and Convert OST Files
- Edexcel IAL results
- How many GCSEs are you getting?
- Can I still get DDD?
- GCSE Exam Discussions 2024
- Edexcel igcse english language a 2022 may paper 1
- Btec ICT level 3 (information technology) unit 2
- Unethical American Surveillance Recently,
- AS and A level urgent help & advice
- What can I do with ICT
- BTEC Applied Science Unit 7: Contemporary Issues In Science [Jan Set Task Discussion]
- Over 500 questions on AQA Bio Unit 4 + Current Spec and old Spec papers + MS!
- How much should I be revising for my GCSEs over Easter?
- A level Physics Help
- UIUC has no option for Edexcel IAL
- Resit/retake A-levels
- Learn Direct Computer Science Access Course
Latest
Trending
Last reply 1 day ago
Is MathsFM French Alevels good for a CS degree at top uni (OX, UCL, Durham etc)Last reply 3 days ago
OCR A-level Computer Science Paper 1 (H446/01) - 12th June 2023 [Exam Chat]Last reply 2 weeks ago
OCR A-level Computer Science Paper 2 (H446/02) - 19th June 2023 [Exam Chat]Last reply 3 weeks ago
AQA A-level Computer Science Paper 1 (7517 1A - 1E) - 12th June 2023 [Exam Chat]Last reply 1 month ago
Not receiving any response from University of Birmingham.Last reply 3 months ago
OCR GCSE Computer Science Paper 1 (J277/01) - 19th May 2023 [Exam Chat]Last reply 3 months ago
AQA GCSE Computer Science Paper 2 (8525/2) - 25th May 2023 [Exam Chat]Trending
Last reply 1 day ago
Is MathsFM French Alevels good for a CS degree at top uni (OX, UCL, Durham etc)Last reply 3 days ago
OCR A-level Computer Science Paper 1 (H446/01) - 12th June 2023 [Exam Chat]Last reply 2 weeks ago
OCR A-level Computer Science Paper 2 (H446/02) - 19th June 2023 [Exam Chat]Last reply 3 weeks ago
AQA A-level Computer Science Paper 1 (7517 1A - 1E) - 12th June 2023 [Exam Chat]Last reply 1 month ago
Not receiving any response from University of Birmingham.Last reply 3 months ago
OCR GCSE Computer Science Paper 1 (J277/01) - 19th May 2023 [Exam Chat]Last reply 3 months ago
AQA GCSE Computer Science Paper 2 (8525/2) - 25th May 2023 [Exam Chat]
