Solved School database (1 Viewer)

[Mercy Mercy]

I am very new to access. I am trying to make a school database.
In my school some students let's say 15 take subject A and another 25 take subject B and another 30 take subject C.
I am trying to use YES/NO.
For student 1 click yes for taking subject A and C.
Student 2 click yes if taking subject C and so on and so on.

In the end the database should populate the number of students taking Subject A and Subject B and Subject C.

Please kindly assist me with queries or vba.

Thanks in advance.

 

[Mercy Mercy]

I will really appreciate if there is a sample database. Thanks in advance.

 

[arnelgp]

there is a sample, you need to modify it.

 

[Uncle Gizmo]

To highlight a trap that people converting from Excel to access can fall into, I wrote a blog along similar lines to your question.

Excel in Access - Nifty Access

Excel in Access - Problem & Solution! One of the most frequent problems I see is people confusing MS Access with Microsoft Excel. This leads to fundamental design errors. Now, the problem is, this error "A Major Error" does not become apparent straight away. Unfortunately your database will work...

www.niftyaccess.com

 

[Mercy Mercy]

there is a sample, you need to modify it.

Thanks so much. I appreciate.

 

[Mercy Mercy]

there is a sample, you need to modify it.

I am trying to add the following tables
1. Year- combo box to generate years automatically.
2. Term- for 3 terms
Term 1
Term 2
Term 3
3. Name of the school.
Question- how can I create relationships?
Your database works fine. I only want to separate years and terms and name of the school.


Thanks in advance.

 

[arnelgp]

on Classes form, there is already the Term, i change it to combobox to select terms from Term table.
about the Year, you can enter the "Current School Year" in table Default, and when you
enter New student in Classes, it will take the Year from this table.

this is a single School so, the school name is in Default table (if you need to change the name of entity, you also need to change
code that uses it like DLookup()).

see Classes form.

 

[Mercy Mercy]

on Classes form, there is already the Term, i change it to combobox to select terms from Term table.
about the Year, you can enter the "Current School Year" in table Default, and when you
enter New student in Classes, it will take the Year from this table.

this is a single School so, the school name is in Default table (if you need to change the name of entity, you also need to change
code that uses it like DLookup()).

see Classes form.

Thanks

 

[Pat Hartman]

@arnelgp It is better to provide links to the MS examples rather than uploading versions you have modified.

 

[arnelgp]

provide links to the MS examples rather than uploading versions you have modified

it was Not a modified version. i upload it as-is.
only modified it on the OP request.

 

[Mercy Mercy]

@arnelgp It is better to provide links to the MS examples rather than uploading versions you have modified.

I requested @arnelgp to assist me modify. Don't blame him. @arnelgp I am sorry.

 

[Pat Hartman]

Sorry, I saw that RI was not enforced on two tables. I have an older version of that sample and RI is enforced so I thought it had been modified.
@Mercy Mercy You seem to be living up to your name. No one was being attacked, I just wanted to make sure you had the unaltered example. It is quite easy to accidentally modify the MS templates once you download them, there is so much wrong with all of them.

 

[Mercy Mercy]

Sorry, I saw that RI was not enforced on two tables. I have an older version of that sample and RI is enforced so I thought it had been modified.
@Mercy Mercy You seem to be living up to your name. No one was being attacked, I just wanted to make sure you had the unaltered example. It is quite easy to accidentally modify the MS templates once you download them, there is so much wrong with all of them.

Thanks. Much appreciated.