Chapter 1 Flashcards
(42 cards)
Database
organized collection of integrated and related tables.
database management system (DBMS)
software that enables you to create a database; manage the data in the database by adding, deleting, and updating records; sort and retrieve data; and create queries and reports relating to that data. In this book, you learn about Microsoft Access, the leading PC-based DBMS software application.
Relational database
the data are organized into a collection of related tables
hierarchy of data
used in relational databases. In Access, the hierarchy is organized from the smallest to the largest grouping of data.
Field
a collection of characters that describes one aspect of a business object or activity—a single unit of data. Examples: Date Enrolled, Student First Name, Student Last Name, Student ID
Record
A collection of related data fields. Examples: All of the fields for one student stored together.
Table
A collection of related records. Visually, you see the table containing rows and columns. Each row is the equivalent of a record. A row contains many different columns or fields. Example: A record for each of the students at the university stored together.
Database
A collection of integrated and related tables. An example is the collection of the student, faculty, and course tables for the entire university. Another example of how this hierarchy works for a database that a university might use is shown in Table 1-1.
Navigation Pane
Lists each object in your database application
Status Bar
Displays at the bottom and contains information about the currrent database or database object if one is open.
In Access, what is the Ribbon?
Contains 5 primary tabs: File, Home, Create, External Data, and Database Tools. (Depending on configuration - may see 6th tab - Add-Ins) It provides the common office functions - copy, paste, and file management. It also has unique features associated with Access. Like Tell Me help feature - enter text in the “Tell Me search box” and Access displays command options to take you directly to the action you want to perform.
Contextual tabs
In Access, these tabs become available when working on different tasks.
Objects
Components - Tables, forms, reports, and queries.
Your database must contain at least how many tables
One
Table
Stores data records. Once a table is created, you can begin entering data. Create a separate table for each type or grouping of information. When you view data in a table, it appears in a tabular format, very much like a spreadsheet.
Query
Used to find data in your database. Queries enable you to specify criteria to locate specific records. They can also be used to perform actions such as updating or deleting records.
Report
Used to view and print the data in your database. Reports enable you to create a formatted, and more professional, way to view and print the contents of your database.
Macros & Modules
Two additional objects found in Access. They enable you to add functionality to the forms and reports in your database. Example: Add a button to a form and tell Access what action to perform when an event happens to that button (clicking a button or moving the pointer over a button)
Shutter Bar Open/Close Button
Contained in the top bar on the Navigation Pane. It opens and closes the pane.
Function of F11
Opens and closes the Navigation Pane
Groups
How objects are displayed in the Navigation Pane. It can be expanded or collapsed.
Expand/Collapse
Arrow located to the right of the group name to change the current display.
Navigation Menu
Used to customize what displays in the Navigation Pane & the way objects are organized.
Category
The highest organizational level in the Navigation Pane.
