Recent content by D.J.Ida

  1. D

    Help with bookstore db

    Thank you. Believe me, I would like to just focus on the specific things you mentioned, but I cannot. All of these other things are also my duties.
  2. D

    Help with bookstore db

    Also, has it occurred to you that I would like to learn this program for myself? I am an amateur bookbinder, and lately people have been contacting me to bind blank and printed works for them. I thought it would be interesting to try and make a database in which I could track these requests and...
  3. D

    Help with bookstore db

    Thank you for your advice, but we obviously cannot see eye to eye. I keep telling you what our current process is, as directed by the admin, and you keep telling me what I should change. That is not an option at this moment. We DO assemble all books for each student. Everything is ordered a few...
  4. D

    Help with bookstore db

    Again I thank you for your time, and repeat that the reality is that I also have to do these other things. Book orders are just a small part of my job. Can someone tell me which tables they are (I'm guessing books, courses and suppliers) and how to integrate the less relevant tables (which I...
  5. D

    Help with bookstore db

    It is nearly midnight, and I will be retiring, but could someone tell me if I'm on the right track when it comes to organizing my tables or entities, if that's what they're called? I haven't yet attempted to create any relationships before I determine if I'm missing some information, or if some...
  6. D

    Help with bookstore db

    "They should be giving YOU this report--" that would be nice, but it's not the reality. Is there a way to make this work within the constraints of what I have to do?
  7. D

    Help with bookstore db

    Oh OK, I didn't know that, thank you. I will keep that in mind for the future.
  8. D

    Help with bookstore db

    It does need that information, because the admin wants me to present them with a report of every course package within every department, year and semester. I recognize this complicates things, but I don't know how to uncomplicate it for myself and still present the admin with every detail they...
  9. D

    Help with bookstore db

    OK, I think I'm beginning to see. One of the linked examples mentioned the many-to-many relationships, and if I remember correctly, said that the way to deal with this was to introduce a table as a go-between for the table that are in a many-to-many relationship. One thing I noticed as I was...
  10. D

    Help with bookstore db

    Fair enough; thank you for trying to help in any case.
  11. D

    Help with bookstore db

    Yes, I'm trying to understand these concepts; I've used Excel for several years to manage our book orders, but it has become increasingly difficult since the university is growing and offering more departments and courses. I was told Access would be a better choice. The developers are currently...
  12. D

    Help with bookstore db

    Alright, got it!
  13. D

    Help with bookstore db

    No, this is an example from one of the links I was recommended to look into, in order to understand how Access handles data better. It's been 10 years or more since I opened Access, and even then it was a very short course where we were guided on what to d and how to do it. So I'm trying to...
  14. D

    Help with bookstore db

    Hi, just one question if I may: I'm going through the ZYX laboratories example, and I'm trying to create the attribute grid, but I'm having trouble assigning primary keys as in the example. Am I supposed to be working in database view or design view? Because it seems that the primary key can...
  15. D

    Help with bookstore db

    Wait, students should also have information on which department, year and major/minor they belong to? Students StudentID StudentLastName StudentFirstName StudentDepartment StudentYear StudentMajor StudentMinor
Back
Top Bottom