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
How are Records displayed?
in a Row
What can Forms do?
They provide a quick, accuarate and user-friendly way to display individual records and enter data into tables
in What views can forms be opened?
Design, Layout and Form
True or False: Deleted Record numbers auto renumber in the records?
False. Access will not renumber.
What do Queries Do?
they allow you to extract data from database tables based on criteria
What do Reports do?
Reports display info retrieved from a table or query in an organized and formatted layout
in what Views can Reports be opened?
Design, Layout, Report and Print Preview
