1 / 12

Databases

Learn how to create databases and design their structure, including tables, fields, and primary keys. Understand the importance of proper planning and data entry methods. Enhance your database skills and efficiency.

jshelby
Download Presentation

Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Databases WOW!! • A database is a collection of related data.

  2. Types of databases • Individual • Company • Distributed • Proprietary • Web

  3. Steps to creating databases!! • Always have a plan. • Study the existing manual system focusing on how and what data is collected and used.

  4. Steps (cont.) • Design the basic structure or organization of the database system to have two related tables.

  5. Steps (cont.) • Focus on the first table; Create the table structure by specifying fields, data types and primary key field. • To make the process faster, create a form and enter the data using the form.

  6. Parts of a database • Primary Key • Fields • Record • Tables • Form

  7. Primary Key • The unique identification number • Access will not allow more than one entry in a table to have the same primary key value. • Primary keys are often used to link tables.

  8. Fields • Fields are given field names that are displayed at the top of each table. • Field names describe their contents. • To make tables easy to read and efficient do not use long field names.

  9. Record • Each record contains information about one item in a given group. • A record typically includes a combination of numeric, text, and object data types.

  10. Table • Tables are the basic element in a relational database. • Tables make up the basic structure of a database with columns containing field data and rows containing record information.

  11. Form • Like printed paper forms, electronic forms should be designed to be easy to read and use.

  12. THE END!!

More Related