Access Chapter 1
Tables and Related Views category
, which groups objects by the table to which the objects are related
Caption
...
Navigation Pane
...
record selector bar
...
3. custom web app
A third method is to create a ____________ database from scratch or by using a template that you can publish and share with others over the Internet.
Close button for object
Closes the active object (table, query, or other object).
Ribbon with command groups arranged in tabs
Groups the commands for performing related database tasks on tabs.
Object tab
Identifies and enables you to work with the open object.
Status bar
Indicates the active view and the status of action occurring within the database on the left; provides buttons on the right to switch between Datasheet view and Design view.
2. blank desktop database
It has no data and has no database tools; you create the data and the tools as you need them.
Table Tools
Provides tools for working with a table object—only available when a table object is active.
Blank desktop database
Starts a blank database that is stored on your computer or on a storage device.
Available templates
Starts a database for a specific purpose that includes built-in objects and tools ready for use.
Custom web app
Starts a web app database that can be published and shared on the Internet.
data source
The objects from which a query selects the data are referred to as the query's
common field
The tables of information in a relational database are linked or joined to one another by a _______
1. database template
a preformatted database designed for a specific purpose.
field
a single piece of information for every record
flat database
a type of database because it is a collection of data about one topic, not related or linked to any other collection of data
append
add on—data from an Excel spreadsheet to your 1A Students table
Best Fit
adjusting the column width to fit the contents is
record
all of the categories of data pertaining to one person, place, event, thing, or idea.
SharePoint
an application for setting up websites to share and manage documents.
Tables
are the foundation of an Access database because all of the data is stored in one or more tables
Field properties
control how the field displays and how data can be entered into the field
export
copy data from one file into another file
truncated
cut off or shortened—because the fields were not previously restricted to these specific number of characters.
data type
defines the kind of data that you can store in a field, such as numbers, text, or dates. ]
AutoNumber data type
describes a unique sequential or random number assigned by Access as each record is entered.
Short Text data type
describes text, a combination of text and numbers, or numbers that are not used in calculations, such as the Postal Code
Navigation Pane
displays and organizes the names of the objects in a database.
object window
displays the open objec
wizard
feature in a Microsoft Office program that walks you step by step through a process.
populate
filling one or more tables with data
single-record form
form enables you to display or enter one record at a time into a table.
import
he process of copying data from one source or application to another application
navigation area
indicates the number of records in the table and has controls in the form of arrows that you click in order to navigate among the records.
link
is a connection to data in another file
report
is a database object that displays the fields and records from a table or query in an easy-to-read format suitable for printing.
query
is a database object that retrieves specific data from one or more database objects—either tables or other queries—and then, in a single datasheet, displays only the data that you specify when you design the query.
form
is an Access object with which you can enter data, edit data, or display data from a table or query.
A database
is an organized collection of data
. Information
is data that is organized in a useful manner
Normalization
is the process of applying design rules and principles to ensure that your database performs as expected
first principle of good database design
is to organize data in the tables so that redundant —duplicate—data does not occur
Primary key
refers to the field in the table that uniquely identifies a record. F
select query
retrieves (selects) data from one or more tables or queries and then displays the selected data in a datasheet.
relational database
so-called because multiple collections of data in the database are related to one anothe
Layout view
the Access view in which you can make changes to an object while the object is open and displaying the data from the data source.
objects
the basic parts of a database; you create objects to store your data, to work with your data, and to display your data
source file
the file being imported
destination table
the table into which you import or append data is referred to as the ______
second principle of good database design
use techniques that ensure the accuracy and consistency of data as it is entered into the table
Currency data type
which describes monetary values and numeric data that can be used in calculations and that have one to four decimal places.
Datasheet view
which displays the data in columns and rows similar to the format of an Excel worksheet
Design view
which displays the underlying design—the structure —of the table's fields
Form view
you can view the records, create a new record, edit a record, and delete a record. You cannot change the layout or design of the form.
Recent files
Displays a list of database files that have been recently opened.
Object window
Displays the active or open object (table, query, or other object).
Title bar
Displays the database name.
Navigation Pane
Displays the database objects that you can open in the object window.
Suggested searches
Enables you to click on a category to start an online search for a template.
Open Other Files
Enables you to open a database file from your computer, a shared location, or other location that you have designated.
Search box
Enables you to search the Microsoft Office website for templates.
Property Sheet
Every object and every item in an object has an associated _______ where you can make precise changes to the properties
