microsoft+access+course+london - query
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+course+london - Query

microsoft+access+course+london - Query

resolvedResolved · Low Priority · Version Standard

replyReply Wed 7 Feb 2007, 10:09Delegate Vicky said...

Vicky has attended:
Access Introduction course

Query

What is a query? Is it Access-specific terminology?

For upcoming training course dates see: Pricing & availability

replyReply Wed 7 Feb 2007, 10:54Trainer Garry said...

RE: Query

a Query is a question which you ask your database
Microsoft Access supports many types of queries. Here is a description of the major categories:

Select Queries
Retrieve records or summaries (totals) across records. Also includes cross-tabulations.
Make Table Queries
Similar to Select queries but results are placed in a new table.
Append Queries
Similar to Select queries but results are added to an existing table.
Update Queries
Modify data in the records.
Delete Queries
Records are deleted from a table.

it is not Access-specific terminology

 

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard