Maggie Shapland - Oracle, SQL, Papyrus, Microsoft Access, ODBC, Zope and vintage cars

Microsoft Access section (last revised 13 July 2010) includes:
- Access tutorials (updated June 2007)
- repair and installation problems (updated January 2007)
- Access solutions (updated Feb 2008)
- Access SQL (including comparison with Oracle SQL)
- Access (2,97,2000,2002,2003, 2007) (conversion and whats new, updated July 2010)
- year 2000
- Converting from Oracle to Access and vice versa
Oracle section (Revised Feb 2001) includes:
- Oracle tutorials
- year 2000
- Oracle SQL (including comparison with Access SQL)
- Converting from Oracle to Access and vice versa
ODBC section (Revised July 2008) describes
- problems and timings using Access as frontend (revised June 2003)
- ODBC Configuration (Access 2,97,2000; Oracle 6,7,8,9; Windows NT, 2000, XP), and how to create a datasource (revised June 2008)
- year 2000
Zope section (web site builder) (last revised 9 October 2008) describes
- Zope tutorials
- using Zope with Oracle
- Zope and SQL
- Zope comparison with Oracle WebDb
Evaluation of Reporting Tools (last revised 16 February 2004)
- Oracle Discoverer, Cognos Impromptu, Computer Associates Cleverpath, Crystal Reports, Cognos ReportNet, JReport
There are a large number of reference manager tools listed at http://wiki.services.openoffice.org/wiki/Bibliographic_Software_and_Standards_Information
http://en.wikipedia.org/wiki/Comparison_of_reference_management_software
Papyrus section (revised July 2002) includes
- News about no further plans to develop Papyrus- so no windows version ever
- Papyrus FREE
- Papyrus installation, upgrades, tutorials and manuals
- Papyrus formats (last revised Jul 2001 to include updated medline format),
- closure of BIDS ISI (May 2000)
- Reference Management Software Evaluation (Papyrus, Reference Manager evaluation, ProCite, Reference Manager, Idealist, Endnote, GetARef, Citation 7, Biblioscape, Bibliographica, Scribe, Library Master, Refs, Research Toolbox, Scholars Aid, Refworks, WriteNote) revised September 2003
- year 2000 (revised Jan 2000)
Endnote section (revised July 2005) includes
- details about new site licensedeal
- Endnote formats and tutorials (revised November 2000)
- Reference Management Software Evaluation (revised September 2003)
- Z39.50 connections (revised January 2004 with University of Bristol Aleph connection
- Exporting references between Papyrus and Endnote
- Importing an existing reference collection into EndNote (revised October 2004)
Vintage Car section shows I have a life! (revised October 2003) includes:
- car magazine index
- pictures and details of my cars (updated October 2003)
  - 1925 Talbot 10/23 including Talbot crash May 2001 pictures and diary of progress since (revised May 2002)
  - 1924 Lanchester 21 including timing a Lanchester (Feb 2002)
  - 1986 Moss Monaco (Ford RS2000 engine) kit car
  - 1929 Peugeot 190S. latest Peugeot restoration pictures and progress (October 2003)
- vintage car paint colours (Sep 2000)

Other Interests

Clifton and Hotwells Improvement Society

Bristol Industrial Archaeological Society

Clifton Rocks Railway Restoration Chairman (diary of restoration progress)

WORK FUNCTIONS

Web and Database Team I sort out any database problems for the University, particularly Microsoft Access, Oracle, PC-File and Papyrus. I can also help in database design and conversion and reference manager software evaluation. I have also used ODBC extensively (linking Access to Oracle 6, 7 and 8 databases) and written several papers about it. Please contact me if you need any help. I have been here since 1972!

Internal Tel No: 89869 Email: Maggie.Shapland@bristol.ac.uk
Information Services, Computer Centre, University of Bristol, Tyndall Avenue, Bristol BS8 1UD

PERSONAL EMAIL Maggie.Shapland@gmail.com

Search bris.ac.uk
Search WWW

Maintained by Maggie Shapland (set up 1996) revised July 2008 Saturday, 11-Feb-2012 22:09:05 GMT
Computing Service, University of Bristol BS8 1UD

University of Bristol		contacting people a-z index help search