[vicsireland] Re: Microsoft Access
- From: "Sabrina McKiernan" <sabmckiernan@xxxxxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Fri, 4 May 2007 13:14:14 +0100
Hi,
yes these buttons mentioned below are the ones I was trying to remember. Not
bad recalling after four years!
Cheers,
Sabrina
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx]On Behalf Of Tony Murray
Sent: 03 May 2007 14:16
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: Microsoft Access
Hi Joan Ann,
The easiest and most straight forward way of doing this is through the
Microsoft Access query building interface. Saves you learning a programming
language to achieve what you want.
On the screen where the dropdown containing all the possible fields to
include is visible (so to speak), I assume you are hitting enter on each one
you wish to add to your query.
Well, tab out of this dropdown, until you find a button simply called >>.
Tap spacebar on that button, and all your fields will be added to the query.
Note: There is a button, which you will probably reach before the >> button,
called >. This single greater than sign is an alternative to hitting return
on each individual field in the dropdown... So, if you have a field in the
dropdown highlighted, and you tap the > button, that single field will be
added.
Anyhoo, ignore that one, find the double greater than sign, activate it, hit
Next, and you're done.
For what it's worth, I'll try and unravel some of the stuff discussed in
this thread up until now.
The "SELECT *" statements referred to earlier are parts of SQL Syntax. SQL
(Structured Query Language) is the computer code that is running in the
background, behind your query building screen. SQL is a way to manipulate
databases and the data contained within, if there is no nice user interface
to play with. "SELECT * FROM MyTable" basically means, Show me all the data
that is in the table called MyTable. By executing this code, you are
running what is called a query.
You can do this with MS Access by activating the built-in SQL editor.. but
for your purposes, I'd just ignore that and take the easy rout as described
at the top of my message (before I started rambling). Microsoft have made
it easy to build queries in Access, without having to necessarily learn
anything major, like SQL.
The best of luck,
Tony
----- Original Message -----
From: "Cearbhall O Meadhra" <cearbhall.omeadhra@xxxxxx>
To: <vicsireland@xxxxxxxxxxxxx>
Sent: Thursday, May 03, 2007 7:55 AM
Subject: [vicsireland] Re: Microsoft Access
Dear Joan Ann,
To answer you more fully I would need to know what you are trying to do with
the query.
In the meantime, here is what Microsoft Access says about the select
statement. Further down you will see the instruction for using the asterisk
with the select statement.
Microsoft Office Online: Help and How-to: SELECT Statement
SELECT Statement
Instructs the
Microsoft Jet database engine
to return information from the database as a set of records.
Syntax
SELECT [predicate] { * | table.* | [table.]field1 [AS alias1] [,
[table.]field2 [AS alias2] [, ...]]}
FROM tableexpression [, ...] [IN externaldatabase]
[WHERE... ]
[GROUP BY... ]
[HAVING... ]
[ORDER BY... ]
[WITH OWNERACCESS OPTION]
The SELECT statement has these parts:
table with 2 columns and 8 rows
Part
Description
predicate
One of the following predicates: ALL, DISTINCT, DISTINCTROW, or TOP. You use
the predicate to restrict the number of records returned. If none is
specified,
the default is ALL.
*
Specifies that all fields from the specified table or tables are selected.
table
The name of the table containing the fields from which records are
selected.
field1, field2
The names of the fields containing the data you want to retrieve. If you
include more than one field, they are retrieved in the order listed.
alias1, alias2
The names to use as column headers instead of the original column names in
table.
tableexpression
The name of the table or tables containing the data you want to retrieve.
externaldatabase
The name of the database containing the tables in tableexpression if they
are not in the current database.
table end
Remarks
To perform this operation, the Microsoft® Jet database engine searches the
specified table or tables, extracts the chosen columns, selects rows that
meet
the criterion, and sorts or groups the resulting rows into the order
specified.
SELECT statements do not change data in the database.
SELECT is usually the first word in an
SQL statement
. Most SQL statements are either SELECT or SELECT...INTO statements.
The minimum syntax for a SELECT statement is:
SELECT fields FROM table
You can use an
asterisk
(*) to select all fields in a table. The following example selects all of
the fields in the Employees table:
SELECT * FROM Employees;
If a field name is included in more than one table in the FROM clause,
precede it with the table name and the . (dot) operator. In the following
example,
the Department field is in both the Employees table and the Supervisors
table. The SQL statement selects departments from the Employees table and
supervisor
names from the Supervisors table:
SELECT Employees.Department, Supervisors.SupvName
FROM Employees INNER JOIN Supervisors
WHERE Employees.Department = Supervisors.Department;
When a Recordset object is created, the Microsoft Jet database engine uses
the table's field name as the Field object name in the Recordset object. If
you
want a different field name or a name is not implied by the expression used
to generate the field, use the AS
reserved word
. The following example uses the title Birth to name the returned Field
object in the resulting Recordset object:
SELECT BirthDate
AS Birth FROM Employees;
Let me know if I can explain any of this.
All the best,
Cearbhall
"Good design enables - Bad design disables"
Tel: 01-2864623 Mob: 087 9922227 Em: cearbhall.omeadhra@xxxxxxxxxxxxx
******************************************************
This document is strictly confidential and is intended for use by the
addressee unless otherwise indicated.
This email has been scanned by an external email security system.
Allied Irish Banks
AIB and AIB Group are registered business names of Allied Irish Banks p.l.c.
Allied Irish Banks, p.l.c. is regulated by the Financial Regulator.
Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311;
Registered in Ireland: Registered No. 24173
******************************************************
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.467 / Virus Database: 269.6.2/785 - Release Date: 02/05/07
14:16
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.467 / Virus Database: 269.6.2/787 - Release Date: 03/05/07
14:11
Other related posts:
