Data Or Information?

Nov 13, 2007

Hi everyone,

I’m trying to understand building databases correctly; therefore, I am going back over Running Microsoft Access 2000 book.

I’m having some trouble understanding a section in the book on Building a Database, page 86.

“Data or information?

You need to know the difference between data and information before you proceed any further. This bit of knowledge makes it easier to determine what you need to store in your database.

The difference between data and information is that data is the set of static values you store in the tables of the database, while information is data that is retrieved and organized in a way that is meaningful to the person viewing it. You store data and you retrieve information. The distinction is important because of the way that you construct a database application. You first determine the tasks that are necessary (what information you need to be able to retrieve), and then you determine what must be stored in the database to support those tasks (what data you need in order to construct and supply the information).

Whenever you refer to or work with the structure of your database or the items stored in the tables, queries, macros, or code, you’re dealing with data. Likewise, whenever you refer to or work with query records, filters, forms, or reports, you’re dealing with information. The process of designing a database and its application becomes clearer once you understand this distinction....”

To me “data” is synonymous to information, facts, figures, numbers and so on. I guess this is why I am having a hard time understanding the above paragraphs.

Can anyone explain it in a way that a dummy can understand it?

Thanks!

View Replies


ADVERTISEMENT

Track Changes Of Raw Table Data Information?

Dec 19, 2012

Im working in MS Access 2003.Im creating an audit trail for users actions in a form, to monitor and keep track of what fields were updated/entered/removed from the database, these actions are essentially done from command buttons (and the audit trail, is coded on the button click)

However, I have a few search screens, that return a subform listing results. These datasheets returned are effectivly like opening the raw table and hence are editable, (permission to change is granted as they are admin only searches, yes, they can change the raw table)

How can I track the change to a raw table field, ie, if someone updates the field SURNAME from 'Smth' to 'Smith', is there something that triggers this (obviously if it was in an interface textbox, you could audit this) is their a field change. The only way i can suggest it make a recordset of the intial results, then compare that to the results in the table as they leve and compare the two.

View 7 Replies View Related

Forms :: Unable To Display Information Based On Data In Another Box

Nov 15, 2013

I am trying to get a form to display certain information based on the data in another box. I have to input some exam results and want to assign a level to them. So, if they score < 13, the result would read "Below Entry 3" if between 13 and 21 "Entry 3" etc If this was a spreadsheet I would use an if function, but I am not sure that I can do this here

View 14 Replies View Related

Form For Data Entry - Information For A Box Content Label

Apr 15, 2015

I am creating a database to house all the information for a box content label. For any given product it could have multiple items that go on the label.

For example:

My_Part_1

1. Part_1
2. Electrical Assembly
3. Instructions
4. Warning Label

I imagine my database being setup as follows:

ID Model# Contents
1 Part_1 Part _1
2 Part_1 Electrical Assembly
3 Part_1 Instructions
4 Part_1 Warning Label
5 Part_2 Part_2
6 Part_2 Electrical Housing
7 Part_2 Housing instructions
8 Part_3 Part_3
9 Part_3 Instructions

I would like to setup my form so that I could type in the Model # once and then type in each item that would go in the box. I don't mind typing in each item individually and then pressing an "add" button. But I would like it to show everything that is currently on that box content label and be able to delete items out of the label.

Is this possible? What would be the best way to do this?

View 1 Replies View Related

I Need To Update Data In A Table With Information From A Calculated Field In A Form

Oct 12, 2006

I've read over and over that calculated data is bad, that's fine with me... but here is my dillema...

I have four fields that interact with my calculation in a single form. There is only one table in the database.

AmountF (The stored data in the table) (amount financed)
FC (calculated by =[amountf]*.25) (finance charge)
Amount Paid (used in calculation of total due)
total due (calculated by =[amountf]+[fc]-[amount paid])

