Back to Search Start Over

Uso do MS ACCESS como aplicativo para base de dados no gerenciamento de coleções: estudo de caso em museus de Paleontologia.

Authors :
Santos, Coryntho A.
Santos, Marcia F. A.
Fonseca, Vera M. M.
Dutra, Tânia L.
Corrêa, Gabriela da R.
Source :
Gaea: Journal of Geoscience. jan-jun2016, Vol. 9 Issue 1, p47-54. 8p.
Publication Year :
2016

Abstract

A new approach in cataloguing fossil samples stored in scientific collection is herein presented. By the use of a Databases and their management, a query mode in paleontological collections is applied using the Microsoft Office ACCESS tool. With this purpose, two Brazilian paleontological collection were used to verify the internal management and facilities of this application, the Paleoinvertebrates repository from the National Museum of Rio de Janeiro (MN), at UFRJ (Federal University of Rio de Janeiro), and the Paleobotany and Paleoinvertebrate collections from LaViGæa/MHGEO Museum, at Unisinos (Vale do Rio dos Sinos University). The databases were developed using previous enters furnished by the Catalogue books (e.g. source locality and taxonomy) and in accord with its page disposition - a table form. It takes into account that in a Database, a table is a basic component and represents a group of data. Fifteen tables were constructed, with the main ones ("Tbl Paleoinvertebrados" or "Tbl Paleobotânica") and the related secondaries, whose data are stored in the principal one. Therefore, 34 (MN) and 33 (LaViGæa, Unisinos) fields were constructed, with a capacity of storage of more than 900,000 samples. The data is inserted through the form "Frm_ Paleoinvertebrados" or "Frm_ Paleobotânica", since all of the fields are easily viewed, which minimizes the mistakes. The Databases constructed, using the ACCESS, demonstrate its easy performance and agility in data insertion. The use of a Tab key allows to access the fields, and a "Combo Box" in the majority of the fields (32) allows to automatically save the data with a click in the specific name. The system is able to print labels, attach photos and has "a query mode", all important resources in doing any research faster and useful. The good resolution and innovation of this project was mainly due to the partnership between researchers and the programmer. [ABSTRACT FROM AUTHOR]

Details

Language :
Portuguese
ISSN :
18085261
Volume :
9
Issue :
1
Database :
Academic Search Index
Journal :
Gaea: Journal of Geoscience
Publication Type :
Academic Journal
Accession number :
116684193
Full Text :
https://doi.org/10.4013/gaea.2016.91.04