Record Source

  • Thread starter Thread starter Patience Singletary via AccessMonster.com
  • Start date Start date
P

Patience Singletary via AccessMonster.com

Greetings, I am in dyer need of some help.

I'm currently getting my certification in Microsoft Access2002
I went in to take the test, and missed a few questions. I can't seem to
figure them out.

I had a question on the test, that went something like this:

Create a query based on an existing table, Then change the record source of
that query.

Now creating the query was no problem, but I can't seem to locate the
record source anywhere within in the query. I can right click on the
asterisk in the table at the top of the query and I find something called
Source, but I don't think that is what I'm looking for.


If anyone knows what I'm talking about please clue me in.

---The lost girl in TX )=
 
Queries don't have a RecordSource.
Forms do.

The question probably should have been about creating a form based on a
table, and later changing the RecordSource of the form to a query.
 
Lost Girl,

I'm as lost as you. This is not standard terminology. Forms and
Reports have a Record Source. A Query does not have a Record Source.
The Record Source of a Form or Report can *be* a Query, in fact in the
case of a Report, it normally is. All I can really suggest is that
either there was a misprint on the test, or else somehow you
misunderstood the question.
 
"Queries don't have a RecordSource.
Forms do.

The question probably should have been about creating a form based on a
table, and later changing the RecordSource of the form to a query."

Hmm, I was afraid of that, I looked in every possible place for it on the
query and nothing.
In either case would you mind telling me where the record source is in a
form?

Thank you much for your time.
 
"I'm as lost as you. This is not standard terminology."

Tell me about it, half the questions on the test are like this one.

"Forms and Reports have a Record Source. A Query does not have a Record
Source.
The Record Source of a Form or Report can *be* a Query, in fact in the
case of a Report, it normally is. All I can really suggest is that
either there was a misprint on the test, or else somehow you
misunderstood the question."

Does a table have a record Source that can be a Query?
And where is the record Source in a report? If need be I will do them all
until I get it correct.

Thank you for your help..

--Lost girl in TX
 
Open a form in design view.

Open the Properties box (View menu).

Make sure the title bar of the Properties box reads Form (i.e. you must be
looking at the properties of the form, not those of a test box).

First property on the Data tab.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"Patience Singletary via AccessMonster.com"
 
Patience said:
Does a table have a record Source that can be a Query?
Click to expand...

No. A Table doesn't have a Record Source.
And where is the record Source in a report?
Click to expand...

Same as what Allen said regarding forms. It's a property of the report,
and can bee seen in the property sheet of the report itself.
 
Thank you both So very much!

Since ya'll have been so helpful you've both won another question! (=
(If your willing that is)

In a query write an expr. that will cumulate the average of blank field.
For instants you have a query and in fields one - three you have
EmployeeID, Employeename, and totalsales

On the test I went to the first blank field and first renamed the Expr1 to
Average sales: =Avg([totalsales])
But I still got the answer incorrect.. I was told this was something I
needed to do through the SQL, but which SQL do I use if I indeed have to do
it this way? union? data definition, or pass through?
and what is the argument I use? SELECT Avg([numbers_to_average]) AS Average
But what comes next? I still don't understand why the first attempt was
wrong.


--Not so lost girlie
 
Not so lost,

Is this supposed to mean the average sales for each employee? If so,
make the query a Totals query (in design view, select Totals from the
View menu), leave Group By in the EmployeeID and Employeename columns,
and put Avg in the totalsales column.
 
Thank you!

I think with this I should be able to pass this test with no problems.

Thanks for all your help.
 
Back
Top