The math already works, everything works. I can choose to print the form and it looks great. However, I would like for it to (when I'm done printing the form) somehow save the total due data to the AmountF column in the table. AmountF is in the same line as all the other information, so I would like it to not create a new record just update the old one.

All four of these fields have a text box in the form for themselves.

View 4 Replies View Related

Forms :: How Data Is Passed Using Foreign Keys - Cannot Display Proper Information

Jan 25, 2015

I'm trying to understand how data is passed using foreign keys.

I'm using Allen Browne's 'Don't use Yes/No fields to store preferences' at: [URL] ....

I've also downloaded his sample DB, RelationBasics, to use as a guide.

Attached is my version of the Student / Sport DB as described on the webpage.

I use 2010 at home (saved as 2003 version) and 2003 at work (JPNSE OS). Both result in the same thing.

The problem I'm having is I cannot get the actual sports to display in the combo-box, only the Sport_ID number.

I've tried building both forms with and without actual data in the TBL_Student & TBL_Sports tables, but no mater what the result is the same.

View 2 Replies View Related

Auto-populate Data Into Field Based On Information Typed Into First Record

Sep 3, 2014

I'm trying to figure out a way to get my access database to auto-populate data into a field based on the information I type into the first record.

So what I'm looking to do is that when I type a name into the UserName Field it will automatically fill in the rest of the field with the same information.

To clarify I'm looking for a way so that when I type something into one record it will fill the rest of the field in with that same information.

View 8 Replies View Related

Too Much Information

Jan 4, 2006

I wonder if anyone has a quick fix for me. I have two tables in a project management DB that I am making. The first table is a projects table and the second is a tasks table. I would like to have a list box in the projects table containing all the tasks completed for the specific project. However, the current list box is showing all tasks rather than the ones specific to the project ID. The project ID is the primary key in the projects table and the foreign key in the tasks table. I am not sure if/how setting up a filter would correct this or if I just need to adjust the relationships. An example of the DB is avaiable if helpful.
Any advice or ideas would be greatly appreciated.

View 1 Replies View Related

Getting All DB Information

Jul 12, 2006

I have a client who wants his Accs db converted to MySQL. I have no problem understanding MySQL. However, my knowledge is limited with Accs.

This db is quite large (53mb) and has several tables, queries, reports, forms, modules, etc. I suppose he tried to create a backup and sent it to me. The problem is that all I have are the tables...nothing else.

Did he do something wrong or is that standard w/ Accs? Is there anyway I could have all of the information saved to some type of txt or .doc file and send that to me? I understand that would make it larger. The problem is right now Im on his computer (networking) and it's running too slow. I'm having to make screenshots and what-not (and that's when his secretary ISN'T WORKING...so pretty much at night). Really need some suggestions with this.

Thanx,

Tim

View 2 Replies View Related

Getting Information Out Of A ListBox

Jun 14, 2005

I am brand new to Access(I started yesterday). I have a ListBox that gets its selections from a Query. I set it for MultiSelect, and now I have to figure out how to store the selections. The list is organized in accending order, which does not match the table that the Query is based on. I have no experience with VBA. The form name is Trouble_Ticket and the ListBox name is List24.

Thank you

View 1 Replies View Related

Shortening A Row Of Information.

Jul 4, 2006

I have got a set of information that has a mixed bag of names. Some have only a first name but some have a middle name also.

I am looking to shortern the information just to the firstname (i.e. in stead of the results showing "Bill William" as the firstname, i want to just show "Bill").

i tried using the Left function but because the strings are of varied length i need the cut off to be the space between the various names.

Any help would be much appreciated.

View 4 Replies View Related

Information Boxes

Dec 27, 2006

I seem to remember - way back in my access class that I have not used regularly, therefore have forgotten much - that there is a way to put a description of the query or form or table that pops up in a kind of box when the cursor is placed over the name. I hope that makes sense - if not, read on.

I have a lot of queries and would want anyone using them to know what they will do before they click on one - because it might mess things up.

Thanks in advance,
Peg

View 7 Replies View Related

Linking Information

Feb 8, 2007

I am having a hard time linking some certain information. I think I have my relationships formatted correctly but not all the information is connecting.

For example: I have a form where I am creating a sales quote. In the form I have a combo box where I select my product ID. When I select the product ID, the product name automatically populates but the price does not.

I have attached a screenshot of my relationships. Can someone please look it over and see if anything stands out to you as being incorrectly formatted? Or offer any advise in getting my price to connect to the product ID I enter?

View 14 Replies View Related

Loosing Information

Mar 14, 2007

Hi there..

We have Access 2000 database. Everythign is working fine but suddenly it have started loosing information. I entered one record last week and its not showing up now.
I am not a remote user. I entered the data from local machine.
Do someone have any idea about this issue.

Thanks
Danny

View 5 Replies View Related

Repeat Information

May 25, 2007

I am implementing a quoting system at work. Many times, a customer wants the same job that he asked for last year or 2 years ago, so basically it's the same information. So when the customer calls, I look for his last quote, and then would add a button that would create a new quote (record) but with the same information. It would be a burden to enter all the same information each time the customer calls for the same job over and over again.

Thank you

View 4 Replies View Related

Tip: Personal Information

Oct 10, 2007

Did you know that when you create an MS Access database, personal information such as your user name and the name of the person or company that the software is registered to is saved and displayed with the database file for others to see. Prying eyes simply goto 'File->Database Properties->Summary Tab' to see your personal information.

The fix is simple goto:'Tools->Options->General' and select the 'Remove PersonalInformation from file properties on save' check box. Next time you save, no more personal information.

Don't believe it? Look at some of the sample databases posted here - :eek:

:)
ken

