Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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.


Reply With Quote
  #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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 09:16 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.