Lesson 1 & 2 Vocab

Question 1

• Backstage view

Answer 1

displays when you click the FILE tab and contains access to many of the commands that were on the File menu in versions prior to Microsoft Access 2010.

Question 2

• Badges

Answer 2

small square labels

Question 3

• Change Help Collection menu

Answer 3

in the lower-right corner of the Access Help heading lets you choose between the help topics that are available online and the help topics installed in your computer offline.

Question 4

• Database

Answer 4

is a tool for collecting and organizing information

Question 5

• Database management system (DBMS)

Answer 5

enables you to easily collect large volumes of data organized into categories of related information.

Question 6

• Datasheet

Answer 6

is the visual representation of the data contained in a table or of the results returned by a query.

Question 7

• Data type

Answer 7

controls the type of data a field will contain—whether it is text, number, date/time, or some other type of data

Question 8

• Dialog box launcher

Answer 8

which is a small arrow in the lower-right corner of the group that you click to launch a dialog box or task pane that displays additional options or information.

Question 9

• Field

Answer 9

Each column in a table

Question 10

• FILE tab

Answer 10

a menu of options and commands that allows you to access various screens to perform common tasks with your database files—such as opening, saving, printing, closing, and changing user account settings and options.

Question 11

• Form

Answer 11

control data entry and data views and provide visual cues that make data easier to work with

Question 12

• Groups

Answer 12

common commands arranged by tabs

Question 13

• KeyTips

Answer 13

press the ALT key, small letters and numbers

Question 14

• Long text

Answer 14

data type can display up to 64,000 characters on the screen, but can store about one gigabyte of text

Question 15

• Normal forms

Answer 15

Database design principles include standards and guidelines that can be used to determine if your database is structured correctly.

Question 16

• Normalization

Answer 16

is the process of applying rules to your database design to ensure that you have divided your information items into the appropriate tables.

Question 17

• Objects

Answer 17

tables, queries, forms, and reports in a database

Question 18

• Primary key

Answer 18

is a column that uniquely identifies each row, such as Student ID Number.

Question 19

• Query

Answer 19

allow you to search and retrieve the data you have stored

Question 20

• Quick Access Toolbar

Answer 20

screen tool that helps you get your work done faster

Question 21

• Record

Answer 21

Each row in a table

Question 22

• Redundant data

Answer 22

wastes space and increases the likelihood of errors

Question 23

• Relational database

Answer 23

stores information in separate tables and these tables are connected or linked by a defined relationship that ties the data together.

Question 24

• Report

Answer 24

present your information in ways that are most useful to you.

Question 25

• Ribbon

Answer 25

change context to match the tasks you will be performing in that view

Question 26

• Short text

Answer 26

data type is used to store up to 255 characters of data in a field and is a good data type for a field that stores small amounts of text, such as names, cities, and states.

Question 27

• Tab

Answer 27

things on the ribbon

Question 28

• Table

Answer 28

the most basic database object that stores data in categories

Question 29

• Application Parts

Answer 29

were introduced in Access 2010 and consist of predefined templates that you can add to an existing database to help extend its functionality.

Question 30

• Quick Start

Answer 30

category of these templates contains a collection of predefined objects arranged by parts for tracking things such as comments, contacts, and issues.

Question 31

• Template

Answer 31

ready-to-use databases that contain all of the tables, queries, forms, and reports needed for performing specific tasks