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