Search results

  1. Tangent

    Database and Table design to accomodate future statistic reports?

    The 'Pupil Details' table of my driving school database includes the fields: 'Pupil Type' (Learner with no previous experience; Learner with previous experience; refresher, etc) 'Age at Start' 'Sex' with the 'Pupil ID' (a six digit number with the first two digits denoting the year) as...
  2. Tangent

    Edit Record Button?

    I have the beta version of Access 2010 and have created a form for one of my tables and set allow edit and allow delete to No so that I can't easily accidentally alter any of the info in the table. I used the Command Button Wizard to create Add Record and Save Record and Delete Record buttons...
  3. Tangent

    Office Professional 2002

    I have Professional 2002 which is no longer supported as far as I can see. Now that I am trying to create a database for my business I think it is probably wise to upgrade. Professional 2007 is currently about £350 and this would be difficult for me to afford. Can any of you answer any of the...
  4. Tangent

    Tabbed Form - Totally baffled!

    In my address book I created about 8 years ago I have a lovely tabbed form with a william morris design on the front and different controls on every tab. Totally forgot everything I picked up back then So following the instructions on the microsoft site But no matter what I do all the tabs...
  5. Tangent

    Solution for a drop down list to fill in form

    In my driving school database I currently have three related tables: Pupils Prices Lessons I also want to create a table for TestResults with fields for all the criteria on the driving test form so that I can monitor whether I have any weaknesses in my tuition skills or whether any particular...
  6. Tangent

    Working out age at a certain date from a DOB field

    I have found an expression for a query to do this. I have a table with a DOB field for each of my pupils and also a StartDate field for when they started having lessons with me. Is it possible to use Age:[StartDate]-[DOB]/365.25 in another field of the table 'StartAge' If so where do I put...
  7. Tangent

    Hi from an excited newbie in Access and Excel

    Hi everyone, My name is Lois, I am 47 and I run a driving school here in London. I ended up petrified of tax returns. I went solo in May 05 having done about 11 years with a large national driving school (when I employed an accountant) and then serving just 18 months as a Police Officer before...
Back
Top Bottom