Study sets matching "access computer apps"

Study sets
Classes
Users

Study sets matching "access computer apps"

8 terms
Access Computer Apps CCHS
Sort and Store Data
Query
Database
Tables, Reports, Forms, and queries
What are some of the main task that databases help users with.
A ____ are questions that databases answer
A _____ is a collection of organized data
What are the components of a database
Sort and Store Data
What are some of the main task that databases help users with.
Query
A ____ are questions that databases answer
Computer Apps Access
design view
records
fields
primary key
used to create a table or to modify the structure of a table
rows in the table
a specific piece of information about a given product or event
a unique identifier
design view
used to create a table or to modify the structure of a table
records
rows in the table
25 terms
Access Quiz - Computer Apps
What is the heart of Access?
Name 2 types of items that are listed…
Access is fully functional to interact…
What is Access's purpose?
Tables
Title & Get rid of ID
Word
To organize a group of items or data
What is the heart of Access?
Tables
Name 2 types of items that are listed…
Title & Get rid of ID
35 terms
Computer Apps: Introduction to Access
database management system
record
Auto number
text
Access is a _______ _________ __________
A(n)________________ contains information about a given perso…
A field with the _____________ data type can store a unique s…
A field whose data type is ____________ contain any characters.
database management system
Access is a _______ _________ __________
record
A(n)________________ contains information about a given perso…
21 terms
Computer Apps Spring Final Access
What does DBMS stand for?
What database object resembles a works…
What is an entry?
Click _____ for a step-by-step guide t…
database manage system
table
data entered into a field
table wizard
What does DBMS stand for?
database manage system
What database object resembles a works…
table
49 terms
Computer Apps: Access
table
query
field
record
a collection of records for a single subject, such as all the…
a subset of data from one or more tables
a category of info in a table, such as a company name
a group of related fields for one item, such as all info for…
table
a collection of records for a single subject, such as all the…
query
a subset of data from one or more tables
27 terms
Computer apps access +pp.
Compact and repair
Database
Data sheet view
Design view
Reduces the size of the database, and repairs any corruptions…
Consists of one or more tables to store data, one or more for…
View of database in a sheet
A view in which new database objects are created
Compact and repair
Reduces the size of the database, and repairs any corruptions…
Database
Consists of one or more tables to store data, one or more for…
18 terms
Access - Computer Apps
tables
ID, Title ( grouping, sorting, layout)
Excel (Word, Powerpoint, outlook)
to store data; a collection of info
what is the heart of access
name two types of items that are listed in the report wizard…
Access is fully functional to interact with what programs? (l…
what is the purpose of access
tables
what is the heart of access
ID, Title ( grouping, sorting, layout)
name two types of items that are listed in the report wizard…
10 terms
Computer app - office access
Active cell
Auto fill
Fill handle
Formula
the current cell in a worksheet. It is indicated by a dark bo…
A feature that enables you to crop the contents of a cell or…
A small black square at the bottom-right corner of a cell use…
A combination of cell references, operations, values and /or…
Active cell
the current cell in a worksheet. It is indicated by a dark bo…
Auto fill
A feature that enables you to crop the contents of a cell or…
23 terms
Computer Apps Access 1
Relational database
primary key
navigation pane
Access work area
collection of tables, each of whom contain info on a certain…
unique identifier
list of all the objects in a database, used to open an object
used to work on tables, forms, and reports
Relational database
collection of tables, each of whom contain info on a certain…
primary key
unique identifier
41 terms
Computer Apps - Access Test
Define database management system
define Records
BTW: Naming fields
Naming tables and fields
*A software that allows you to use a computer to create a dat…
Rows in the tables.
Access has a number of reserved words that have a special mea…
Names can be up to 64 characters in length
Define database management system
*A software that allows you to use a computer to create a dat…
define Records
Rows in the tables.
35 terms
Computer Apps: Introduction to Access
database management system
record
Auto number
text
Access is a _______ _________ __________
A(n)________________ contains information about a given perso…
A field with the _____________ data type can store a unique s…
A field whose data type is ____________ contain any characters.
database management system
Access is a _______ _________ __________
record
A(n)________________ contains information about a given perso…
computer apps - access
data base
sort
query
table
collection of data on a particular topic
arrange in ascending or descending order
stored set of instructions regarding displaying or changing d…
the basic structure underlining a relational database, contai…
data base
collection of data on a particular topic
sort
arrange in ascending or descending order
13 terms
Chapter 2 Access- Computer Apps
Queries
Criterion
Wildcard
Parameter Query
set of questions
condition that the records to be included in the query must s…
symbols that represent any character or combination of charac…
query that prompts for input whenever it is used; use an [ent…
Queries
set of questions
Criterion
condition that the records to be included in the query must s…
Computer Apps Access Chapter 2
Join
Primary Key Field
Design View
Primary Table
In Access, one table can be related to another, which is gene…
A database table can contain a foreign key field and this typ…
Open a table, click the View button on the HOME tab, and the…
In a one-to-many relationship, the table containing the "one"…
Join
In Access, one table can be related to another, which is gene…
Primary Key Field
A database table can contain a foreign key field and this typ…
Computer Apps Access Chapter 1
Blank Desktop Database Template
Quick Access Toolbar
Navigation Pane
Datasheet View
Click this template at the Access 2013 opening screen to crea…
This toolbar contains buttons for commonly used commands.
This displays the name of objects within a database grouped b…
When you open a table, it displays in this view.
Blank Desktop Database Template
Click this template at the Access 2013 opening screen to crea…
Quick Access Toolbar
This toolbar contains buttons for commonly used commands.
Computer Apps Access Chapter 2
Design Grid
Text Data
Wildcards
Parameter Query
The portion of the window where you specify fields and criter…
Data in a field whose data type is short text
Symbols that represent any character or combination of charac…
A query that prompts for input whenever it is used
Design Grid
The portion of the window where you specify fields and criter…
Text Data
Data in a field whose data type is short text
Computer Apps Access Chapter 3
Create Tab
Show Table Dialog Box
Criteria row
Return
The Query Design button is located in the Queries group on th…
Click the Query Design button and the query window displays w…
To establish a criterion for a query, click on this row in th…
This is the term used for the results of the query.
Create Tab
The Query Design button is located in the Queries group on th…
Show Table Dialog Box
Click the Query Design button and the query window displays w…
Computer apps exam review- access
Objects that contain all of the data i…
Specific piece or category of data
Spreadsheet-like grid that displays fi…
Not a typical benefit of relational da…
Tables
Field
Data sheet
Auto correction of data as it's entered
Objects that contain all of the data i…
Tables
Specific piece or category of data
Field
Computer Apps Exam Review (Access)
collection of objects that work togeth…
all database objects are based on
database store fields and row in
opens on the left side of the access w…
Database
Tables
Columns and Rows
Navigation pane
collection of objects that work togeth…
Database
all database objects are based on
Tables
9 terms
Access Unit A Computer Apps 1
table
query
form
report
building block of a database, stores data. A Collection of re…
selects a subset of data from tables, a question
data entry screen
a professional printout of data
table
building block of a database, stores data. A Collection of re…
query
selects a subset of data from tables, a question
19 terms
Computer Apps. Access Ch. 3&4
memo date type
monetary means
The three dots on the right is
Query means
by default the formatting is plain text
money so currency data type
the build button when starting Input Mask Wizard
to ask a question
memo date type
by default the formatting is plain text
monetary means
money so currency data type
Micro Computer Apps Access Tutorial 2
Address Quick Start selection
Caption property
Cascade Delete Related Records Option
Cascade Update Related Fields option
The Quick Start Selection that adds a collection of fields re…
A field property that specifies how the field name is display…
An option you can set to enforce the referential integrity ru…
An option you can set to enforce the referential integrity ru…
Address Quick Start selection
The Quick Start Selection that adds a collection of fields re…
Caption property
A field property that specifies how the field name is display…
Computer Apps ll - Access Quiz 1
Database object
Primary key
Form
Database
A table, query, form, or report used to store and manage data…
A unique identifier for each record in a table
Allows you to view fields for only one record at a time
Collection of data, or information, related to a specific sub…
Database object
A table, query, form, or report used to store and manage data…
Primary key
A unique identifier for each record in a table
Computer Apps II. Terms (Set B) (Access terms/features)
primary keys
foreign keys
navigation pane
document tabs
A primary key is a unique identifier for a database record.
another table's primary key
list containing every object in your database. For easier vie…
all of the tabs that are currently open; you will use this to…
primary keys
A primary key is a unique identifier for a database record.
foreign keys
another table's primary key
Computer Apps
Border
Contextual Tab
Gallery
Home Page
A line around the edges of a cell
A tab that appears on the Ribbon only when you select certain…
A list of options available for a command
The first page that opens when you start your browser
Border
A line around the edges of a cell
Contextual Tab
A tab that appears on the Ribbon only when you select certain…
Computer apps
bit
byte
kilobyte
megabyte
Smallest unit of data, had a single binary value, either 0 or 1
a byte is 8 bits
A Kilobyte is 1,000 bytes.
A Megabyte is ... 1,000,000 bytes ... 1000 kilobytes
bit
Smallest unit of data, had a single binary value, either 0 or 1
byte
a byte is 8 bits
62 terms
Computer Apps - Word
Shift - Enter
CTRL A
CTRL B
CTRL I
force Word to Single Space
select everything
bold
italics
Shift - Enter
force Word to Single Space
CTRL A
select everything
9 terms
computer apps
Hardware
Software
Desktop computer
Memory
Physical elements- Keyboard,mouse, etc.
instructions of programs- Database, spreadsheet, etc.
Ground to a desk
External (auxiliary) Internal (can't hold all of the memory n…
Hardware
Physical elements- Keyboard,mouse, etc.
Software
instructions of programs- Database, spreadsheet, etc.
74 terms
Computer Apps
Digital Literacy
Computer
Types of Computers
Desktop
having current knowledge and understandment of technology so…
an electronic device that operates under the control of instr…
laptop, desktop, tablet
designed to be in a stationary location (all-in-one and stand…
Digital Literacy
having current knowledge and understandment of technology so…
Computer
an electronic device that operates under the control of instr…
30 terms
computer apps
computer
input
output
process
any device that has input, output, process, and storage
The process of putting data into a computer.
The process of data coming out of the computer
The "thinking" of the computer
computer
any device that has input, output, process, and storage
input
The process of putting data into a computer.
20 terms
Computer Apps
Application
Browser
Cloud storage
Data
Programs designed to make users more productive, or assist th…
Software that enables users to access and view webpages
Internet services that provides storage to computer users
Collection of unprocessed items
Application
Programs designed to make users more productive, or assist th…
Browser
Software that enables users to access and view webpages
16 terms
Computer Apps
Backstage view
Copy
Cut
Dialog box launcher
Display that includes commands related to common file activit…
Duplicates a selection from the original location and places…
Removes a selection from the original location and places it…
An icon in Ribbon groups that you can click to open a related…
Backstage view
Display that includes commands related to common file activit…
Copy
Duplicates a selection from the original location and places…
25 terms
computer apps
Ctrl + c
Ctrl+x
Ctrl + v
Ctrl + Z
Copies highlighted selection
Cuts, removes the highlighted selection
Paste. inserts copied selection
Undoes last command
Ctrl + c
Copies highlighted selection
Ctrl+x
Cuts, removes the highlighted selection
10 terms
Computer Apps
Bit
Byte
American standard code for information…
Memory(RAM)
is short for binary digit, and is one digit---1 or 0
is 8 bits grouped together as a unit. A combination of 0s and…
The ASCII is the the widely used coding scheme used to repres…
consist of one or more chips on the motherboard or some other…
Bit
is short for binary digit, and is one digit---1 or 0
Byte
is 8 bits grouped together as a unit. A combination of 0s and…
21 terms
Computer Apps
access key
Command Button
Contextual Tab
Default button
A Key that is indicated by the underlined characters in a Com…
An element in a dialog box that initiates an action when clic…
A tab added to the Ribbon for certain activities
The button displayed with a thicker borderwhen a dialog's fir…
access key
A Key that is indicated by the underlined characters in a Com…
Command Button
An element in a dialog box that initiates an action when clic…
Computer apps
Grace Hopper
Mark 1
Jack Kilby
Integrated Circuit
• programmer for the mark 1... • pioneer in computer programming…
• relay based calculator... • Harvard Howard Aiken... • 51 feet lon…
• designed an integrated circuit ... • used silicon- a conductor…
• same power but much smaller
Grace Hopper
• programmer for the mark 1... • pioneer in computer programming…
Mark 1
• relay based calculator... • Harvard Howard Aiken... • 51 feet lon…
Computer apps
File-Save As
Word processor
Portrait and lanscape
Insert Tab
To save a document use this
electronic tool for writing an easy edit documents
Page Layout tab
Clip art, word, art and tables
File-Save As
To save a document use this
Word processor
electronic tool for writing an easy edit documents
6 terms
computer apps
file save as
electronic tool for writing
easily edit documents
page layout tab
t save a document in Microsoft programs
a word processor
an advantage of a word processor
portrait and landscape is found in a
file save as
t save a document in Microsoft programs
electronic tool for writing
a word processor
Computer Apps
Buisness Forms 3 Main Types
1.) Memos
2.) Letters
3.) Reports
...
Short internal business note
Formal communication outside the business
Formal communication outside or inside the business
Buisness Forms 3 Main Types
...
1.) Memos
Short internal business note
10 terms
computer apps
operating system
patrts of a computer
GUI
cloud
system software that manages computer hardware and software r…
screen ... keyboard ... storgage ... memory... cpu... mouse/trackpad... input/o…
graphical user interface
software and services that run on the internet instead of loc…
operating system
system software that manages computer hardware and software r…
patrts of a computer
screen ... keyboard ... storgage ... memory... cpu... mouse/trackpad... input/o…
15 terms
Computer Apps.
All capital letters
Bold
case of letter
Decrease font size
CTRL+SHIFT+A
CTRL+B
SHIFT+F3
Ctrl+shift+<
All capital letters
CTRL+SHIFT+A
Bold
CTRL+B
10 terms
computer apps
Layout
Notes master
Placeholders
Slide content
arrangement of objects on a slide.
a master slide that changes the formatting of the notes page
container on a slide that hold texts and other contents
text, graphics, and other objects on a slide
Layout
arrangement of objects on a slide.
Notes master
a master slide that changes the formatting of the notes page
11 terms
Computer Apps
Absolute Cell Reference
Amortization
Arguments
Average
A cell reference thats not changed when copied
A method for computing equal periodic payments for an install…
The data required by a function
A function that adds the values in range of cells and then di…
Absolute Cell Reference
A cell reference thats not changed when copied
Amortization
A method for computing equal periodic payments for an install…
11 terms
Computer Apps
Insert Mode
WordWrap
Hanging indent
MLA
Default typing mode in word
Allows you to type words in a paragraph continually
The first line of each entry begins at the left margin
A documentation style used in a wide range of disciplines
Insert Mode
Default typing mode in word
WordWrap
Allows you to type words in a paragraph continually
56 terms
computer apps
Operating System
Interent
ISP
Workstations
(computer science) software that controls the execution of co…
globally connected computer networks that uses routers, IP ad…
Internet Service Provider
___ is a personal computer in a network used to run applicati…
Operating System
(computer science) software that controls the execution of co…
Interent
globally connected computer networks that uses routers, IP ad…
80 terms
Computer Apps.
Internet Safety
Digital Citizenship
Home Row
URL
very important rules and awareness regarding dangers of the i…
Navigating the digital world safely, responsibly, and ethical…
Keys on the keyboard with fingers of the left hand are on A-S…
(Uniform Resource Locator) Basically the web address of a web…
Internet Safety
very important rules and awareness regarding dangers of the i…
Digital Citizenship
Navigating the digital world safely, responsibly, and ethical…
90 terms
Computer apps
Alt (Alternate Key)
Backspace Key
Caps Lock Key
Central Processing Unit (CPU)
is used with other function keys to access software options
moves the cursor to the left (backward) one space at time. Th…
is used to key all capital letters
stores the disk operating system (DOS) and hard drive... heart o…
Alt (Alternate Key)
is used with other function keys to access software options
Backspace Key
moves the cursor to the left (backward) one space at time. Th…
Computer apps
Spread Sheet
Worksheet
Workbook
Column
A computer Program used to perform calculations and analyze a…
A single sheet within a workbook file made up of a grid of co…
A collection of related worksheets
Appear vertically and are identified by letters at the top
Spread Sheet
A computer Program used to perform calculations and analyze a…
Worksheet
A single sheet within a workbook file made up of a grid of co…
48 terms
Computer apps
Daddy long legs
The Sumerians
2
775 rooms
Which spider has the most venom?
Which civilization was responsible for the wheel?
How many moons does mars have?
How many rooms are in the Buckingham Palace?
Daddy long legs
Which spider has the most venom?
The Sumerians
Which civilization was responsible for the wheel?
1 of 10