The Access Expert - Header  
            
  Home
  MSAccess
  MSOffice
  FAQ
  CV
  About
  Contact
  Websites
  Rates
  Examples
     
     
     
   Ms M Macklin   
  "I need to be able to search a table for a particular string and then count the number of records that contain that text?"  
  Answer  
  Use a query SELECT Surname,FirstName WHERE Surname&FirstName like *Text*;. Then use a groupby query to count the number records in the first query.  
     
  The Access Expert - Parsley

MS Access

MS Access is a file based database application that comes standalone or with the Microsoft Office Suite of products

It was first introduced in 1992 and has gone through various different versions since.


Pre 97

 

The initial product was a cheap desktop database with a competitive feature set that enjoyed instant popularity amongst Windows users. Access 2.0 was a major update released in May 1994.

 

The first 32 bit Windows version was released as Access 95 in November 1995 with some problems which were not fully solved until the emergence of Access97.

 

Old versions of Access are no longer supported and should have been converted prior to Y2K. In the unlikely event that you are using an older version contact us.

Access 97
 

In January 1997 the improved 32 bit version Access 97 arrived as a productive development environment.

 

Access 97 assisted support ended last year. It is time to upgrade.

Access 2000

 

Access 2000 greatly improved the underlying JET database architecture for network and multi-user applications.

 

Access 2000 is still supported but it may be time to upgrade. Support lasts until 2006.

Access 2002

 

Access emerges as part of Windows XP. New features include PivotTable and PivotChart support and better Access Data Projects for SQL Server. However, the JET 4.0 engine and VBA have not changed since the 2000 release.

 

Support lasts until 2006.

Access 2003
Is my database too big?
How do you tell when a database gets too big. How many users can it realistically support? Is it time to upgrade to SQL Server?

See our FAQ to help with these questions.


 

     
 
Copyright © 2005 Gordon Green. All rights reserved.
Home | About | MSOffice | FAQ | CV | Rates | Rates | Examples | Contact