FBLA Database Design & Applications

Quick Access Toolbar

provides one click access to commonly used commands such as save

Shutter Bar

allows you to close and open the navigation pane; you might want to close the pane so that you have more room on the screen to view the objects contents

Navigation Pane

lists all the objects (tables, reports, and so on) in the database, and it is the main control center for opening and working the database objects

Datasheet View

shows the tables contents as a datasheet

ID field

the primary key field for all new tables

Add & Delete Button

contains options for adding different types of fields, including Short Text and Number to a table

Click to Add column

provides another way for you to add new fields to a table

FIELDS tab

provides options for adding, removing, and formatting the fields in a table

Access Window

is the program window that appears when you create a new database or open an existing database

Title Bar

displays the name of the open file and the program

Sign in Link

lets you sign into your Office account

Ribbon

provides the main access commands organized by task into tabs and groups

Datasheet

displays the table's contents in rows and columns, similar to a table that you create in a word document or an Excel spreadsheet

Field

a single characteristic or attribute of a person, place, object, event, or idea

Table

a collection of fields that describes a person, place, object, event, or idea

Field Value

specific content of a field

Record

set of field values

Database

collection of related tables

Common field

field that appears in both tables

Primary Key

a field, or collection of fields whose values uniquely identify each recor

Foreign Key

primary key from one table as a field in a second table to form a relationship between the two tables

Database Management System (DBMS)

a software program that lets you create databases and then manipulate the data they contain

Relational Database Management System (RDBMS)

data is organized as a collection of tables

Backstage View

contains commands that allow you to manage Access files and options

Template

is a predesigned database that includes professionally designed tables, reports, and other database objects that can make is quick and easy for you to create a database

Contextual tab

which is a tab that appears and provides options for working with specific object that is selected

Data Type

determines what field values you can enter for the field

AutoNumber

data type automatically inserts a unique number in this field for every record

Short Text

data type that allows field values containing letters, digits, and other characters

Field Selector

selects that entire column or row

Create Tab

provides options for creating various database objects, including tables, forms and reports

Query Wizard Button

opens dialog box with different types of wizards that guide you through the steps to create a query

Form

contains options for a database

Form tool

quickly creates a form containing all the fields in the table

Query

a question you ask about the data stored in a database

Form Wizard

guides you through the process of creating a form

Report

a formatted printout of the contents of one or more tables in a database

Report tool

places all the fields from a selected table on a report, making it the quickest way to create a report

Report Wizard

guides you through the process of creating a report

Access Help

you can find information about Access commands and features as well as instructions for using them

Datasheet Selector

which is the box to the left of the first field name in the table datasheet

Navigation Buttons

provide another way to move vertically through records

Layout View

can make design changes to the form while it is displaying data so that you can see the effects of the changes you make immediately

All Access Object

lists all the database objects in the pane

Backing up

the process of making a copy of the database file to protect your database against loss or damage

Append

Append To add to the end of an object

AutoNumber data type

AutoNumber data type Data type the describes a unique sequential or random number

Best Fit

Best Fit An Access command that adjusts the width of a column to accommodate the column's longest entry.

Blank desktop database

Blank desktop database that has no data and has no database tools

Caption

Caption Property setting that displays a name for a field in a table

Common field

Common field A field in two or more tables that stores the same data

Currency data type

Currency data type Access data type that describes monetary values and numeric data's that can be used in math

Custom web app

Custom web app Database that you can publish and share with others over the internet

Data

Data about people, events, things, or ideas.

Data source

Data source The table or tables from which a query, form, or report retrieves its data.

Data type

Data type Characteristic that defines data that can be stored in a field, such as numbers, text, or dates.

Database

Database Organized collection of facts about people, events, things, or ideas.

Database management system

Database management system software that controls how related collections od data are stored.

Database template

Database template A preformatted database that contains prebuilt tables.

Datasheet view

Datasheet view Access view that displays data organized in columns and rows.

DBMS

DBMS Acronym for database

Design view

Design view Access view displays the detailed structure of a table.

Destination table

Destination table Table which you import or append data

Export

Export Copying data from on file into another

Field

Field Single piece of info that is stored in every record.

Field properties

Field properties Characteristics of a field that control how the field displays

First principle of good database design

FPOGDD Principle of a good database design starting that data

Flat database

Flat database Simple database file that isn't related

Form

Form Access object you can use to enter new records into a table

Form view

Form view Access view in which you can view in which you can view records

Import

Import Process of copying data from another file, such as word table or an Excel workbook

Information

Info Data organized in a useful manner

Layout View

Layout view Make changes to a form or report while the object is open

Link

Link Connection to data in another file

Multiple-items form

Multiple-items A form that enables you to display or enter multiple records in a table

Navigation area

Navigation area Bottom of the access window that indicates the number of records in the table

Navigation Pane

Navigation pane Area of the access window that displays and organizes the names of the objects in a database

Normalization

Norm Process of applying design rules and principles to ensure that your database performs as expected

Number data type

Number data type Access data type that describes numbers that might be used in calculations

Object tab

Object tab, a tab that identifies that objects and which enables you to make the open objects active

Object window

area of the access object window that displays open objects, such as tables, queries , forms, or reports

Objects

Objects Basic parts of a database that you create to store your data

Populate

Populate Action of filling a database table with records

Primary key

Primary key field in a table that uniquely identifies a record

Property Sheet

Property sheet List of characteristics

Query

Query Object that retrieves specific data

Record

Record All categories of data pertaining to one person

Record selector bar

Record selector Bar at the left edge of a record when it's displays in a from

Record selector box

The small box at the left of a record in datasheet view that, when clicked selects the entire record

Redundant

Redundant info that is duplicated in a manner that indicates poor database design

Relational database

Sophisticated type of database that has multiple collections of data

Report

Summarizes the fields and records from a table

Run

Searches the records in the tables included in a query design

Second principle of good database design

Principle stating that appropriate stating that database techniques are used to ensure that accuracy

Secure environment

A system that uses controlled servers to ensure the security and privacy of email

Select query

Access query that retrieves data from one or more tables

Server

Computer that provides services on a network such as an email server or a file server

SharePoint

Microsoft app used for setting up web sites to share and manage documents

Short Text data type

Access data type that describes text

Simple select query

Another name for a select query