Search results

  1. J

    Help with database design

    I am a MS Access novice, and am looking to develop an application based on Access 2007/10: - It is meant for a government agency that is tasked with assessing clients needs for certain equipment. - The agency sends an assessor to meet the client and produce a report highlighting the...
  2. J

    Fixed menu advice please...

    I am looking to create an application. I want it to have a menu (i.e. a few buttons) on the left of the screen with the rest of the screen providing the space for the various forms, depending on the menu choises made. My problem is that I want the menu to always remain visible - something...
  3. J

    Advice on database design-How am I doing so far?

    I am designing a database for an after school club(s), that should be able to handle (amongst others): - Keeping a record of the children + Personal details + Health details (allergies, special needs, etc) + Which school attending + Which after school centre attending...
  4. J

    Maintaining hostoric data in DB-how?

    I am pretty new to all this Access stuff, so please bear with me... I am trying to get my head around a problem that's been bugging me when designing a database: - Say you have a DB for maintaining a record of product range, prices, orders, customers, inventory, etc - The price of...
  5. J

    Values in a combo box - how?

    My DB has (amongst others) two tables: 1. Centres - CentreID as primary key, and centre name a text field; and 2. Children: ChildID as primary key, and a Centre field referring to the CentreID above. It also has many other fields. I am trying to create a form that will display a list box of all...
  6. J

    Problem with form for Many-2-Many relationship...

    I am in process of designing a DB for an after school club. It has a children table, and a parent/guardian table. It also has a many to many relationship between the above tables using a "junction" table which also holds information about the nature of the relationship and whether a...
  7. J

    Help with database design

    I am looking to develop an application based on Access 2003 (I also have access to v2007 and 2010, and can use them if there is a need) that will do the following: - Help to manage multiple after school centres (currently there is one, but there will be more soon). - Keep information about all...
Back
Top Bottom