Newbie question

[maccer99]

I am just starting to learn Access and been given a few exercises to try and do. I have 2 questions that are puzzling me

1) open access and enter the main heading House lettings. Does this mean after I have designed the database using design view that when I save it I should give the table name House lettings?

2)When designing the database for the heating you must use the following criteria text, field size 1, Validation Rule O or G or S, validation text O or G or S,
O = Oil
G = Gas
S= Solid Fuel

I understand how to do the text and field size. Am I right in saying for the validation rule I should have "O" Or "G" Or "S" and for the validation text I should have O or G or S

 

[namliam]

Welcome to the site...

I would say, ask the teacher!

 

[databasedonr]

1) You can use House Lettings if you like for your table name. I try to avoid putting spaces in my table names, because I am lazy and it makes it easier when you write queries and reports. Use a noun that describes the data that goes in the table. For example, a table that has employee information in it would be named "Employee".

2) The Validation rule is right, but the text is the message that comes up when the rule is broken. So in this case, you might want to say "Use O, G, or S as appropriate to select the the heating fuel type."

Good luck. Access is a lot of fun.

 

[maccer99]

Many thanks

Thank you

 

[namliam]

1) just to add a little thing... in naming stuff its wise to use prefixes as well. So a table containing employees would NOT be Employee but tblEmployee. That way you can have basic queries, forms, reports names the same...
qryEmployee (some prefer queEmployee)
frmEmployee
mcrEmployee
rptEmployee
mdlEmployee

DONT use spaces and/or special characters such as /?><.,|}{[]\)(*&^%$#@!~` etc in names either its "bad practice" as well as it makes live a lot harder for you.
Futhermore, allthough access will allow you the use of them. Other DB's/systems will not. Thus compatibility and such come around the corner....

Regards

The Mailman

 

[maccer99]

thanks

Many thanks

 

[joe31709]

I just a problem with that also,

Thank you Also

Joe