 |
The Access Unlimited
Magazine from |
vb |
123 |
.com |
|
If this email is in text format in the Junk folder, drag the
email to the Inbox and add the email address to your Safe Senders list. |
|
Greetings Microsoft
Access and Office Developers, |
|
After much testing,
building of index words and experimenting with different structures, the new
vb123.com |
|
KnowledgeBase site has
been born. Initially it showcases the Smart Access collections but overtime
it will house lots of |
|
articles from the
Smart Access collections and other writings of note. Find it here http://www.vb123.com/kb/ |
|
But more importantly
for you, the readers, I now have 100's of articles to showcase in this
newsletter from great writers |
|
such as Peter Vogel,
Doug Steele, Ken Getz, Mike Gunderloy, Danny Lesandrini, Russell Sinclair and
many more... |
|
Garry Robinson |
|
. |
|
Product Links |
|
_____________________________________________________________________________________________ |
|
Ÿ |
Data Modeling for
the Access Newcomer, Part 1 |
|
by |
Glenn Lloyd |
|
Thorough, thoughtful,
and accurate data modeling should be the starting point of detailed database
design. But a |
|
surprising number of developers have little or no understanding
of data modeling and shy away from what sounds like a |
|
non-profitable and time-consuming task. Glenn Lloyd looks at the
typical design pitfalls that trap Access beginners and |
|
shows the basic techniques that ensure success. |
|
Find out about data modelling basics here |
|
_____________________________________________________________________________________________ |
|
Ÿ |
User queries on the
fly |
|
by |
Russell Sinclair |
|
Rather than define
every query that your users might require, why not let your users make up
their queries as they need |
|
them. Russell Sinclair discusses how to create a simplified
query interface for Access users. |
|
You can find the article for this here http://www.vb123.com/kb/200511_rssimplifyingqueries.htm
|
|
or read more on our kb download system here… http://vb123.blogspot.com/2009/07/user-queries-on-fly.html |
|
_____________________________________________________________________________________________ |
|
Ÿ |
Highlighting search
matches in Access 2007 |
|
by |
Allen Browne |
|
Access MVP Allen
Browne has a neat little database sample that shows you how you can highlight
search terms at the |
|
same time that you are filtering records. This little beauty
requires you to have a copy of Access 2007. |
|
Find the link to the page at everythingaccess.com here |
|
http://vb123.blogspot.com/2009/07/highlighting-search-matches-in-access.html |
|
_____________________________________________________________________________________________ |
|
Ÿ |
Doug brings families
together using SQL |
|
by |
Doug Steele |
|
In this article,
Access MVP Doug Steele, aims to solve this dilemma and other family issues
with just a query or two. "How |
|
can you concatenate the names of the family head from one
record, the spouse's name from another record plus all of the |
|
children records and show them in a single line" |
|
Read it at our new Smart Access inspired website |
|
_____________________________________________________________________________________________ |
|
Ÿ |
Full Article and
Author Index for Smart Access Published |
|
by |
Garry Robinson |
|
A list of all the
articles in our new Smart Collections have been published in PDF format. Even
more interesting is the |
|
Author index. http://www.vb123.com/smart/ |
|
_____________________________________________________________________________________________ |
|
Ÿ |
Mini Links - Check
Out Our Twitter Site |
|
by |
Garry Robinson |
|
Our twitter site will
get a short message + links to our new (Smart Access) content as it is posted
so it might be worth |
|
signing up or using the RSS feed. What the twitter site won't
get is gossip. Http://twitter.com/smartaccess |
|
Finally for the first
time in 10 years, the phones and emails have gone quiet for a couple of
months so if you are in the position |
|
where you need some
consultancy advice or development skills, don’t be afraid to contact us using
details at www.gr-fx.com. |
|
Garry Robinson |
|
Manager GR-FX Pty
Limited |
|
02 9340 7789 in
Australia |
|
GR-FX Pty Limited |
|
Providing Access
database services for 14 years |
|
Product Descriptions |
|
Upsize to SQL Server
2005 or 2008, easily repeated conversions, highly accurate SQL query |
|
translation and web
form conversion using Andy's MUST Access tool. |
|
Find out who has your
database open, start the correct version of Access, easy compacting and |
|
backups, change
startup options, creation versions, shutdown database. |
|
In the editions that
we are selling now, there was 300 articles/2000 pages written by over 100 of |
|
best Access
professionals in the world under the guidance of editor Peter Vogel. Now you
can |
|
purchase those
magazines and accompanying downloads* and use them to improve your |
|
understanding of the
best rapid development tool in the world, Microsoft Access. |
|
Recieve a free Toolbox
when you purchase FMS tools like Total Access Analyzer, Total Visual Code |
|
Tools and Total Access
Emailer from us. |
|
If you need help with
a database, our Professionals could be the answer. |
|
Produced by Garry
Robinson from vb123.com and sent 21-Jul-2009 from Sydney, Australia |
|
This magazine was produced using the FMS
Total Access Emailer product. Click here for more. |