access

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

microsoft access

DBMS

count records

a calculation option

between

a comparison operator in an expression

unbound

a form that contain no data but has buttons that perform different actions is referred to as

property sheet

a place to change a control width or height

template

a pre-designed database that contains various pre-built objects is called a

tables

access is a relational database, which means that the data are organized into a collection of related

functions

access provides a variety of pre-built procedures that perform specific tasks and are called

field

access, a collection of numbers and/or characters that describes one aspect of a business onject or activity is called a

form

an access object you can use to create an interafce to easily view, add, update, and delete data in a database is called a

caption

an alternative to a field name

report

an object you can use to create an organized and professional output of the data is called a

arrange

click this tab to move a control in a report from one part of teh layout to another

long text

data type with > 255 characters

macro

database object that allows you to write and attach code to objects and controls

datasheet

default view for a new access database

compact and repair

deletes temporary data objects and removes corrupted data

metadata

descriptions of data fields and their formats

lookup field

display a list of data values from which the user can choose

table

each major subject or grouping of information you will store in your database should have a seperate

blank report button

enables you to create a new report from scratch using layout view

input mask

enforces data format data integrity rules

referential integrity

ensures records in assocaited tables have consistent data

64 characters

field name limit

count

finds the total number of records with a value in the field

total row

found in a summary query

gridlines

frames for rows and columns

row selector

gray box to the left of the field name in design view

-1

how does access store a "yes" response for the yes/no data type

widen the column

if any of your database columns display the ##### symbols, you need to

columns

if the fields of a report take up less than half of teh page width, select this button in the page layout group to print teh report in multiple columns

warns that data integrity rules have changed

if you change the required property of a field from no to yes, access

compund criteria

if you need to find both a particular type and a price, you can do this through

primary key

in a database, the special field that contains a unique value for each record is the

controls

in access, the fields, labels, buttons, and so forth are all known as

select query

in access, the most common type of query is a

query design

in access, the most common way to create queries is with

layout view

in this view, you can alter the design of a form and see the effects of teh changes in real time

design grid

indicates which fields have been included in the query

bound forms

object that links with a data source

stacked

on eof two primary control layouts

external data

one of five main ribbon tabs

F12

opens save as dialog box

F12

opens save as document

Ctrl+F2

opens the expression builder dialog box

AND or OR

operators that allow you to create a query using multiple criteria

application parts

pre-built components that can be added to an existing database

functions

pre-built procedures that perform a specific task

template

pre-designed database

move all fields button

quickly include all of the fields of a form

ctrl+spacebar

selects current column

unique values

set the following property in order to have access evaluate the fields in the query and avoid including duplicated values

F5

switched to form view

objects

tables and forms are examples of database

field name: expression

teh formula calculated field is in which of the following formats

foreign key

the field in common between two tables is called the

append row

the last row in an access table is called the

255 characters

the maximumm size of a short text field is

metadata

the overall descriptions about what the different data fields represent and their formats is called

required

the property which specifies that a user must enter a value in a field is called

command button

this control is used to perform an action such as close form, open form, delete record, etc.

report wizard

this convienient access feature steps you through the process of quickly creating a report

split form

this form option lets you view data in two layouts on the same form by combining both a columnar display and a datasheet layout

like comparison

this operator can help you find records containing data that is similar to the criterion value

tabular

this report layout displays the fields in a table (row and column) format

header/ footer

to add a date and time to your report, go to

print preview

to ensure that your report prints as desired, review it in

conditional formatting

to help focus your viewer's attention to certain records in a report, use

sorting

to make the data contained in a report easier to read and understand, a good option is

run

to see the results of a newly created query, you need to click

intelli sense

tools that suggests a list of possible values

many-to-many

type of relationship between tables

new values

use this property for an autonumber field to select either sequential or random

preview

used to see how a table will print

insert a new row in the field list

using design view, which of the following must you do before adding a field between existing fields

data validation

verifies teh accuracy of the data

intelli sense

when entering a citerion expression, which of the following tools suggests a list of possible values

the first row of the excel file must contain the field names from the access table

when importing data records from excel, which of these must be true

wildcard character

when used in an expression, the asterick (*) represents any string of characters and is also called a

in ascending order

when you first open a table in datasheet view, access uses the first field to sort the data records

field validation rules

when you limit entries to a certain range of values or make sure entries match a specified format, you use

design view

when you need to change field properties in an existing table, open

form

when you need to create an interface to view, add, update, and delete data in access, you should use a

field data type

when you set properties, the available properties vary based on the

design grid

when you want to add fields to a query that you have created, put the fields into the

design view

when you want to create a new table from scratch in your database and change field and table properties, use

filter

when you want to view only certain database fields such as product type, use this function

append row

where a new record is added

datasheet view

where the query results are displayed

primary key

which of the following contains a unique vlaue for each record

text box

which of the following displays the contents of a field and also allows the user to type a value into that field

query

which of the following finds data in your database by allowing you to ask a question

rich text

which of the following is a special text format applied to a long text data type that allows you to store formatted text

datasheet view

which of the following is used to enter records into a table

format property

which of the following properties indicates the way a field displays in a table

parameter query

which of the following requires you to enter the specific criteria value when you run the query

[ ]

which of the following symbols must you see when definign a parameter query

create

which of the following tabs do you use to create a query

expression

which of these should be used to write a criterion for a query

hierarchy of data

you need to design a new access database. the first step is to organize the smallest to largest data, also called


Ensembles d'études connexes

ALL HW and EXAMS Chapters 1-4 Intro to business

View Set

Population Health - Exam 2 Review - Evolve Questions

View Set

ACC 220 Intermediate Accounting I Ch.4A

View Set