Cost Information System

DESKTOP NORTHWIND SAMPLE DATABASE 2007 STRUCTURE REPORT

Brief Introduction:
Database Name: Northwind
Site/Server Name: Local
Data Stored of Year: 2006
Total Objects: 6 (Tables, Queries, Forms, Reports, Macros, Modules)
Total Tables: 20
Total Queries: 27 ,(27 views)
Total Forms: 34
Total Reports: 15
Total Macros: 2
Total Modules: 6 modules and 2 class modules

A Complete Physical Schema of Tables Table: Customers Properties DateCreated: 11/30/2012 2:39:00 AM DefaultView: 2 DisplayViewsOnSharePointSit 1 FilterOnLoad: False GUID: {guid {34685D08-E805-496A- HideNewField: False A5BF-A68CD3B0DADE}} LastUpdated: 11/30/2012 2:39:22 AM NameMap: Long binary data OrderByOn: False OrderByOnLoad: True Orientation: Left-to-Right RecordCount: 29 StarColumnHidden: False TotalsRow: False Updatable: True WSSTemplateID: 105 Columns Name Type Size ID Long Integer 4 AggregateType: -1 AllowValueListEdits: False AllowZeroLength: False AppendOnly: False Attributes: Variable Length, Auto-Increment BoundColumn: 1 CollatingOrder: Neutral ColumnCount: 1 ColumnHeads: False ColumnHidden: False ColumnOrder: Default ColumnWidth: 960 DataUpdatable: False GUID: {guid {C8C60EC3-4849-4B3F-967D-142281F967D6}} OrdinalPosition: 0 Required: False RowSourceType: Table/Query ShowOnlyRowSourceValues: False SourceField: ID SourceTable: Customers TextAlign: General WSSFieldID: ID Company Text 50 AggregateType: -1 AllowZeroLength: False AppendOnly: False Attributes: Variable Length CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False DisplayControl: Text Box GUID: {guid {E05DE7F7-517A-4970-9338-F90EFD2357A3}} IMEMode: 0 IMESentenceMode: 0