Search results

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.

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...

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...

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...

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...

"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?

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

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...

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...

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

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...

Alright, got it!

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...

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...

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

I would definitely want to simplify it. As for the used books, the majority of the students keep their books or if they decide they no longer want to keep them, they donate them to the library. Earlier editions aren't returned and the instructor makes accommodations for anyone with the earlier...

The courses offered to students are not static; different pathways and courses are offered based on various factors, and it is possible for a course to be moved from one semester to another when necessary. Not all departments have pathways, and departments have common courses for the first or...

Currently using Excel for orders, with the following columns: Year Department Course code & title Course Instructor Book title Author ISBN Publisher Edition Year Student copies Instructor copies Bookstore copies E-Resources (Yes / No) To order (student + instructor – bookstore = total)...

This is the structure of the departments: Orders for two entities at separate physical locations: University Secondary school University Departments: CSIS, splitting into CS and IS major from Year 3 Minors in years 3 and 4: Electrical Engineering, Economics, Management Gaming ECON with...

I do have an example, and I'm trying to lay it all out "on paper", so to speak, but it's difficult to present it all in a simple way because there's so many options with some departments having different tracks or pathways, so that the courses offered one year may not be the same next year. Some...