Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Business 140 > Access > Flashcards

Access Flashcards

(69 cards)

Start Studying
1
Q

Database Management System DBMS

A

A software system that provides the tools to create, maintain, and use a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Object

A

Each component created and used to make the database function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Navigation Pane

A

Access’s interface element that organizes and lists the objects in an Access database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Table

A

Where all the data is stored in your database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Field

A

A category of information we store in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Record

A

A complete set of all the fields about a person, place, event, or concept

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Primary Key

A

A field, or combination of fields, that uniquely identify each record in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Query

A

A question you ask about the data in your database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Form

A

Allows simplified entry and modification of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Report

A

Contains professional-looking formatted information from underlying tables or queries

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Macro

A

A stored series of commands that carry out an object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Module

A

An advanced object written using the Visual Basic for Applications programming language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Datasheet View

A

A grid containing fields and records

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Design View

A

Gives a detailed view of the table’s structure and is used to create/modify a table’s design by specifying the fields it will contain

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Field Property

A

Defines characteristics of a field in more detail

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Relationship

A

A connection between two tables using a common field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Back Up Database

A

A utility that creates a duplicate copy of the entire database to protect from loss or damage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Compact and Repair Database

A

Reduces the size of a database while fixing any errors that may exist on the file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Filter

A

Allows one to specify conditions to display only those records that meet those conditions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Selection Filter

A

Displays only the records that equal a criterion

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Filter By Form

A

More versatile method of selecting data, by enabling one to display records based on multiple criteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Sort

A

Lists records in a specific sequence Ex: Alphabetically

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Template

A

Predefined database that includes professionally designed tables, forms, reports, and other objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Custom Web App

A

Shareable databases through the web

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Application Part
Adds a set of common Access components to an existing database
26
Data Redundancy
Unnecessary sorting of duplicate data in two or more tables
27
Data Type
In every field, it determines the type of data that can be entered, and the operations that can be preformed on it
28
Auto Number
Type of data that automatically increments each time a record is added
29
Foreign Key
The same field as the primary key in an adjoining table
30
Field Properties
Determine how the field looks and behaves
31
Caption Property
Creates labels that are easier to understand than a field name
32
Referential Integrity
Enforces rules in a database that are used to preserve relationships between tables when records are changed
33
Cascade Update Related Fields
An option that when the primary key value is modified in a primary table, Access updates all key foreign fields in related tables
34
Cascade Delete Related Records
An option that when a primary key value is deleted in a primary table, access will delete all records in related tables
35
One-to-Many Relationship
Established when the primary key value in the primary table can match many of the foreign key values in the related table
36
Criteria Row
Used to set the rules that determine which records will be selected
37
Simple Query Wizard
Guides one through query design with step-by-step instructions
38
Wildcards
Special characters that represent one or more characters in a text value
39
Comparison Operators
Used in query criteria Ex: (=), (<>), etc..
40
Null
A blank field
41
AND Condition
The query results will display only records that match all criteria
42
Or Condition
Query results will display records that match any of the specified criteria
43
Multi-table Queries
Contain 2 or more tables, and enable one to take advantage of the relationships that have been set in your database
44
Expression
Combination of elements that produce a value
45
Calculated Field
Field that displays the result of an expression rather than data stored in a field
46
Constant
A value that doesn't change
47
Order of Operations
Determines the sequence by which operations are calculated in a mathematical expression
48
Property Sheet
Enables one to change the way a field appears
49
Expression Builder
A tool that can help with creation of more complicated expressions
50
Argument
Each input used to produce an output for a function
51
Pmt Function
Calculates the loan payment given the rate, number of periods, and the present value of the loan
52
Rate
Interest rate
53
Num_Periods
number of years multiplied by payments per year
54
Present_Value
The amount of the Loan
55
Aggregate Function
Preforms a calculation on en entire column of data and returns a single value
56
Total Row
Displays the results of the aggregate function as the last row in Datasheet view of the table
57
Totals Query
Contains additional row in the query design grid, and is used to display aggregate data when the query is run
58
Grouping
Summarizes data in a query by the grouping of a field
59
Form
A database object used to add or edit data in a table
60
Record Source
Table or query that supplies the records for a form or report
61
Controls
Text boxes, buttons, labels, or other tools one uses to add or edit the data in a report
62
Form View
User interface primarily used for data entry
63
Layout View
Enables user to make changes to the layout while viewing the data in a form
64
Design View
enables user to change advanced design settings that aren't available in Layout view
65
Split Form
Combines two views of the same record source
66
Multiple Items Form
Displays multiple records in a tabular layout similar to datasheet view
67
Report
Document that displays information from a database in a format that outputs meaningful information to its readers
68
Report Wizard
Series of steps to generate a customized report quickly and easily
69
Report View
View a report in a continuous page layout

Business 140 (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions