Description
This tool creates a simple summary description of an Access database (number of tables, number of columns and records in each table, a list of column names, etc). It is intended as a tool to facilitate data exploration and report generation.
Syntax
access.summary(file);
| file | the full path to the input database file (*.mdb) |
Example
access.summary(file="C:\data\mydata.mdb");
Database: C:\data\mydata.mdb
Table count: 5
Table: Aquatic Ecosystem Health
Record count: 12
Field count: 9
Fields: Contact, Email, FileName, Group, ID, LayerName, MapName, Metadata, SubGroup
Table: Base Maps
Record count: 80
Field count: 9
Fields: Contact, Email, FileName, Group, ID, LayerName, MapName, Metadata, SubGroup
Table: Groups
Record count: 3
Field count: 2
Fields: Group Name, ID
Table: Land Use and Development
Record count: 48
Field count: 9
Fields: Contact, Email, FileName, Group, ID, LayerName, MapName, Metadata, SubGroup
Table: MapFilesInfo
Record count: 185
Field count: 10
Fields: Contact, Email, FileName, Group, ID, LayerName, MapName, Metadata, SubGroup, Visibility
Warning: Table names with spaces were detected. It is strongly recommended that you avoid the use of spaces in table names.
Warning: Column names with spaces were detected. It is strongly recommended that you avoid the use of spaces in column names.