Re: Relationship advice

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Keep your pants on stevie, you have caused more problems than you are worth and you are surprised some of the regulars ignore you?

You have a rather mixed opinion of Tony. One hand you insult him and on the other you point people to his website as a great resource.

As to your question, my preferred answer is table. Though I would never refer to a table in the singular, so my table would be "Customers". Why, I have done DB work since the sixties, yes stevie, there were databases back then, and always found the type tagging to be superfluous. Tables should be objects and queries should have an action or qualifier to them. Referring to a query as "Customers" brings up question "Which customers?". So the query name should have a qualify.

John...

John...
"Steve" <nonsense@xxxxxxxxxxxx> wrote in message news:Y5mdnYIfgqmABAHVnZ2dnUVZ_jqdnZ2d@xxxxxxxxxxxxxxxx
I guess the great "MVP" is only good at disagreeing but can not answer a simple question!!!!!

Steve


"Steve" <nonsense@xxxxxxxxxxxx> wrote in message news:IaudnSZeYttIvAbVnZ2dnUVZ_uydnZ2d@xxxxxxxxxxxxxxxx
A simple question for your vast expertise and MVP credentials .........

Suppose in an application's code you see reference to an object named "Customer". Is that object a Table or a Query?

Steve


"Tony Toews [MVP]" <ttoews@xxxxxxxxxxxxxxx> wrote in message news:m8fl949rnc1a5va1f2sor2rhfhmm05bmgf@xxxxxxxxxx
"Steve" <nonsense@xxxxxxxxxxxx> wrote:

First off, I suggest starting the name of all your tables with "Tbl".

I disagree. I've never seen any use in using an object prefix such
as tbl, qry, frm, rpt, etc. Indeed, in a database with a large
number of objects this can really slow you down.

Tony's Object Naming Conventions
http://www.granite.ab.ca/access/tonysobjectnamingconventions.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/






.

Relevant Pages

  • Re: Re: Need some input on an Event Procedure for a search
    ... could try it with just needed a slight alteration to the SQL query. ... specific Features which some Customers would be looking for. ... The Customers table includes contact details, ... and the specific command for a mailout which is the event ...
    (microsoft.public.access.gettingstarted)
  • Re: Sum of numbers
    ... "Evi" wrote: ... You say the union query 'only shows fields from the first table'. ... Do you mean that you want a multicolumn report with all customers' names ...
    (microsoft.public.access.reports)
  • RE: Store Added Value List Items
    ... You could even union that query with the actual list from the form ... Each user in this database needs to have access to all the same customers. ... is praticle to create a seperate one field table to store values for a lookup ...
    (microsoft.public.access.formscoding)
  • Re: I need a customer sales listing that includes no-sales months.
    ... > query of sales per month per customer, but I need the non-sales months ... > All my data is in one query called QryINVOICE. ... This sounds like a perfect candidate for a crosstab ... FROM (Customers INNER JOIN Orders ...
    (microsoft.public.access.queries)
  • RE: Report prints data twice on two different pages
    ... I'm not sure I fully understand what a "totals query" is nor do I totally ... Thanks again Duane! ... FROM Customers AS C INNER JOIN Appointments As A ON C.customer_id = ... My main report is based on a query that is based on the main table only. ...
    (microsoft.public.access.reports)