Check out my
Samples
Bradenton Database Design
by Professor Floyd Jay Winters
WintersFJ@Gmail.com
| Database Terms and Examples |
|
| The three Tables shown above contain related Records in a Database |
| The tables are related or linked by the IDs shown in the first column of each table |
| A Database is a collection of related tables, such as Employees, Customers, Products, Invoices... |
| A Table is a collection of related records, in this case individual customers or invoices |
| A Field is a piece of information about a person, place or thing, in this case a Product Description |
|
| A Database Form used to enter Records into a Table |
|
| This Query will select all Records with a specific zip code |
|
| A Database Report displays summarized data |
|
| mains of a Database Report |
|
| A Navigation Form used to easily access your main database Forms and Reports |