Access ability to create table aliases

Giganews Newsgroups
Subject: Access ability to create table aliases
Posted by:  rudodoo (rahulkris…@gmail.com)
Date: 2 Aug 2006

My company uses coldfusion to create web applications and we currently
are using TOAD as a front end to creating SQL queries.  I was wondering
how is Access compared to TOAD on its ability to provide a front end to
an Oracle database

Also, does Access have the ability to create table Aliases for whenever
you create a query in design view and then view it in SQL view (or does
it have the ability to assign table aliases at all)

My dept. uses access 97 but there are others who have access 2000
installed so if you could provide some suggestions using 2000 as a
model

Replies