View 1 Replies View Related

Information Needed Please

Nov 26, 2007

Hi to everyone Could anyone please tell me if there is a developer for access so I can get them to finish my database.

A friend started a data base for me but he had a motorcycle acident and the worst happed I have tryed to finish it myself but I'm not very clued up.

I would like to get a quote to finish I have just gone self employed and need this to produce surveys for Asbestos.

Im sorry if i'm not aloud to post this here if not please remove.

I live in soton uk I can put the database up on my server for people to download.

Thanks again


Please can anyone help here

View 3 Replies View Related

Dependant Information

Apr 14, 2006

How Do You Do Dependant Fields?

Example being:

I have a list of Stores of which there are 4 Formats (Super, Extra, Metro, Express). Each of these formats have their own specific grades.

What i want to do is when entering a new store via a form, In the Format box i would choose one of the formats from a combo box then when i progress to the Grade Entry, i would only want to see the Grades for that particular Store Format.

Would i need to have different lookup tables for each of the format grades & how do i achieve the above?

Ive seen this done on Airline web sites, ie select outgoing airport then the destinations change to only those that can be reached by flights from the Outgoing airport.

View 3 Replies View Related

Incorrect Information

Sep 9, 2005

I have set up 2 queries which are working correctly. The problem is when I try to combine them it brings back incorrect information. The 2 queries that work correctly are set up like this

Query1:
SELECT Projects.[Work Stream], Count(Poles.[New Pole No]) AS [CountOfNew Pole No], Sum(Projects.[Line Length]) AS [SumOfLine Length], Projects.Team
FROM Projects INNER JOIN Poles ON Projects.[Scheme No] = Poles.[Scheme No]
GROUP BY Projects.[Work Stream], Projects.Team
HAVING (((Projects.Team)=[EnterTeam]));

Query2:
SELECT Projects.[Work Stream], Sum([Material Cost]+[Labour Cost]) AS [Total Cost]
FROM Rates INNER JOIN (Projects INNER JOIN [Pole Work Instructions] ON Projects.[Scheme No] = [Pole Work Instructions].[Scheme No]) ON Rates.[Rate No] = [Pole Work Instructions].[Rate No]
GROUP BY Projects.[Work Stream];

Do you have any idea how I can combine these to get accurate results?

View 3 Replies View Related

How Do I Group The Information

