Re: [MS_AccessPros] How to make a database for my business

Thanks a lot Crystal, thaks for all your info, I'll look in to it. Oh and my name is Edgar
Sent from my BlackBerry® smartphone

-----Original Message-----
From: Crystal <strive4peace2008@yahoo.com>
Sender: MS_Access_Professionals@yahoogroups.com
Date: Sat, 28 May 2011 17:52:54
To: <MS_Access_Professionals@yahoogroups.com>
Reply-To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] How to make a database for my business

Hi the_extinguisher_pro (what is your name?)

Welcome ;)

~~~
to add another field to a table:

1. right-click on the table name in the database window or navigation pane
2. choose "Design" from the shortcut menu
3. choose:
- field name
- data type
- description
- size
- default value
etc

For lessons on planning a database, watch these free video tutorials:

Learn Access on YouTube
http://www.YouTube.com/LearnAccessByCrystal

~~~
> "When I run the query i get the pop-up asking me to enter the City, when I do, the query runs but I get no data, its compleetly blank. What am I doing wrong?"

either you are not typing the name correctly, with any leading or trailing spaces
or
what is being stored is a foreign key to the record in tblCities and the text is only displayed
or ...

to fix it, you need to learn more about Access. In addition to watching the 4 10-minute LearnAccess videos, read this:

Access Basics by Crystal (Bill Mosca's site)
http://thatlldoit.com
Free 100-page book that covers essentials in Access

and pay careful attention to the chapters on Normalization and Relationships.


Warm Regards,
Crystal

*
(: have an awesome day :)
*


--- On Sat, 5/28/11, the_extinguisher_pro wrote:


> I have Access 2007 and i'm fairly new
> at it.  I have a business of fire extinguisher service.
> The service is usualy done once a year.  i already have
> all my table made in access, but encountered a problem... I
> have a "tblClients" with a related "tblInventory" which has
> all info about each extinguisher the customer has. 
> Then there is a "tblService" related to "tblInventory" to
> keep track of each service done to each extinguisher. 
> That table "tblService" has a field for the "Now() Date"
> representing the date the service was done, another field
> for the type of service that was made and a third field for
> the interval for the next service (monthly, every 6 months,
> or annualy)... and I need to add another field to indicate
> the date of the next service based on the las service date
> and the interval.  Who do I make this happen?
>
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/