Data bases

Data bases

1. Collection of organized information that can easily be accessed, managed and updated

2. There are many apps or programs to create day bases

   • Access
     • Tables
       • One table created for each type of information you want to track
         • To bring the data of multiple tables together, you define relationships between them.
     • Queries
       • It helps you find and recover the data that meets specified conditions
     • Forms
       • Used to view, enter change and send data
     • Fields
       • Determines the type of data that can be stored in a table
         • Primary key
           • A field or set of fields with a unique value for each record stored in the table
             • Used to create table relationships
         • Foreign key
           • It is another table's primary key
             • If the values on the foreign key match the values on the primary key of another table, indicates that both records are related.