Whip your tables into shape by assigning data types and primary keys

Hiltz, Kara
November 2009
Inside Microsoft Office (15506622);Nov2009, Vol. 6 Issue 11, p7
The article offers information on creating a database by assigning data types and primary keys. The author mentions that when creating a table in Access using the Design view, it has three functions for each field, Field name, Data type and description. He added that the most important role in the table is by keeping data integrity, considering the uniqueness of each record in the table.


Related Articles

  • Vendor Evaluations, Part 2: Designing an In-House Evaluation. Sullivan, Dan // DM Review;Mar2003, Vol. 13 Issue 3, p52 

    Part II. Discusses how to design and implement in-house evaluation of an enterprise content management. Core areas of the database evaluation; Factors to consider in vendor assessment; Categories of the test plan; Key considerations in assessing architectural compatibility and security factors.

  • Dynamic fragmentation and query translation based security framework for distributed databases. Sengupta, Arunabha // International Journal of Advanced Computer Research;Sep2015, Vol. 5 Issue 20, p249 

    The existing security models for distributed databases suffer from several drawbacks viz. tight coupling with the choice of database; lack of dynamism, granularity and flexibility; non scalability and vulnerability to intrusion attacks. There is a lack of an integrated flexible and interoperable...

  • CORR Insights: The National Hospital Discharge Survey and the Nationwide Inpatient Sample: The Databases Used Affect Results in THA Research. Cram, Peter // Clinical Orthopaedics & Related Research;Nov2014, Vol. 472 Issue 11, p3450 

    The author discusses the study of Bekkers and colleagues on the use of databases for the National Hospital Discharge Survey and the Nationwide Inpatient Sample. The author mentions that the methods by which the research will be conducted and the choice of datasets are important in the conduct of...

  • Domains Require Subtlety. Schraml, Todd // Database Trends & Applications;Jun2003, Vol. 17 Issue 6, p34 

    Discusses the function of a well-formed domain within a given database design. Guidelines to help determine whether or not domain proliferation should occur; Common set of logical functions required by items from the same domain; Concept of relational domains in real world training and...

  • Modeling is Like a Three-Legged Race. Reeves, Laura // DM Review;Feb2004, Vol. 14 Issue 2, p54 

    Discusses the types of data models that are useful for designing and deploying dimensional structures. Purpose of the business dimensional model in a business; Efforts required to evaluate a logical data model and translate it into table structures; Other characteristics of logical table design.

  • Embarcadero ER/Studio XE.  // Database & Network Journal;Dec2010, Vol. 40 Issue 6, p25 

    The article reports on the availability of ER/Studio® XE database design and data modeling tool suite from Embarcadero Technologies Inc., which offers a collaborative method for data management professionals to establish and maintain data warehouses and enterprise-scale databases.

  • DATA DECISIONS. Dyck, Timothy // eWeek;05/22/2000, Vol. 17 Issue 21, p1 

    Focuses on the dilemma faced by corporate information technology managers in selecting the right database clustering strategy to address the database challenge posed by the demands of Internet computing. Oracle Corp.'s shared-disk clustering technology; Availability and manageability advances...

  • Privacy protection in published data using an efficient clustering method. Murshed, Manzoor; Ohlmann, Jeffrey W. // Annual International Conference on Infocomm Technologies in Comp;Oct2010, p91 

    Database privacy or computer disclosure control is publishing anonymized data about individuals in such a way, that sensitive information about them cannot be revealed. In privacy preserving data publishing, both privacy and utility of the data are important. Although data utility for the...

  • ATTRACTION -- A GLOBAL AFFINITY MEASURE FOR DATABASE VERTICAL PARTITIONING. Jun Du; Barker, Ken; Alhajj, Reda // Proceedings of the IADIS International Conference on WWW/Interne;Jan2003, p538 

    Vertical partitioning clusters attributes of a relation to generate fragments suitable for subsequent allocation over a distributed platform. Partitioning is also important for centralized and web databases because data items that are mostly accessed together should reside in the same fragment....


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics