Recent content by Wally2k5
-
W
Student Results Database Design
Plog, Is that true even with multiple exams per course? I see what you're saying but I'll leave Course_Number in for the moment as that is how we refer to each of the courses. I'll have a play with the database and see how far I get! Wally- Wally2k5
- Post #8
- Forum: Theory and practice of database design
-
W
Student Results Database Design
Plog, The Course_Number is the sequential number to identify that individual course through the year. Ie the first course is Basic Course 1/14, the second Basic Course 2/14 etc. Do you think I need another table for Exam_Type (one line for each type of exam we run, ie Exam 1 for Basic...- Wally2k5
- Post #6
- Forum: Theory and practice of database design
-
W
Student Results Database Design
Plog, Thanks for your reply. I have got a Course_Type table as follows: Course_Type Course_Type_ID Course_Type_Name Course_Type_Notes This lists the five types of courses we train over the year. Ie Basic Course, Advanced Course etc. Then the Course table lists each of those courses...- Wally2k5
- Post #4
- Forum: Theory and practice of database design
-
W
Student Results Database Design
Hi, I'm after a little help with designing a student records databse from scratch - I'm reasonably familiar with Access but can't get my head around this design. I have multiple students who attend four different courses at our school (they can take each course more than once). During each...- Wally2k5
- Thread
- Replies: 8
- Forum: Theory and practice of database design
-
W
Wine Format Query
Is there a way in which I can set an input mask for the [Quantity] field in my tbl.Products? and have the format so it displays in the format A-B -
W
Report on single record
In need of help :eek: I have a form which shows for any one Function the wine that was used, the wine details are displayed in a subform. I have a button which should print preview a report which shows the Function information and the Wine Information for that function only. At the moment... -
W
Wine Format Query
Thank you very much for a very helpful reply. Is there anyway in which I can display it all in one box, it must be an input mask of some description. -
W
Wine Format Query
Hello, First I apologise if this is in the wrong forum, I couldn't decide and guessed someone may move it if required. I am currently attempting to create a database for a wine cellar. This requires to be able to count in cases of 12. I want to express the stock as number of cases and number...