Module#1: Exploring Access Flashcards
What is a Database?
it’s an organized collection data files or tables
What is the Purpose of a Database?
it is for many reasons, such as doctors using them to track patient visits.
What is Database Management Software?
it allows users to store, manipulate and retrieve database information
What is SQL?
it’s Structured Query Language
What is MySQL?
it’s the most popular open source database management system.
What are other successful data management software systems?
DB2 and Oracle
What are Microsoft Access and FileMaker Pro examples of?
Graphical user interface (GUI) database applications
What is the Work Area?
its where you work with your main database objects
What is the Navigation pane?
also called Objects Panel, Lists existing database objects, specifically, tables, queries, forms and reports.
Define a Table
A file or collection of related records
Define Form
a Database screen used to enter, edit or view the data for an individual record
Define Query
A database object or module used to request, search, select and sort data contained in tables based on specific criteria and conditions
Define Report
a database page that presents processed and summarized data from tables and queries as info
What can you do with Tables?
Enter, Edit, Delete or view the data in a row and column layout.
What is a Record?
it’s a collection of details about an individual person, place or thing
