few quick access questions

[Guest]

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

 

[Rick Brandt]

true or false
question 1
when entered as a query condition, HANSON* has the same meaning as Like
"HANSON*"

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

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

I'm not familiar with that command.

question 5 It is not necessary to specify the size of the date feild

Right.

 

[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*"

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

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

I'm not familiar with that command.

question 5 It is not necessary to specify the size of the date feild

Right.

 

[Rick Brandt]

Rick,

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

"microofficetester".

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

Too much coffee I guess (or too little)

 

[OSMAN SURCHY]

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