Staff View: :: Library Catalog

Saved in:

Bibliographic Details
Main Authors:	Butler, E. Sonny, Napier, Timothy R.
Format:	Recurso educativo Open Access
Language:	en
Published:	2002
Subjects:	Data Processing Database Design Database Management Systems Databases Information Management Information Retrieval Library Automation World Wide Web
Online Access:	https://eric.ed.gov/?id=ED472704
Tags:	Add Tag No Tags, Be the first to tag this record!

_version_	1867181623701667840
author	Butler, E. Sonny Napier, Timothy R.
author_facet	Butler, E. Sonny Napier, Timothy R. Butler, E. Sonny Napier, Timothy R.
collection	Education Resources Information Center
contents	Using Microsoft Access XP: A How-To-Do-It Manual for Librarians. How-To-Do-It Manuals for Librarians, Number 120. Butler, E. Sonny Napier, Timothy R. Data Processing Database Design Database Management Systems Databases Information Management Information Retrieval Library Automation World Wide Web This manual is designed to assist librarians in programming unique database applications that meet specific library needs. Chapter 1 goes over the basic functions of working with Windows, describes terms such as multitasking, and shows how to use the menu and tool bars. Chapter 2 covers the basics, defines some useful terms, and presents the steps for database objects, database design, and using the database wizard. Chapter 3 discusses designing, saving, modifying, and closing the table. Chapter 4 discusses entering, finding, and deleting records. Chapter 5 teaches how to sort and index data fields within the database and presents some of the advantages and disadvantages of each method. Chapter 6 explains how to create and modify queries. Chapter 7 shows how to create forms, modify forms, modify table records using forms, and use sub-forms. Chapter 8 discusses database structure with relationships, tables, and queries. Chapter 9 explains advanced queries, and Chapter 10 follows that with reports. Chapter 11 shows how to create and use macros. Chapters 12 and 13 discuss creating and modifying using the switchboard, a tool that allows the using to do some interesting things with the database. Chapter 14 deals with some of the security aspects of Access, and Chapter 15 provides information for working with Access on the World Wide Web. (Contains a glossary and an index.) (MES)
format	Recurso educativo Open Access
id	eric_ED472704
institution	ERIC Institute of Education Sciences
language	en
publishDate	2002
record_format	eric
spellingShingle	Using Microsoft Access XP: A How-To-Do-It Manual for Librarians. How-To-Do-It Manuals for Librarians, Number 120. Butler, E. Sonny Napier, Timothy R. Data Processing Database Design Database Management Systems Databases Information Management Information Retrieval Library Automation World Wide Web Using Microsoft Access XP: A How-To-Do-It Manual for Librarians. How-To-Do-It Manuals for Librarians, Number 120. Butler, E. Sonny Napier, Timothy R. Data Processing Database Design Database Management Systems Databases Information Management Information Retrieval Library Automation World Wide Web This manual is designed to assist librarians in programming unique database applications that meet specific library needs. Chapter 1 goes over the basic functions of working with Windows, describes terms such as multitasking, and shows how to use the menu and tool bars. Chapter 2 covers the basics, defines some useful terms, and presents the steps for database objects, database design, and using the database wizard. Chapter 3 discusses designing, saving, modifying, and closing the table. Chapter 4 discusses entering, finding, and deleting records. Chapter 5 teaches how to sort and index data fields within the database and presents some of the advantages and disadvantages of each method. Chapter 6 explains how to create and modify queries. Chapter 7 shows how to create forms, modify forms, modify table records using forms, and use sub-forms. Chapter 8 discusses database structure with relationships, tables, and queries. Chapter 9 explains advanced queries, and Chapter 10 follows that with reports. Chapter 11 shows how to create and use macros. Chapters 12 and 13 discuss creating and modifying using the switchboard, a tool that allows the using to do some interesting things with the database. Chapter 14 deals with some of the security aspects of Access, and Chapter 15 provides information for working with Access on the World Wide Web. (Contains a glossary and an index.) (MES)
title	Using Microsoft Access XP: A How-To-Do-It Manual for Librarians. How-To-Do-It Manuals for Librarians, Number 120.
topic	Data Processing Database Design Database Management Systems Databases Information Management Information Retrieval Library Automation World Wide Web
url	https://eric.ed.gov/?id=ED472704

