Student Detention Database - Layout And Limit via Date

[Jiggles1987]

Hi All,

Problems:
What tables should i create that suits 'normalisation'?
Do I need to do anything different if I intend to upload this to Sharepoint and have a sharepoint entry or Infopath component.?
How do I limit to only 25 Students on a given date?

Student Data is Imported in from Excel spreadsheet

Basic Access User, but need to move on from Excel UI's.
I have read alot of content, and searched a number of forums, but have still not found a solution.
Trying to wrap my head around starting up a database that will allow a teacher to add students to a detention roster on a specified date.


Any suggestions would be greatly appreciated.
Thankyou in advance.

Jiggles

[June7]

For starters you need to identify the data entities and relationships. Review this tutorial: http://forums.aspfree.com/microsoft-...es-208217.html

Post your design for analysis (start a new thread).

I think Sharepoint might be limited to use of macros, which means no VBA code.

When you encounter specific issue, post question and we will try to help.