Simple introduction into databases elements included

Asked By Brenda Lopez 20 points N/A Posted on - 04/10/2015

What is a database? What are records, table and field? What are the two types of database? What are the basic elements of a database? I’ve heard that there’s an old tool in VB 6.0 that can be used to create database? Can you show me how to create database using VisData? In this part, I just want to know brief explanation and simple instructions. Please do not overflow the explanation so it will be easier for me to understand everything.

Thank you very much!

• Status: Open
• Question Views: 503
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Dave Crinit 5 points N/A #174388

Simple introduction into databases elements included

Happy to support you!

A database is a collection of data related to a particular subject, which is properly organized. Databases can be created and maintained manually as well as electronically. Its basic elements can be explained as

• DB schema
• Schema objects
• Indexes
• Tables – collections of fields & record related to a particular instance 
• Fields – the properties that describe an entity
• Columns
• Records – any real world object like a person, thing or place, etc.
• Rows
• Keys
• Relationships
• Data types

 

Yes of course, there is an old tool in VB 6.0 that can be used to create database. In order to create a database using VisData, you first have to install the soft ware, open it, assign the fields, rows, keys & other related constrains and then insert the data into the tables crated.

About Dave Crinit

Questions
0

Answers
211

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/16/2015
• Question Category: MS Access