Search results

I have created a profiling database for my school. Each student can access their own form via the school's admission number - which I use as the primary key for most of the tables on the form. One section of the form shows a photo of the student. I take this photo from the school's SIMS photo...

Hi, I have created a profiling form for my school. Each boy can access his form using his admission number ( Adno) which is the primary key. On the form are lots of sub forms - for things like favourite authors, clubs, teams played in etc - but these don't have a primary key ( as they are...

Hi, I am designing a profiling database for my school and want to make it so that when the children fill in the forms they can't right click on the title bar and see the menu which allows them to go to design mode and change my database form design. Ideally i want them only to be able to see...

Hi, I have set up a database for the clubs at my school. It has 3 tables: Members : fields- Idno, Forename,Surname Clubs: Fields - Clubid, Clubname Membership: Fields- Idno, Clubid, Active I can find information from the tables via queries/forms and reports. I have filled out the Members...

Hi, I am writing a database in Access 2003 for my school about the membership of school clubs. My main table has fields: admission number - primary key first name surname Fencing Judo Table tennis etc The club fields are either blank -if the person isn't and has never been a member- or Y fro...