chapter 1 Flashcards
Database
a collection of data organized as meaningful information that can be accessed, managed and sorted e.t.c.
Database Management System
A software system that provides the tools needed to create maintain and use database.
Object
Component created and used to make the database function
Navigation Pane
Objects include table, queries, forms and reports and are found here.
Table
Where all the data is stored, foundation of database.
Field
Each column represents a field, a category of information stored in a table.
Record
A complete set of all the fields about one person, place,event or concept.
Primary Key
A field that uniquely identifies each record in a table.
Query
Is a question you ask about the data in your database.
Form
Allows simplified entry and modification of data.
Report
Contains professional-like formatted information from underlying table or queries.
Macro
Stored series of command that carry out an action. Often used to automate tasks.
Module
An advanced object written using VBA programming language.
Data sheet view
A grid containing fields and records.
Design View
Gives detailed view of table’s structure and is used to create and modify a table’s design by specifying the fields it will contain.
