Access

¡Supera tus tareas y exámenes ahora con Quizwiz!

unbound control

a control that is not linked to a field

forms

allow users to input data through a friendly interface. Easier than entering it directly into a table

lookup field

allows the user to select data from a list of items

variance

calculates the statistical variance for numeric field types only (number, decimal and currency)

macros

collections of programming code usually used within forms and reports

attribute or field

column in Excel

split form

combines convenience of a continuous data sheet with the usability of a single form displaying one record at a time

reports

display database information for printing or viewing on screen

calculated field

displays a value returned by an expression (a formula)

select query

displays data from one or more tables or queries based on the fields that you select, but it does not filter the data

bound control

displays the field data

queries

extract data form a table or related tables

layout view

looks similar to form view, but this view allows you to maniuplate the layout and formatting of the form while viewing "live" data

layout view

looks very similar to report view and allows you to manipulate the layout and formatting of the report while viewing "live data

list box

presents users with a list of options to choose from and can display values from another table or query or values that you enter yourself

form view

provides a user-friendly interface for entering data

command button control

provides a user-friendly way to interact with the form

combo box control

provides users with a combo data entry control; users can type the data in a text box or select from a list of items

record

row in excel

report view

shows a static view of the report

SQL view

shows the code used to build the query

datasheet view

shows the record set that matches the query criteria

tables

store all the database data, basic building blocks of the database

primary key

the field that contains data unique to that record

one-to-many relationship

the primary table contains a primary key field that is included as a field (the foreign key) in the secondary table

navigation form

type of form that allows you to group together all the database objects a user might need within a single form

datasheet view

use when entering data in a table or to sort and filter data

calculated data type

uses an expression to calculate a value

design view

when you want to change the structure or properties of the table

image control

where photograph/illustration/graphic is stored

design view

where you build the query, adding fields and specifying criteria


Conjuntos de estudio relacionados

Chapter 53, Nursing Management: Problems with Menstruation

View Set

NURS3309 | Health Assessment | Exam 3

View Set

ATI Fundamental practice questions pt.3

View Set

Module 2, Unit 3 - Identification and Authentication

View Set