Re: Constructing a form for tracking student attendance
- From: "John Marshall, MVP" <lancucki@xxxxxxxxxxxxx>
- Date: Tue, 11 Oct 2005 19:41:11 -0400
Data model is a concept rather than an object. It is used to describe the
tables and their relationships in your solution. The simplist way is to draw
the tables and their relationships on a piece of paper.
For your case, you need at least three tables:
1) student table - contains information about the students and a key to
identify the student.
2) class table - contains information about the classes anda key to identify
the class
3) attendance table - contains information about attendance with references
back to the student and class tables.
The attendance table can contain an entry whch represents the attendance for
each student in each class. The attendance table could also have a record
for a week's attendance.
John... Visio MVP
Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
Visio Wishlist http://www.mvps.org/visio/wish_list.htm
"KhaledDK" <KhaledDK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DACC26AF-7F8C-45F0-A7D3-E3D87A1CF64E@xxxxxxxxxxxxxxxx
> Thanks for the rapid answer.
> Can you give me more information about how to create a "data model".I have
> never met such an object in access 2003. Notice that i don't have the
> developer version of access. Can you kindly support me with more specific
> information about which tables I should create?
>
> "mscertified" skrev:
>
>> First you create a data model and from that you create tables to hold
>> your
>> data.
>> You normalize the tables to eliminate repeated data. You then relate the
>> tables to ensure data integrity.
>> From these tables, you then build forms to update and manipulate the data
>> in
>> the tables.
>> Access Help is the resource to build the forms and the logic for form
>> handling.
>>
>> Dorian
>>
>> "KhaledDK" wrote:
>>
>> > I'm trying to develop an application for tracking student attendence. I
>> > want
>> > to list the students names for a class at one side (left side) and a
>> > grid for
>> > inserting the student status (present, absent, late etc.) to the right.
>> > The
>> > grid cells contain combo boxes to assign the status for the student.
>> > The grid
>> > column headers contain dates from 1 to 31. The form should look like
>> > this:
>> > Class Month
>> > ------------------------------------------------------------------------------
>> > Day1 Day2 Day3 Day4 Day5 Day6 Day7
>> > ....DayN(28/29/30/31)
>> > 1 2 3 4 5 6
>> > 7
>> > ..... 28/29/30/31
>> > StudentName1 Cbo1 Cbo2
>> > CboN
>> > StudentName2
>> > StudentName3
>> > .
>> > .
>> > StudentNameN
>> > Class is a combo box for choosing a particular class
>> > Month is a combo box for choosing a particular month
>> > CboN is a combo box containing the status types (Present, Absent, Late,
>> > etc.)
>> > I really need tips, ideas, examples, readings, refernces for building
>> > this
>> > application. Every information will be wellcome and appreciated.
>> > I have basic / medium knowlodege about access.
>> > Thanks very much
>> >
.
- Follow-Ups:
- Re: Constructing a form for tracking student attendance
- From: KhaledDK
- Re: Constructing a form for tracking student attendance
- Prev by Date: Re: shading alternate rows in MS access forms
- Next by Date: Re: Filter by Form
- Previous by thread: Re: shading alternate rows in MS access forms
- Next by thread: Re: Constructing a form for tracking student attendance
- Index(es):
Relevant Pages
|
