Help

Options

focusNode

Didn't know it?
click below

Knew it?
click below

Don't Know

Remaining cards (0)

Know

retry

shuffle

restart

0:00

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size Small Size show me how

access

chapter 1 question and answer

Question	Answer
a query is a database object that:	retrieves specific data fro one or more database tables or queries.
a flat database is:	not related to any other collection of data.
DBMS is an acronym for ______.	Data base management system
the part of the access window that groups the commands for performing related database tasks on tabs is the______.	Ribbon
a Microsoft access database has a file extension of	.accdb
the most common database objects are:	tables, queries, forms, and reports
which view allows you to make margin or page orientation changes to a report prior to printing it?	print preview
one purpose of a form is to	simplify data entry in the database
when printing a report, ____ indicate how the report would break across pages if you print it	dotted lines
to create a query using the simple query wizard, you choose the data source and:	field names
to organize your database objects use the:	navigation pane
the part of the access window that shows the name of the database is the	title bar
the primary key icon contains a picture of a	key
in the navigation pane the view that groups a query with the table with its data source is	tables and related views
the table design view shows	the structure of the table
a type of query that retrieves data from one or more tables and makes it available for use in the format of a datasheet is a ______query	select
The process of copying data from one source or application to another is	import
after a query has been designed to find the records that match the criteria, access must ______the query	run
the field in one or more tables used to join tables together is called	a common field
each table row contains all categories of data pertaining to one entity and is called a	record
to rename a table you can	right click the table name in the navigation pane
when creating a form or report the access view that allows changes while the object is open is _____view	layout
the width of columns in tables can be automatically increased to decreased to fit the contents which is known as ____	best fit
A database _______ is pre-formatted database designed for specific purpose	Template
the process of applying design rules and principles to ensure that your database performs as expected is known as ____	normalization
In Microsoft access, all data is stored in one or more	tables
when data in a table becomes redundant	it is usually an indication that you need a new table to contain information about the topic.
headers and footers for Microsoft access tables and queries	are controlled by default settings and cannot be edited
when importing data from an excel workbook you may not:	append a copy of the records to an open, active table
any symbol that appears on the creen in reponse to the mouse device being moved is called the mouse______.	pointer
to use the start search feature, display the windows 8 _____and start typing	start menu
using the _____dialog box you can navigate to and open and existing file created using the same program.	open
The ____in a file explorer window shows the current location in the folder structure.	address bar
details about a file that describe or identify it are called:	document properties
the ____feature provides information about all of a program's features and displays step-by-step instructions for performing many tasks.	Help
the ____displays across the top of the program window, grouping commands features in the manner in which they would most logically be used.	Ribbon
____dialog boxes are provided by the windows programming interface and appears in the same manner in all office programs.	common
Microsoft Office's ______view is a centralized space for tasks related to file management	backstage
Screen tip that displays additional useful and descriptive information about a command is called	enhanced
the primary method of entering information into your computer is the	keyboard
the ____displays Microsoft office backstage view	file tab
A keyboard _____ is a key or combination of keys that performs a task that would otherwise require a mouse.	shortcut
a ____ is a separate area of a window	pane
the selection or setting that is automatically used by a program unless you specify otherwise is called a _______setting	default
a shortcut menu displays:	context-sensitive commands
a file or multiple files can be ____into one smaller file that can be e-mailed or transferred over the Internet more easily.	Compressed
____enable you to choose how an object interacts with the surrounding text.	layout options
Microsoft Office's ____feature provides information about all of the current programs features and displays step-by-step instructions for some tasks.	Help
a container where files are stored is a	folder
The screen in windows that simulates a work area is called the	desktop
when printing a document in ____orientation, the paper is taller than it is wide	portrait
a _____is a reserved area for text or graphics that displays at the top of each page of a document	header
the ____ enables you to copy the formatting of specific text and apply it to other locations in the document.	format painter
___indicate the groups of related commands on the displayed tab.	group names
URL, which is an address that uniquely identifies a location on the Internet, stands for ______	Uniform Resource Locator
The ribbon in each microsoft program contains these three elements	tabs, groups, commands
when printing a document in _____orientation the paper is wider than it is tall	landscape
a blinking vertical line that indicates where text will be inserted is called the	insertion point
a round button that enables you to make one selection from among several choices is called a(n)	option button
a folder stored in another folder is called a(n)	subfolder
The access view that displays data in columns and rows like an excel worksheet is	datasheet view
the characteristic that defines the kind of data you can store in a field is the	data type
the box at the left of a record in datasheet view that you click to select an entire record is the	record selector box
to add on to the end of an object, such as to add records to the end of an existing table is to:	append
Characteristics of a field that control how the field displays and how data is entered are:	field Properties
the field that uniquely identifies a record in a table is known as the	primary key
The underlying design of a table is referred to as the	structure
the object that retrieves specific data and then displays only the data that you specify is a	query
the object that displays fields and records from a table or query in a printable format is a	report
Information repeated in a database in a manner that indicates poor design is said to be	redundant
the data type that describes text, a combination of text and numbers or numbers that are not used in calculations, such as ZIP conde is	short text
the data type that describes monetary values and numeric data used in mathematical calculations involving data with one to four decimal places is	currency
precise changes to the properties (characteristics) of selected items in a data base can be made in the	property sheet
The data type that describes a unique sequential or random number assigned by access as each record is entered is	autonumber
a more sophisticated type of database that stores multiple collections of data that are related to one another; for example, data about the student, the courses, and the faculty members at a college is a	relational database

Created by: ssassy796

"Know" box contains:
Time elapsed:
Retries: