CREATING A SEARCH CRITERIA IN A FORM (1 Viewer)

I am alive

Member
Local time
Today, 18:56
Joined
Aug 29, 2020
Messages
75
Hi everyone. I am still new in access.
(I HAVE ATTACHED THE DATABASE I AM MAKING)
1. I am trying to create a search criteria in a form called grade marks where after selecting a subject from a drop-down menu you are able to search the name of the child based on upi/index number/adm no or just by typing the name of the child.
2. Also after adding marks scored by the learner I am unable to edit marks based on a function. How can I change the function to allow me edit marks for the learner.
3. Lastly, I want to make reports. Somebody please help me to come up with reports from grade marks. A learner can take some subjects not all of them.
4. I want to find the average of marks attained by learners based on subjects he or she takes.
Attached is the database I am making. Thanks in advance.
 

Attachments

  • Student Marks.zip
    60 KB · Views: 173

mike60smart

Registered User.
Local time
Today, 15:56
Joined
Aug 6, 2017
Messages
1,047
Hi
There are all sorts of things wrong with your current structure.

There should not be any spaces in field names.
You should not use any characters other than A-Z and Underscore when naming fields.
You should NOT use Lookup fields in Tables.

Your Students table needs to be normalised.

The student table should only contain fields that describe the Student. All of the following
fields should be in other related tables:-

Examination Type
Term
Special Medical Condition
Physician Name
Physician Phone Number
Allergies
Medications
Insurance Carrier
FATHER'S NAME
FATHER'S PHONE NUMBER
FATHER'S ID NUMBER
MOTHER'S NAME
MOTHER'S PHONE NUMBER
MOTHER'S ID NUMBER
GUARDIAN'S NAME
GUARDIAN'S PHONE NUMBER
GUARDIAN'S ID NUMBER
STREAM
CLASS TEACHER
DORMITORY
ENGLISH
KISWAHILI
MATHEMATICS
SCIENCES1
SCIENCES2
SCIENCES3
HUMANITIES1
HUMANITIES2
HUMANITIE3
PRACTICAL SUBJECTS
TECHNICAL SUBJECTS
 

I am alive

Member
Local time
Today, 18:56
Joined
Aug 29, 2020
Messages
75
Hi
There are all sorts of things wrong with your current structure.

There should not be any spaces in field names.
You should not use any characters other than A-Z and Underscore when naming fields.
You should NOT use Lookup fields in Tables.

Your Students table needs to be normalised.

The student table should only contain fields that describe the Student. All of the following
fields should be in other related tables:-

Examination Type
Term
Special Medical Condition
Physician Name
Physician Phone Number
Allergies
Medications
Insurance Carrier
FATHER'S NAME
FATHER'S PHONE NUMBER
FATHER'S ID NUMBER
MOTHER'S NAME
MOTHER'S PHONE NUMBER
MOTHER'S ID NUMBER
GUARDIAN'S NAME
GUARDIAN'S PHONE NUMBER
GUARDIAN'S ID NUMBER
STREAM
CLASS TEACHER
DORMITORY
ENGLISH
KISWAHILI
MATHEMATICS
SCIENCES1
SCIENCES2
SCIENCES3
HUMANITIES1
HUMANITIES2
HUMANITIE3
PRACTICAL SUBJECTS
TECHNICAL

Hi
There are all sorts of things wrong with your current structure.

There should not be any spaces in field names.
You should not use any characters other than A-Z and Underscore when naming fields.
You should NOT use Lookup fields in Tables.

Your Students table needs to be normalised.

The student table should only contain fields that describe the Student. All of the following
fields should be in other related tables:-

Examination Type
Term
Special Medical Condition
Physician Name
Physician Phone Number
Allergies
Medications
Insurance Carrier
FATHER'S NAME
FATHER'S PHONE NUMBER
FATHER'S ID NUMBER
MOTHER'S NAME
MOTHER'S PHONE NUMBER
MOTHER'S ID NUMBER
GUARDIAN'S NAME
GUARDIAN'S PHONE NUMBER
GUARDIAN'S ID NUMBER
STREAM
CLASS TEACHER
DORMITORY
ENGLISH
KISWAHILI
MATHEMATICS
SCIENCES1
SCIENCES2
SCIENCES3
HUMANITIES1
HUMANITIES2
HUMANITIE3
PRACTICAL SUBJECTS
TECHNICAL SUBJECTS
Thanks for your input. Kindly update the database and assist me. God bless you so much
 

mike60smart

Registered User.
Local time
Today, 15:56
Joined
Aug 6, 2017
Messages
1,047
Hi

The idea is that you take note of comments and where possible amend your tables accordingly.

If you do this then upload your reworked database we will help further.
 

I am alive

Member
Local time
Today, 18:56
Joined
Aug 29, 2020
Messages
75
Hi