Aug 13, 2007

Hi all I have this SQL SELECT [TripDate]+[NDays]-1 AS [DutyPayment], Count(tblTrip.NDays) AS ConteggioDiNDays, Sum(tblTrip.FlyingTime) AS SommaDiFlyingTime, Sum(tblTrip.TAFB) AS SommaDiTAFB, tblTrip.DutyPayRate, Sum([TAFB]*[DutyPayRate]) AS [Duty Pay]
FROM tblTrip
GROUP BY [TripDate]+[NDays]-1, tblTrip.DutyPayRate;I need now to group the information by total x month of "DutyPayment" with the following format "yyyy mm"
Example 2007 05, 2007 06, 2007 07
Thanks

View 1 Replies View Related

Combining Information

Feb 4, 2005

I am currently working on a project for our training dept to link staff members to particular peices of equipment. I have created two tables - tblEquipment and tblStaff_Table. I have also created a form based on a query that gets the staff details based on the surname. Within the staff form I have a subform that allows equipment to be linked to staff members. What I am trying to do is when a specific piece of equipment is selected, only those additional bits of data related to the piece of equipment, such as manufaturer or model no. are shown - sort of like an autofilter in Excel.

I have been banging my head against a brick wall with this one. I'm sure that Access can do this but I can't work out how.

Can anybody help?

David :(

View 2 Replies View Related

Information Within A Table

Apr 14, 2005

i am trying to create a form with a sub-form in it. i have got my client details in it - address, phone, etc then within that table i would like to keep a track of treatments for each time they visit in decending order. can anyone help me out with this? hope someone understands what i mean

View 3 Replies View Related

Displaying Information

Jun 6, 2005

Hi,

First of all thanks to everyone who has answered my questions already, although I'm still having problems (more with my understanding and lack of Knowledge)

I'm creating a DB and I'm stuck, I'm trying to create a form that has three fields mailbox, applications & Drives. Each of these three fields need to be populated with many items. For example the mailbox field may have 5 different mailboxes required to be populated in this field.

What I want to happen is for the user to double click on the text box, then a new form containing a multi-select list box appears that you can select the items you need which in turn updates the role profile form. This is how I want it to work but if you have a better idea I'm all ears.

All I want is for someone to be able to view the role profile form and to be able to see what applications, drives and mailboxes are required for that role.

Basically I have no idea how you can get someone to choose several items and have that reflected and recorded in the required record.

I have attached what I have at the moment and any help or advice you can supply is appreciated.

View 2 Replies View Related

Get Information Button

Jun 13, 2005

I have classes and seasons. SeasonID for each class is listed in the class table with every other class information.
I have a form with the classes as a subform to the seasons. When pressing forward making a new season it would take a while to input all the class information in the new season. Further more many of the classes requires no change.
The first class information to be inserted is a specific class number. When that is done it could be nice to have a button besides, that when pressed, gets all the rest of information from the same class a season before, so that text- and dropdownboxes will be filled out automatically. And if nothing to be changed then just going to the next.

Hope somebody knows a little trick.
I am a newbie to access, so I properbly need help spelled out.

View 5 Replies View Related

Transfering Information

Nov 3, 2006

I have three list boxes. Two of them has data from a database in them. I want to chose one piece of data from one index, and choose two pieces of data from the other list, and click a button to send it to another list(database, that would later be exported to excel). Does anyone know how I would go about doing this?

View 1 Replies View Related

Connection Information

Jan 4, 2008

Public (or Global )Function inc_connection ()
Dim db As Database
Dim ws As Workspace
Set ws = DBEngine.Workspaces(0)
Set db = ws.OpenDatabase("C:folder1customers.mdb", False, False)

End function

Then in the form a

Private Sub

Dim sql as string

Call inc_connetion
the first 2 lines are ok but when it gets to the set information, it then comes up with error object required

Dim sql as string
Sql = select * from customers
Etc
End sub

Hope that all makes sense

Casey

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved