hi everyone, this is first post, i have this task and i think i have the solution but im not sure, so plsplsplspsssssssss someone help!!!!
its called class scheduling. below is the physical model. i need to make the logical, i have been told that course and section share a many to many relation as well as section and faculty and also bwee/ faculty and course, thus the creation of the intersection tbl, the OFFERINGS TABLE. i have inserted the foreign keys (FK's) into that table (which are the primary keys for the 3 main tables). what i need to know is that:
1. do i need anymore FK's?
2. wen i make my logical diagram, do i show it like the way i have shown it in the word file? i made it as such that course and section have the PK of the 2 tables and are now FK which allow duplication ie 1 course can have many sections etcc pls helpppppppppppp
Courses table
CourseID (PK)
Title
Credits
Sections table
SectionsID (PK)
Days
Time
Faculty table
FacultyID (PK)
Firstname
Lastname
department
Title
FullTime or partime
hiredate
I’m using MS Access 2000 – I’ve been building, using and updating an Access database for a while now, and I’ve been living with two problems that are causing problems to its use.
The first problem appears minor, but relates to the second problem…. I keep the database in my shared documents folder on my PC, so a colleague and I can both use it at the same time.
When we have the same form open – if I click on the “save” icon it comes up with an error “you do not have exclusive access to the database at this time” and the recordset that I am working on cannot be saved. This is causing problems because if I enter fresh data into the form, and then click a command button to run a query against it, it comes back with blank results because it has not been saved to the table yet – so I have to exit out of the form so it saves the data, then go back into the form so the query runs properly.
Are there any settings I can apply so I can save the data to the table without having to exit and re-enter the form again?
The second problem is more difficult and has had me tearing my hair out for a very very very long time – if anyone could help me with this problem I would be indebted to them…
After I’ve entered all the data into my form, I need to export/transfer 4 of the fields to a .csv file.
I would have thought that the logical thing to do would be to have a command button that performs a macro, which it turn;
Saves the data to the table runs a query which selects the 4 fields I require then exports the Query’s results to the csv file.
When I’ve tried this, obviously the problem of saving the data remains, but even when I exit out of the form and re-enter so the data has been saved to the table – I can’t get the export to work!
I’ve tried exporting the query manually from the query view, however it comes up with an error stating that “TOO FEW PARAMETERS. EXPECTED 1” I’ve tried Macros that “Outputs to” and “Transfer Text” – however I can’t get any of them to work. I managed to export a table and save the export procedure, then tried to use this procedure when exporting a query, but again I couldn’t get this to work. I’ve also tried adapting VB codes that have been posted on this forum before, however as I’m not too hot on coding I’m not sure whether I’ve been making mistakes or if there is something wrong with the architecture of my database that is preventing the export from working.
Would anyone be able to take a look at the database for me please? I’ve uploaded it here – http://www.qualitytoolsltd.co.uk/accessdatabase.zip - I’ve deleted everything except for the tables, queries and forms that rely on the export query.
It contains a table (“Orders”) that stores the form’s data, a query (“QuotefromorderstblQuery”) that filters our “Quotes” from our “Orders” (I keep “Quotes” and actual “Orders” in the same table but have a [Quote/Order] field that distinguishes them apart), and a form (“QuoteEntryForm”) that is linked to the query to show our Quotes.
Also included is the query (“exporttocsvquery”) that I am trying to export to a csv file. On the form there is a command button called “Run CSV Query” that runs the query – but I’ve deleted all the various buttons and code that I’ve tried to get it to export to avoid confusion.
Also on the form is a button called “Process Order” – this can be ignored as clicking this just changes the [Quote/Order] status to “Order” and the recordset won’t show on this form anymore.
If anyone could please try and help me understand how to overcome these problems – I would be extremely greatful!
The four fields that I am trying to export are; [Customer Name],[Customer Address],[Customer Postcode] & [Total Selling Price inc VAT] – I have highlighted them with red text on the form
If I can solve the first problem of saving, what I am trying to achieve is the creation of a Macro, which is programmed to: 1.Saves the data to the “Orders” table 2.Runs the “Exporttocsvquery” using the Order ID as the select criteria , so it shows the current records being displayed on the form as the query’s results. 3.Exports the Query results to a .csv file on my hard drive. 4.Launch a custom application that I’ve programmed to run using the data in the .csv file.
Thank you very much for taking the time to read this marathon post. Any help, advice, guidance, anything at all would be appreciated very much indeed.
I have a continuous form, that displays in the body the results of a number of selections from a previous form.
In the header I have a message that I want to either shown or hide depending on the result of the following code in the "On Current” event;
Private Sub Form_Current()
If Text29.Value = 0 Then Label32.Visible = False
End If
End Sub
The default form Label32 is for it to be visible. Text29 is unbound and derives it's value from "=Min([WareHouseID])-Max([warehouseid])" no problem there.
The problem is that test does not perform as I expect it to. I have tried all sort of combinations and permutations but can not get it to respond correctly. It seems to think that Text29.Value is equal to zero regardless of the result it is showing
I'm guessing that there is something about continuous forms I have not yet learned :(
Can anyone point me in the right direction to produce an application diagram.
Sort of a map of an app, what data it hold in laymans terms rathers than table and field definitions. What forms do what, and how the whole application fits together.
Hello I would like to make a table Relationships diagram to enforce referential integrity.
I wanted to make this diagram in the Back End container but I realized if I want to delete a corrupt table I have to delete the relationships as well.
(My clients might need to delete an individual corrupt table and replace it with a previous copy. This will cause the relationship to be removed and I don't expect my clients to re-establish this relationship.)
My question is: What if I put the relationship diagram in the Front End container? Will this enforce all the integrity rules? I assume if I put the diagram on the front end ... the user can replace tables in the Back End and the relationships diagram will be unaffected on the FE.
Any input on this topic would be appreciated thank you.
Hi i'm building a database with access for a computer business which sells computer products. The database is going to be from the point of view of the business not the customer. I'm having some trouble with the Relationship diagram, so far i have done this http://img509.imageshack.us/my.php?i...atabasefa1.jpg
The aim of the database so for the customer to purchase product, and the business records this transaction. Its from the point of view of the business not the customer. The business uses a supplier for its products and has no physical stock on hand.
Is there an easy way to get an explanation of where each query within the Db gets it's data from?
I'd ideally like to get a hierachical model - be it as a diagram, text, or whatever - along the lines of
QueryABC gets data from QueryD and QueryE QueryE gets data from Table1 QueryD gets data from QueryX QueryX gets data from Table2
I've only just needed to look at the existing queries in this Db in any detail and I'm hoping there's some faster way to sort this out, rather than manually opening and listing each one.
Hello forum,I am new to designing databases and am excited to learn everything I can. I have read about normalization and relational structures and just need some assurance that I’m on the right track. I’m not looking for someone to design this database for me but am looking for someone to help critique what I have so far which is some user requirements and a RSD. My RSD is attached below.What I am building is a database to track carpets that have been cleaned in rooms which are in buildings. Employees clean carpets in rooms in a building. Many employees can be assigned to a carpet cleaning project. Employee’s record which building they are in, what room's carpet they are cleaning, what day and time they started and ended cleaning, what materials and method of cleaning they used, and the reason for the cleaning. Depending on the reason, the customer is charged a certain rate per hour of carpet cleaning. I am hoping to be able to query from this database to be able to answer, when the last room was cleaned, how long did it take to clean a room, and how much did it cost to clean a room. Some questions I have are: What attributes should be included in the PROJECTDETAIL table and not in the PROJECT table? When should I create a table showing DETAILS of an entity? How do I know when I should have an associative table or correlation table? Am I on the right track in creating this database? Thanks for your help!
I need some help. I have to design a relational database for a small bookstore that operates 3 stores.Books are sold by a sales person to a customer through an order. A order may consist of one or more books but assume that for a given order, all the books sold are all from one store and are sold by one salesperson.
Field name Address Author ID Author Name Book ID Book Type Book type description City country Cust ID Cust name Cust Type Cust type descr Email On hand Order date Order no phone number phone typr phone type descr postcde publisher ID Publisher name quantity salesperson ID Salesperson name Salesperson Phone Selling Price Store Address Store City Store email Title
I am developing one software in access 2000. Now where i stuck up is ... Customer is asking for " process flow chart" (steps in block diagram). The requirement is as below..
For a pen there are below operations 1. moulding 2. cleaning 3. polishing 4.assembly
Now these flow of operation is to be presented in block diagram. Please suggest me how do I do this in accesss? (in form or report)...
Using access 2010; anyway to create an er diagram from an existing database? I have inherited a fairly large database and need to make changes to some field properties and need to find out where these fields are located. I know I can go into tools and run the documenter but doesn't give me an easy format to look at.
what means a table to appear as an entity on the diagram? And how to identify the cardinality of a relationship and how to specify which is mandatory and which is optional.
All I have taken over a database. It has dozens of queries. Is there a tool or code that I can use that would quickly diagram the querie like a flowchart telling me what queries are related and the steps and so on.
1.) pink arrow // I've changed the titel in a diagram with vba ... is there also a methode to move the position of the titel with vba ( left-center or rigth ? )
2.) red arrow // maybe its because of the titel placement.I would like to change the size of a diagram with VBA code to have the diagram fit nicely to a given space best thing would be if there would be a possibility to resize the diagram in the given space
I am creating an EPOS system for a bookstore and I have a many to many relationship between the transactions table (tbl_transactions) and the products table (tbl_products) using a link table (tbl_linktblproductstransac). The below diagram shows what i mean below:
I made it many to many because 1 transaction can have many products on it and 1 product can be on many transactions.
Now what I need to know is how will i make records with more than one product on one transaction (in the table itself or in a transaction form). I would really appreciate if someone could help. Thanks :) and have a good Easter
I am currently taking a database design class using Access 2003 and am looking for some help. I am trying to draw a dependency diagram before I create the tables based on the following attributes / fields in one table named Student:
StudentNumber, StudentName, StudentMajor, student's AdvisorNumber, AdvisorName, AdvisorOfficeNumber, AdvisorPhone, student's NumberCredits and student's Class (freshman, sophomore, etc.)
So far I have identified the Primary Keys as StudentNumber and AdvisorNumber and this is what I have:
Table #1 - Student = Student Number functionally determines Student Name, StudentMajor (?) NumberCredits and Class Table #2 - Advisor = Advisor number functionally determines Advisor name, office number and phone
The problem I run into is with the the StudentMajor / Advisor / StudentNumber relationship. Since one student can have many majors and therefore many advisors since there is only one advisor per major, and each advisor has many students I am assuming it is a many-to-many relationship.
The problem I am having is determining the third table (and fourth if there will be one) and the relationship between StudentMajor / Advisor / StudentNumber.
Should StudentMajor be included as functionally dependent on StudentNumber? If it is there would be redundancy due to multiple entries in that field for each row so I guess I can't include it actually. :confused:
Wouldn't there have to be another attribute named AdvisorDept for this to work properly....that way there is a relationship between Advisor and their department they work in so I can link the student's major to the advisor :confused:
Any pointers and suggestions would be greatly appreciated
I have upsized from Access 2003 to SQL Server 2008 R2 using upsizing wizard. Everything works fine. But I don't see relationship in SQL SErver 2008 R2 if I go to database. But I set relationship in Access 2003 before upsizing it.
Amso I don't see relationship (diagram) in Access 2003 , which I was able to see before.
So do I need to again recreate the relationship amongst the table in Access 2003 Or SQL SErver 2008 R2 ? I thought, if you link tables, everything should be taken care but i don't see relationship structure any more.