HEY CRYSTAL, EDGAR HERE AGAIN
I PLACED MY TABLES IN THE "2_AssistanceNeeded" area. i tried to follow all your
recomendations in the youtube videos. I tried to make all the relationships and
it seems right. Can you take a look at it and let me know? the file is
called "FIRE SERVICE PRO 2.0"
THANKS A LOT
________________________________
Edgar Rivera Vázquez
Propietario
Limay Inc. DBA Xtintores del SurEste
Carr #184, Km 3.1, Bo. Jagual, Sect. Villa Vazquez #3
P.O. Box 1228
Patillas, PR 00723
(787) 360-9549
www.extintorespr.com
________________________________
From: Crystal <strive4peace2008@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Sat, May 28, 2011 9:22:44 PM
Subject: Re: [MS_AccessPros] How to make a database for my business
you're welcome, Edgar ;) happy to help
be sure to read George's response about lookup fields ... while they can make
things convenient while you are getting started, it is not a good idea to keep
them in a non-web database.
there are a lot of links in Access Basics ... be sure to visit each when you
re-read (which you should do) the book ;)
Chris Downs, a writer for Microsoft, has some really good video tutorials on
2007 and 2010. I have a playlist on my YouTube channel with his 2010 videos --
and some apply to 2007. From there, you can go to his channel and do a search
for 2007
YouTube has lots of great stuff -- and it is an easy, relaxing way to learn
<smile>
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Sat, 5/28/11, xtintores wrote:
> 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
>
> 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]
Tidak ada komentar:
Posting Komentar