The idea is that you take note of comments and where possible amend your tables accordingly.

If you do this then upload your reworked database we will help further.
Thanks. Let me update and post. Thank you so much
 

I am alive

Member
Local time
Today, 18:56
Joined
Aug 29, 2020
Messages
75
Hello. I have attached updated database. I am still new in ms access.
Reports should contain
1. Upi/index no/ adm no
2. Student name
3. Subjects
For example
ENGLISH
KISWAHILI
MATHEMATICS
BIOLOGY
PHYSICS
AGRICULTURE
CRE
Meaning the learner can do 7 subjects out of 24.
Also in grade marks form, after selecting the subject in drop-down, search criteria should search for the learner either by using upi/index no/adm no.
Also in grade marks, period after you input marks you cannot edit because of before update event.
Thanks in advance. God bless you.
 

Attachments

  • Student Marks.zip
    111.9 KB · Views: 141

I am alive

Member
Local time
Today, 18:56
Joined
Aug 29, 2020
Messages
75
Hello. I have attached updated database. I am still new in ms access.
Reports should contain
1. Upi/index no/ adm no
2. Student name
3. Subjects
For example
ENGLISH
KISWAHILI
MATHEMATICS
BIOLOGY
PHYSICS
AGRICULTURE
CRE
Meaning the learner can do 7 subjects out of 24.
Also in grade marks form, after selecting the subject in drop-down, search criteria should search for the learner either by using upi/index no/adm no.
Also in grade marks, period after you input marks you cannot edit because of before update event.
Thanks in advance. God bless you.
Reports to contain
1. Upi/index no/adm no
2. Student name
3. Grade/ Form
5. Subjects done by learners e.g 7 subjects out of 24
5. Total marks of subjects done.
6. Average marks per subjects done
God bless you so much
 

I am alive

Member
Local time
Today, 18:56
Joined
Aug 29, 2020
Messages
75
Kindly check this updated database
 

Attachments

  • Student Marks.zip
    146.2 KB · Views: 126

mike60smart

Registered User.
Local time
Today, 15:56
Joined
Aug 6, 2017
Messages
1,047
Sorry but the updated database has had nothing done to it.

Luck with your project, maybe someone else is willing to do all the work for you.
 

I am alive

Member
Local time
Today, 18:56
Joined
Aug 29, 2020
Messages
75
Sorry but the updated database has had nothing done to it.

Luck with your project, maybe someone else is willing to do all the work for you.
Hello. Have a look at the attached updated database. Sorry for not understanding what you implied. Actually, the information you had highlighted from my table is not needed. I have deleted. I am just making grade marks database for the school. Thanks in advance. God bless you
 

Attachments

  • Student Marks.zip
    74.5 KB · Views: 62

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 15:56
Joined
Jul 9, 2003
Messages
13,796
Kindly check this updated database

As Mike indicates there are substantial issues with your current database format. If you take his advice and restructure your database and post it back in the forum, I'm sure you will get some help. To help you along in your task, look at my blog here:-


Where I demonstrate in videos and text the problem(s) you need to sort out. Fortunately my example more or less matches your problem (students and subjects) You should be able to construct your database in the correct manner by following the instructions on my website.

I also provide a tool (The transpose Tool) to help you carry out this modification to your database.

You have the option to pay for it. Alternatively, if you want a free copy contact me in a private message through Access World Forums and I will explain how you can get a free copy....
 

I am alive

Member
Local time
Today, 18:56
Joined
Aug 29, 2020
Messages
75
As Mike indicates there are substantial issues with your current database format. If you take his advice and restructure your database and post it back in the forum, I'm sure you will get some help. To help you along in your task, look at my blog here:-


Where I demonstrate in videos and text the problem(s) you need to sort out. Fortunately my example more or less matches your problem (students and subjects) You should be able to construct your database in the correct manner by following the instructions on my website.

I also provide a tool (The transpose Tool) to help you carry out this modification to your database.

You have the option to pay for it. Alternatively, if you want a free copy contact me in a private message through Access World Forums and I will explain how you can get a free copy....
I rectified those issues. I deleted. They are not needed.
 

Attachments

  • Student Marks.zip
    74.5 KB · Views: 66

I am alive

Member
Local time
Today, 18:56
Joined
Aug 29, 2020
Messages
75
Kindly check the database and assist me come up with seaech criteria.
Please someone to assist me come up with the report if the student does the following subjects let's say 7 out of 24.
Subjects
1. English
2. Kiswahili
3. Mathematics
4. Biology
5. Physics
6. CRE
7. Agriculture.
How will arrive at the totals of subjects done and the average. Thanks in advance. Check the database please
 

Attachments

  • Student Marks.zip
    74.5 KB · Views: 179

Users who are viewing this thread

Top Bottom