Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old October 17th, 2003, 07:00 PM
Registered User
 
Join Date: Oct 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Newbie question

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
I am sorry it is such a newbie question. I want to do a course in Microsoft office but it requires you know the basics. I am ok with word, excel, outlook and power point but I have never used access. I have been reading online tutorials and I have found a few sample exercises on the net. I am getting to grips with it all but 3 questions are puzzling me in the exercises I have found.

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? Or can you have a heading in the same way you would in an excel table so it would show up in any print outs?

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

3) Save and exit your database with your data secure.

How do I make the data secure? I have noticed when I save the files it has a padlock on it. Does this mean it is secure?

Many thanks for your help.


  #2 (permalink)  
Old October 18th, 2003, 05:53 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If this is for school, make sure the instructor is more specific.
For the validation rule use

IN("O","G","S")

Of course, this could return

o or g of s
instead of
O or G or S

Or you can do this, Create the field with the lookup wizard and add the letters to it

"Make sure it is secure. Does he mean secure as security enforced by windows or saved?

Which padlock are you refering to?

Main Heading - May be refering to the text that appear on top of the Screen, righ now it Says Microsoft Acceess 2000 or 2002.

Go to Tools, Start Up

in the Applicatin Title enter
  House Lettings
Click OK
Close the Startup box and The text should display on top Left



Sal


Similar Threads
Thread Thread Starter Forum Replies Last Post
newbie question pbb Ajax 0 September 26th, 2006 05:47 AM
Newbie question savoym JSP Basics 1 August 16th, 2006 03:15 AM
Newbie Question - Sorry! KP Crystal Reports 1 June 13th, 2006 02:45 AM
C# Newbie Question jazzcatone ASP.NET 2.0 Basics 1 May 25th, 2006 10:18 PM
newbie question Warbird XML 0 May 11th, 2005 08:41 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.