few quick access questions

M

microofficetester

true or false :)
question 1
when entered as a query condition, HANSON* has the same meaning as Like
"HANSON*"
question 2
You can modify table information by making changes to the Query datasheet
question 3
The equal to is the default comparison operator
question 4
unless you specify otherwise, the INSERT/DATABASE command will insert all
records from the selected database
question 5 It is not necessary to specify the size of the date feild
 
R

Rick Brandt

microofficetester said:
true or false :)
question 1
when entered as a query condition, HANSON* has the same meaning as Like
"HANSON*"
Click to expand...

Sometimes Access is helpful enough to throw "Like " in there even if you
don't type it. Otherwise I would say they are NOT the same.

question 2
You can modify table information by making changes to the Query datasheet
Click to expand...

Sometimes. If the query *allows* edits (many do not), then those edits are
actually applied to the tables as a query is nothing more than a different
view of table data. It has no data of its own.
question 3
The equal to is the default comparison operator
Yes

question 4
unless you specify otherwise, the INSERT/DATABASE command will insert all
records from the selected database
Click to expand...

I'm not familiar with that command.
question 5 It is not necessary to specify the size of the date feild
Click to expand...

Right.
 
T

Tom Wickerath

Rick,

You get 5 points for doing the homework that was obviously assigned to "microofficetester".


Tom
____________________________________

true or false :)
question 1
when entered as a query condition, HANSON* has the same meaning as Like
"HANSON*"
Click to expand...

Sometimes Access is helpful enough to throw "Like " in there even if you
don't type it. Otherwise I would say they are NOT the same.

question 2
You can modify table information by making changes to the Query datasheet
Click to expand...

Sometimes. If the query *allows* edits (many do not), then those edits are
actually applied to the tables as a query is nothing more than a different
view of table data. It has no data of its own.
question 3
The equal to is the default comparison operator
Yes

question 4
unless you specify otherwise, the INSERT/DATABASE command will insert all
records from the selected database
Click to expand...

I'm not familiar with that command.
question 5 It is not necessary to specify the size of the date feild
Click to expand...

Right.
 
R

Rick Brandt

Tom Wickerath said:
Rick,

You get 5 points for doing the homework that was obviously assigned to
Click to expand...
"microofficetester".

Yeah, that occurred to me right after I hit "send".

Too much coffee I guess (or too little) :)
 
O

OSMAN SURCHY

microofficetester said:
true or false :)
question 1
when entered as a query condition, HANSON* has the same meaning as Like
"HANSON*"
question 2
You can modify table information by making changes to the Query datasheet
question 3
The equal to is the default comparison operator
question 4
unless you specify otherwise, the INSERT/DATABASE command will insert all
records from the selected database
question 5 It is not necessary to specify the size of the date feild
Click to expand...
 
Top