Please Can You Check Table Structure/concept
Nov 8, 2005
hi,
i need a db to monitor attendance (I know there are examples that do this but I need to satisfy my own curiosity and haven't seen one exactly like i need). My plan is to set-up the tables as below. I now have one-to-many relationships. There are many students. each student will study many courses.
I would like a form that shows the student info and a subform that shows all the courses they are on and weeks 1 -10. i could then use the yes/no attribute to record an abscence. later i would then need a query to see which students had missed two weeks in a row or more than 3 in total.
I think i need a form bound to tblStudents with a subform control that is displaying a form that is bound to tblStudentCourse. i am then a bit stuck as i need another form that will display the course records for each student. am i off track??? any ideas would be great. thanks.
tblStudent
StudentID (PK, number)
FirstName
LastName
tblCourseID (PK, number)
Week1 (yes/no)
Week2 (yes/no)
etc.
tblStudentCourse
StudentCourseID (PK, autonumber)
StudentID
CourseID
View Replies
ADVERTISEMENT
Jul 14, 2007
I am designing part of my database to simply the production of predictable quotations. (and have been for the last 6 months). My quotations tend to be for one product whose price varies based on the number of software licences. In each quote there will be the price for the software and the price for installation.
I will have a TblItems. In that table will be all of the items available for quotations and may include, for example, the following
Group (5 User system) Item, Description, Price, cost
In this group there will be two matching items
On my quote form i want to have a drop down field which will allow mw to simply select the number of users and then i want Access to take any item which belongs to the 'number of users selected' to another table and i will then include a quoteID etc etc.
Can anyone advise me on, the main thing, the kind of database concept on how to achieve this please? :confused:
View 7 Replies
View Related
Apr 12, 2013
I'm creating a timesheet/check in system (log in when the person starts work so it logs it and when they log out it logs that also for the manager or someone with high power to see.) for a fictitious scenario for an IT major project but I'm not sure where to start!
At the moment I have a few tables that are like this.
Table: Employees
Fields: EmployeeID, First Name, Last Name, DOB
Table: PayRates
Fields: RateID, EmployeeID, HourRate, TotalHours
Table:WorkTimes
Fields: EmployeeID, PayPeriod, WorkDate, StartTime, EndTime, TotalHours
I'm not entirely sure if this is all correctly structured, it just doesn't look/sound right to me.
View 1 Replies
View Related
Apr 30, 2014
I want to hit a button and then it scans for a file on a server and return with a message box saying if it exists or not.
I want it so when I am on a Specific record it will search for certain requirements.
All the file names are pdf files with the same naming structure
SIT yy m(m) dd Last Name Unique Identifier
Example:
SIT 14 5 21 Smith ABCD1234567
SIT 14 10 21 Smith ABCD1234567
So I hit the button it sweeps the file path and looks for documents with this naming structure.
Last Name and Unique Identifier are fields within the db.
Last Name = txtLName
Unique Identifier = txtUniqIden
So far I have the following:
Code:
Dim strDirName As String
Dim strDirPath As String
Dim strDirName As String
Dim strDirPath As String
[Code] ....
So Far it works and I used the actual name of the items an it finds them but I need to up each record.
I have no clue how to begin with the strDirName. How to get it to scan the file name in a specific format.
View 3 Replies
View Related
Apr 5, 2006
Hi there,
I'm still very new to Access....and learning it's strengths and weaknesses. A thought occurred to me today. Currently you have to build tables and set up relationships between them in order for 'searching' or 'querying' to work effectively.
Surely...it would make sense to develop a 3D database application..ie x,y,z axis in a table. That could eliminate the need for relationships between tables, as all of your data could potentially sit in one table (or at least reduce the number of tables required in a large database).
Does anyone know if this has been considered (I'm sure I'm not the first) or if there have been serious attempts at developing the concept into an application?
Cheers
Rob
View 14 Replies
View Related
Oct 27, 2006
Ok, Here is what I want to do....
I have 3 comboboxes and one button in a form. When I click on the button, it generates a querry based on the criterias selected in all the 3 comboboxes.
the generated querry gives an output something like this..
Indicateur | value1 | value2 | value3 |........... | value n
Now I want to display this selected criteria in a tabular format !!! I can use a subform, which I have used in many other forms as well, but my problem is that the querry generates different number of records everytime (as I have shown above, 'n' can have any value.) So I have to create textboxes dynamically in the form and do all sort of complex coading. I want to escape that and do something not too complex.
So I want Ideas on how do I do that? Maybe use pivot table? but I don't know how to use it and link to a table in my database??
Please, any help will be really appreciated!
View 8 Replies
View Related
Jan 2, 2008
I have been asked to create an RDB for my homeowners association that has 420 lots. That number, and the addresses, will never change. The purpose of the DB is to contain contact data between the homeowners to the association. I thought I would use 3 tables to do this:
tLots (lotID, name, address,etc.) PK=lotID
Relationship: 1 lotID to many caseIDs
tCase (caseID, lotID, type, date, status, detailID) PK=caseID
Relationship: 1 caseID to many detailIDs
tDetails (detailID, caseID, date, details, etc.) PK=detailID
I would also create pass-thru queries for these 3 tables on which to base my input form and my reports.
I have done a 2-level input form (i.e. the top half shows data from tLot and the bottom half shows a table with data from tCase, but I draw a blank how to show data from tDetails in the form. Can somebody point me in the right direction? Like maybe there is a sample of this already built somewhere that I could modify? I'm using Access 2000.
View 9 Replies
View Related
Jun 26, 2014
how can i make a image appear in my form when there is a check in the check box from the table?
View 14 Replies
View Related
Nov 23, 2007
Hi everyone,
I just want to have information about the concept of using an Access application with different users at the same time.
Thank you for help,
Nizar
View 2 Replies
View Related
Aug 27, 2012
Is there a way mimic the vlookup function of Excel in Access using SQL? What I am trying to do is create a table with planning values and based on the field title to grab a particular value in the two-column table.
View 1 Replies
View Related
Apr 20, 2015
I'm trying to copy the structure of a table to make a temp table. I'm using CopyObject (which also copies the data). So when I delete the data from the temp table, it also deletes data from the source table. Is the data linked? It should just be deleted from the temp table. Below is the beginning of the code. I've stepped through, and at the last step shown, the data in the source table deletes.
Code:
Dim strFile As String
Dim temp As String
Dim tbl As String
Dim db As DAO.Database
' error handle
On Error GoTo F_Error
[Code] .....
View 3 Replies
View Related
Oct 28, 2004
Here’s a little scenario:
An engineer requests that “x” amount of computers are ordered for the company. The estimated costs of the system(s) are determined. The estimated cost of the systems is forwarded to a manager, and the request must be approved by a manager before the order is placed. Once the manager approves the request, the order is placed through the ordering company. After the ordering company approves the order, an order number is assigned and serial number(s) specific to each computer is associated with that order number. At this point it is possible to track the order status via existing programs using the assigned order number and serial numbers. After it is determined through the existing software that the order has been shipped, invoiced, and received by the Receiving department, I need to physically go pick up the systems and submit them into my Central Inventory. From the central inventory, systems will be checked out to employees as needed, checked back in when testing is finished, or transferred internally between employees......
View 1 Replies
View Related
Nov 15, 2004
Hi everybody,
Please, I really need some help with my normalised tables and relations:
1.AdmissionID
AdminYr
.......
2.StudID
SName
AdminID
.........
3. ParentContactID
Fname
StudID
4. CycleNO
cycname
.....
5. DisciplineID
Discname
CycleNo
StudID
.......
6.SubjectID
subName
DiscID
....
7. ExamID
examdate
StudID
8. Results
StudID
ExamID
mark
......
I have a feeling this relationship, is still a bit messy?
I also need to keep track of students daily class attendance, at the end of the tern, or year to find out how many students dropt out of a particular class etc. Is this a new table?
thanks in advance.
haag
View 3 Replies
View Related
Dec 15, 2004
I have been reading up on normalizing table structures. I have this database that I am working on, to work as a hiring database. It should hold information about people applying to the law firm I work at.
I am looking for advice on if this table structure is normalized and sound. I am also looking for specific help on creating good forms.
Thanks for any help that can be given!
ps. I am attaching a zip that has a jpg view of the tables and their relationships, as well as the db with the table structure.
I would love any and all advice. I want a very clear concept for this db before I do anything!
Thanks again!
:D
View 2 Replies
View Related
Apr 27, 2005
I was having a discussion with a friend of mine about this... and I couldn't come up with the best explination. Hopefuly someone here can point me in the right direction.
He has a table
Recipies(Id, name, item1, quantity1, item2, quantity2, item3, quantity3, item4, quantity4)
I don't believe that this is the proper way to create a table. What happens if you happen to come across a Recipie that needs 6 items?? or more??
After researching it, I believe it violates 2NF. Is this correct?
Instead I think a better structure would be
Recipies(Id, name)
RecipiesIngredients(Recipies.ID, Ingredients.ID, quantity)
Ingredients (Id, Name)
The problem my friends sees with this method is the fact that the Xref table will get giant.
In the example... Speed is of utmost importance, as the tables will most likely contain thousands of records and be queried against frequently.
Thanks for any input.
-Mike
View 8 Replies
View Related
Aug 27, 2005
hello this is my 1st posting....... :o
please help me .........
I have 3 tables.....
Table : Customers
CustomerID
CustomerType (i.e. 1st Allottee, 2nd Allottee etc.)
Name
Address
C/o
...
Table: Apartments
File# (every apartment has unique file#)
Category
App#
Level
Area
Price
Discounted (yes/no)
DiscountRate %
...
Table: Receipts
Rec#
RecType (Down Payment, 1st Installment, 2nd Installment...)
Ref
Date
Chq#
Amount
...
one customer can have more than 1 apartments, and one apartment can be transfered to another customer (file# same but customerID changed)
one customer is paying different types of payments against his apartment.
please help me to manage tables and relationships.
View 3 Replies
View Related
Jan 29, 2006
I need some help trying to setup tables on a new database. I want to setup a house analysis database where I can evaluate each room for it’s condition broken down by feature. I can’t seem to figure out a good way to tie all the rooms and evaluations back to that house’s address (primary key). I want the fields to work as shown below with the room evaluations tracked to each room and house address. If possible I would like to be able to enter the as many room names as needed for each address.
House Address
Bedroom 1______________Bedroom 2_______________Bathroom 1
Ceiling condition –Good____Ceiling condition-Fair____Ceiling condition- Good
Floor condition – Fair______Floor condition – Fair____Floor condition - Fair
Wall condition – Good_____ Wall condition – Bad____Wall condition - Good
Can someone please explain to me how I should structure the tables to work. As a novice Access programmer I am out of ideas. Please help me!!
View 6 Replies
View Related
Jan 30, 2006
What's the best way to setup this db?
I have the following information:
Company
Company ID
Program A
Program B
Program C
Program D
2000
2001
2002
2003
2004
2005
The years indicate the year the Program participated in the company. For example, Program A participated in Company Z from 2000 to 2005, Program D participanted in Company Z from 2001 to 2002.
Should I have a table with the Companies and Program A and the years from 2000 to 2005
and a table for the Companies and Program B and the years, etc? I was going to add a yes/no field for each program, too. There must be a simplier way.
I want to be able to query participation of workers in any of the programs.
What is the best way to set this up?
Thanks.
View 2 Replies
View Related
Apr 14, 2006
I've got some tables, and I want to make sure I relate them in the best possible way.
Table1 has a one to many relationship with Table2
Table1 has a one to many relationship with Table3
Table2 has a many to many relationship with Table3
Would it be best to set them up this way or is there another way that would be better?
Fields for Table1
Table1_ID
.
.
Fields for Table2
Table2_ID
Table1_ID
.
.
Fields for Table3
Table3_ID
Table1_ID
.
.
View 3 Replies
View Related
May 14, 2007
Hi,
Thanks for taking time out reading my thread!
I want to start entering data, but i'm not to sure weather my relationship structure is good enough to start inputing.
Heres a pic of my relationships
http://img201.imageshack.us/my.php?image=almostdoneae0.jpg
Thanks.
View 1 Replies
View Related
Sep 4, 2007
i have been asked to design an access databse for a friend who is a bricklayer. He wants to use it to store all the work he does so he can produce his timesheet quicker.
He works on building sites and has to show a plot number next to all the work he does. He wants to be able to search for a plot number and see what jobs he has already booked in for a particular plot number.
For example, if he is working on a block of flats, each flat will have individual plot numbers. If he is working on the outer wall of the flat his timesheet has to show all plot numbers for that block so he will normally show this as plots 100-110. however, if he works on an internal wall in one of the flats he will have to show just one plot number on his time sheet, for instance plot 104.
my problem is that he wants to be able to search for plot 104 and have it list both jobs he has done even though one job is shown as plots 100-110. How can i structure the database tables to allow this to happen.
Any advice would be much appreciated.
View 1 Replies
View Related
Oct 10, 2007
hi everyone,i'm new to access and despite reading quite abit im just not grasping how to set up tables and relationships for what im wanting to do.I need a customer contacts table/form to keep track of my customers info (name, address, etc) & who's placing orders, easy enough.Now with some of my customers its always the same person who places the order but with others it can be anyone of up to about 15 different people who place the order each one can have their own direct phone no.So what im wanting to do is create a customer contact table/form and then linked to that who in that company placed the order with their phone no. Ideally i'd like it so once I have entered the info I can just use drop down menu's to select the company name then it opens up a list of all the people who I deal with in that company so I can just select the person/phone no who is placing the order.Can anyone help & advise me through best way of doing thisthanks alot
View 5 Replies
View Related
Nov 14, 2007
Hello, I want to fix a database I built and I needed some help on the table structure since its saving the data and not the ID number. I have it done and it works but its not correct since I dont understand normalization very well I took the easy way out and now its killing me and I want to fix it. Please take a look and give me some advise or show me a structure on what I need to do to normalize the DB... This would be my first DB so bare with me....
The comments section of each category will have a list of positive phrases and negative phrase equal to the subject like Safety, Quality, Quanity ect. "I didnt pur the phrases in each table yet"
Thanks!
View 2 Replies
View Related
Dec 9, 2007
Hi peeps,
I'm creating a simple db to stor project details. Each project has a unique name, and is part of a programme. Each programme name (ie SIG023) can have multiple projects. these projects recieve numerous support plans, guides and tto plans. I also want to store comments on each project.
Does my relationships and table structures look ok? am i starting in the right lines?
Has anyone come accross a similar db?
Appreciate any advice.
Mike
View 3 Replies
View Related
Jan 18, 2008
Good morning,since this is my first post I hope I'm not making to many mistakes.I'm making a database for school in Access 2003. In this database I have 2 parts.. A part for Patch connections and a part for PC repairs. The PC repair part is doing okay. The patch part is where I'm having some trouble.I don't exactly know how to start with it, and I'm hoping someone here can help me out.The form, I want to make based on tables should look something like this:A ComboBox filled from a table with about 10 entries in it. (Patchkasten)A textfield in which I have to enter something like this: XX-00 (x stands for alphabetic - 0 stands for nummeric)(Patchnummer) This will have around ~3000 entries.Those 2 should somehow be connected in a table as 1 field. (if that is possible offcourse)If not, is there another way to do something like this, because the combination of (patchkasten)and(patchnummer) has to be unique.. And at last a combobox (ruimte) with around ~ 150-200 entries.Now my question is if someone could help me setting this up somehow. Help would be appriciated.Thanks,F3dde
View 1 Replies
View Related
Dec 10, 2004
Hello
I have a big MS access database with many tables. Now I want to print out all this tables including there fieldname and the field description.
Does someone know how to do this in VB?
thanks
greetings
Koen
View 1 Replies
View Related
