urgent, need help for my assignment (due date is 16 Jul)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have some question about input mask, relationships and report, can any1
help me? Please add me in msn messenger (e-mail address removed), just give me few
minutes!! leave me a message when you added me, please help!!

thanks alot!!
 
Feel free to post your specific questions here. The whole point of
anewsgroup is to post questions and answers so people can view them if they
encouter similar issues.

You might even try searching the previous posts for answers to YOUR
questions.
 
nick said:
i have some question about input mask, relationships and report, can any1
help me? Please add me in msn messenger (e-mail address removed), just give me
few
minutes!! leave me a message when you added me, please help!!
Click to expand...
I doubt you'll get anyone from here to do that. Post your questions here
where the answers you get can benefit everyone.

Regards,
Keith.
www.keithwilby.com
 
a) i) The first table DATA is given as below:

Student Number Name Address Contact Number
PS001 nick Jalan gegr 03-31482202
PS002 alice Jalan rgrgrg 03-31418901
PS003 simon Jalan efef 03-31248900
PS004 andy Jalan ykytk
03-34216781
PS005 calvin Jalan ykt76k 03-3307654
ii) The second table PERSONAL is given as below:

Student Number Form Stream
PS001 3 SCIENCE
PS002 5 SCIENCE
PS003 3 IT
PS004 4 ACCOUNTS
PS005 3 SCIENCE

iii) The third database FEE is given as below:

Stream No of subjects Fee per subject (RM)
ARTS 12 45
SCIENCE 9 55
ACCOUNT 11 65
IT 10 125


b) Answer all questions :
i) Create all the three tables above. List each table with appropriate
field names and
field types
ii) By using appropriate formula, get and calculate the total fee for all
the students
based on their streams.
ii) Create relationships between all the three tables DATA, PERSONAL and
FEE

iii) Create a creative and appropriate form to key in data for table DATA.
iv) Create a report to display Student Number, Name, Contact Number , Form
and
Total Fee.
v) Create a report to display all field names for all the three tables
 
nick said:
a) i) The first table DATA is given as below:
Click to expand...
<snip>

If you don't know how to use Access and don't even know how to create a
table then, frankly, the chances of you getting this done in two days are
nil unless some kind soul either spells every step out for you or does the
assignment themselves. Why such a tight deadline?
 
i know how to create table!! but i had problems with the relationships, can
you help me? -->messenger...
 
We are not here to do it for you.

I meant, if you needed specific help with a particular issue.
 
Back
Top