if (filemtime($filename) + $maxlifetime < time()) { unlink($filename); $count++; } } return $count; } /** * A function that is called internally when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ protected function saveSession($sessId, $data): bool { $sessFile = $this->path . '/sess_' . $sessId; if ($handle = fopen($sessFile, 'w')) { $return = false; // Lock the file for exclusive access to avoid issues with multiple // processes writing session simultaneously: if (flock($handle, LOCK_EX)) { $return = fwrite($handle, $data); // Make sure that there's no trailing data by truncating the file to // the correct length: ftruncate($handle, strlen($data)); fflush($handle); flock($handle, LOCK_UN); } fclose($handle); if ($return !== false) { return true; } } // If we got this far, something went wrong with the file output... // It is tempting to throw an exception here, but this code is called // outside of the context of exception handling, so all we can do is // echo a message.

// Anecdotal testing Today and Yesterday seems to indicate destroy() // is called by the garbage collector and everything is good. // Something to keep in mind though. return 0; } /** * Write function that is called when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ public function write($sessId, $data): bool { if ($this->writesDisabled) { return true; } return $this->saveSession($sessId, $data); } /** * A function that is called internally when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ abstract protected function saveSession($sessId, $data): bool; }

* * @return void */ public function writeClose() { // The assumption is that we're using PHP's ext/session. // session_write_close() will actually overwrite $_SESSION with an // empty array on completion -- which leads to a mismatch between what // is in the storage object and $_SESSION. To get around this, we // temporarily reset $_SESSION to an array, and then re-link it to // the storage object. // // Additionally, while you _can_ write to $_SESSION following a // session_write_close() operation, no changes made to it will be // flushed to the session handler. As such, we now mark the storage // object isImmutable. $storage = $this->getStorage(); if (! $storage->isImmutable()) { $_SESSION = $storage->toArray(true); session_write_close(); $storage->fromArray($_SESSION); $storage->markImmutable(); } } /** * Attempt to set the session name * * If the session has already been started, or if the name provided fails * validation, an exception will be raised. * * @param string $name * @return SessionManager * @throws Exception\InvalidArgumentException */ public function setName($name) { if ($this->sessionExists()) { throw new Exception\InvalidArgumentException( 'Cannot set session name after a session has already started'

Environment & details:

GET Data empty

POST Data empty

Files empty

Key	Value
language	"en"
VUFIND_SESSION	"df0d8fe68e707d7bf7cc22b5b01a3d6f"
ui	"standard"

Session

Key	Value
__Laminas	array:2 [`"_REQUEST_ACCESS_TIME" => 1784397453.2953 "_VALID" => array:1 [ "Laminas\Session\Validator\Id" => "df0d8fe68e707d7bf7cc22b5b01a3d6f" ]`]
SessionState	Laminas\Stdlib\ArrayObject {#938}
FlashMessenger	Laminas\Stdlib\ArrayObject {#1583}
SessionHelper	Laminas\Stdlib\ArrayObject {#1776}

Server/Request Data

Key	Value
REDIRECT_VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
REDIRECT_HTTPS	"on"
REDIRECT_SSL_TLS_SNI	"info.umar.mx"
REDIRECT_STATUS	"200"
VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
HTTPS	"on"
SSL_TLS_SNI	"info.umar.mx"
HTTP_ACCEPT	"/"
HTTP_USER_AGENT	"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
HTTP_COOKIE	"language=en; VUFIND_SESSION=df0d8fe68e707d7bf7cc22b5b01a3d6f; ui=standard"
HTTP_ACCEPT_ENCODING	"gzip, br, zstd, deflate"
HTTP_HOST	"info.umar.mx"
PATH	"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/snap/bin"
SERVER_SIGNATURE	"<address>Apache/2.4.66 (Ubuntu) Server at info.umar.mx Port 443</address>\n"
SERVER_SOFTWARE	"Apache/2.4.66 (Ubuntu)"
SERVER_NAME	"info.umar.mx"
SERVER_ADDR	"200.23.222.19"
SERVER_PORT	"443"
REMOTE_ADDR	"216.73.217.30"
DOCUMENT_ROOT	"/usr/local/vufind/public"
REQUEST_SCHEME	"https"
CONTEXT_PREFIX	""
CONTEXT_DOCUMENT_ROOT	"/usr/local/vufind/public"
SERVER_ADMIN	"admin@localhost"
SCRIPT_FILENAME	"/usr/local/vufind/public/index.php"
REMOTE_PORT	"14315"
REDIRECT_URL	"/Record/eric_ED472704/Details"
GATEWAY_INTERFACE	"CGI/1.1"
SERVER_PROTOCOL	"HTTP/1.1"
REQUEST_METHOD	"GET"
QUERY_STRING	""
REQUEST_URI	"/Record/eric_ED472704/Details"
SCRIPT_NAME	"/index.php"
PHP_SELF	"/index.php"
REQUEST_TIME_FLOAT	1784397453.2909
REQUEST_TIME	1784397453

Environment Variables empty

Registered Handlers

0. Whoops\Handler\PrettyPageHandler

Environment & details:

GET Data empty

POST Data empty

Files empty

Key	Value
language	"en"
VUFIND_SESSION	"df0d8fe68e707d7bf7cc22b5b01a3d6f"
ui	"standard"

Session

Key	Value
__Laminas	array:2 [`"_REQUEST_ACCESS_TIME" => 1784397453.2953 "_VALID" => array:1 [ "Laminas\Session\Validator\Id" => "df0d8fe68e707d7bf7cc22b5b01a3d6f" ]`]
SessionState	Laminas\Stdlib\ArrayObject {#938}
FlashMessenger	Laminas\Stdlib\ArrayObject {#1583}
SessionHelper	Laminas\Stdlib\ArrayObject {#1776}

Server/Request Data

Key	Value
REDIRECT_VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
REDIRECT_HTTPS	"on"
REDIRECT_SSL_TLS_SNI	"info.umar.mx"
REDIRECT_STATUS	"200"
VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
HTTPS	"on"
SSL_TLS_SNI	"info.umar.mx"
HTTP_ACCEPT	"/"
HTTP_USER_AGENT	"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
HTTP_COOKIE	"language=en; VUFIND_SESSION=df0d8fe68e707d7bf7cc22b5b01a3d6f; ui=standard"
HTTP_ACCEPT_ENCODING	"gzip, br, zstd, deflate"
HTTP_HOST	"info.umar.mx"
PATH	"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/snap/bin"
SERVER_SIGNATURE	"<address>Apache/2.4.66 (Ubuntu) Server at info.umar.mx Port 443</address>\n"
SERVER_SOFTWARE	"Apache/2.4.66 (Ubuntu)"
SERVER_NAME	"info.umar.mx"
SERVER_ADDR	"200.23.222.19"
SERVER_PORT	"443"
REMOTE_ADDR	"216.73.217.30"
DOCUMENT_ROOT	"/usr/local/vufind/public"
REQUEST_SCHEME	"https"
CONTEXT_PREFIX	""
CONTEXT_DOCUMENT_ROOT	"/usr/local/vufind/public"
SERVER_ADMIN	"admin@localhost"
SCRIPT_FILENAME	"/usr/local/vufind/public/index.php"
REMOTE_PORT	"14315"
REDIRECT_URL	"/Record/eric_ED472704/Details"
GATEWAY_INTERFACE	"CGI/1.1"
SERVER_PROTOCOL	"HTTP/1.1"
REQUEST_METHOD	"GET"
QUERY_STRING	""
REQUEST_URI	"/Record/eric_ED472704/Details"
SCRIPT_NAME	"/index.php"
PHP_SELF	"/index.php"
REQUEST_TIME_FLOAT	1784397453.2909
REQUEST_TIME	1784397453

Environment Variables empty

Registered Handlers

0. Whoops\Handler\PrettyPageHandler

Similar Items

Environment & details:

Environment & details: