Search results for query: normalization

I suggest the second link and, if you work through the tutorial, you will gain first hand experience in Normalization. Here is a reference to articles on Normalization by Roger Carlson. Here is link to a tutorial taking a business' description and breaking it down systematically into...

I suggest you post a copy of your database with instructions to highlight the issue. What is the rowsource of your combo? You would normally select a combo entry, you would not be typing a value into the combo.

I would think the Save and Load Data macros would be a developer( possibly Admin/DB) related activity. I'd probably have them in a module in the BE that could only be accessed using special account or form. Who would normally be logging in to the BE?? I can't envision a need to modify a Data...

"My database works fine. I have very many tables." I'm sure it does. But we have yet to see your tables and relationships. How about addressing post #9? And telling us about your Normalization?

Please tell us more about your tables and Normalization. Give us the 30,000 foot overview of what you are trying to achieve. Show us your table designs and relationships and tell us if there is something special about your PK and FK.

...name. Use a-zA-Z,0-9 and "_" in your names to reduce syntax\errors. Access/vba uses double quote chr34 " and single quote chr 39 '. Normalization is a basic tenet of relational database; should not be ignored The purpose of a PK is to ensure uniqueness of a record within a table, so the...

Seems to get most recent cost of an item you would need to divide cost by quantity ( TotCost/quantity = cost per unit) -10.67 /-3 =3.5566 42.67/12 =3.55583 and as plog said PurDate is not unique enough for your needs. Wouldn't you normally store unit cost, then Qty * unit Cost = totalCost...

...They either don't fit the business, or they don't use the database system as it was intended. You have been advised to review Normalization. Some have suggested you have data in field names. My concern is that you will be in constant work around mode if you don't act on plog's comments #37...

...you and the readers if you could tell us WHAT you are trying to do. As suspected and mentioned earlier in this thread, your concept of Normalization seems to vary with established concepts and principles. Re-Read Doc's post 27 - it is very constructive. Consider: If for some reason you...

...business terms? Showing us a table and some values without a business context isn't helpful to get a focused response. You may want to review some database concepts : Normalization, Relationships, Business Rules Please see this Hotel Bookings Reservation page (data model and rules) by Gina Whipp

Try CJ;s union query etc. Sounds good! When I received "data" from a third party that was not in a format conducive to processing, we ran that data through a intermediate process to reformat the data to normalized form. Then, ran the normalized data through the "intended process". If this is...

Interesting. Normally, as has been said, you do your selecting in a form, and then display the selected info as a result in a report. However, I just tested a report of my own where there is a control called Name on the report I added some code to create a click event on the name control...

Marshall, Here's a routine to Load Data macro(s) associated with 1 table from text. ' ---------------------------------------------------------------- ' Procedure Name: LoadADataMacro ' Purpose: Routine to Load a TableDataMacro from Text ' Procedure Kind: Sub ' Procedure Access: Public '...

On response to #72, Agreed. And we're not saying you have to normalize the database. or that you have to rename and rebuild/redesign the whole thing. The suggestions I made were some thongs to consider to make communications more efficient. Understand that we do not have the database, nor the...

@David, You are asking a question in a database forum and you self-identify as not certain of normalization nor its significance. Can you describe in simple English what is the "business process(es)" that your evolving database is intended to support? What exactly is the issue your database...

You should research Normalization and adjust your table structure to support your needs. Often better to describe the business process involved in simple, plain English to readers so they can offer more focused responses. Also, many will build a model with tables and relationships (relationship...

Could you please tell us more about your application and tables? 1 to 1 relationships are not all that common.

I realize that this thread started in 2004 and as been added to ever since. For the basics of database structure (normalization) that has been referenced, I am going to suggest this tutorial from RogersAccessLibrary. It leads you through a process to work from business requirements to a...

Suggests, there could be guests/occupants of a hotel room(s). Occupancy could be for 1 or many Days. So you may be looking at tables for: Guest/Customer Room RoomType Occupancy/Booking The facility has 1 or many Rooms At any time 1 or more rooms may be occupied At any time 1 or more rooms...

...dates within each stage for each part. That would seem to provide info for detail date/duration statistics. You may wish to review normalization in order to get your tables and relationships set up and tested. Getting your tables and relationships designed to support your requirement is a...