Bis 245 final - Study guides, Class notes & Summaries

BIS 245 Final Exam Study Guide With Complete Solutions

BIS 245 Final Exam Study Guide

Fields  the smallest data element of a table, such as first name, last name, address, or phone number. Records  a group of related fields representing one entity, such as data for one person, place, event, or concept. Tables  An object used to store and organize data in a series of records (rows) with each record made up of a number of fields (columns) and is the foundation of every database. Databases  A collection of data organized as meaningful information that can ...

BIS-245 Final Exam 1. 1.Question : (TCO 1) Which object would you use to enter, delete, or modify data? Student Answer: Criteria Form Query Instructor Explanation: Table Chapter 1: Microsoft Access 2010 Comprehensive 2. Question : (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? Student Answer: Criteria Form Query Instructor Explanation: Table Chapter 1: Microsoft Acces...

BIS-245 Final Exam 1. 1.Question : (TCO 1) Which object would you use to enter, delete, or modify data? Student Answer: Criteria Form Query Instructor Explanation: Table Chapter 1: Microsoft Access 2010 Comprehensive 2. Question : (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? Student Answer: Criteria Form Query Instructor Explanation: Table Chapter 1: Microsoft Acce...

BIS 245 Final Exam Study Guide Fields - ANS the smallest data element of a table, such as first name, last name, address, or phone number. Records - ANS a group of related fields representing one entity, such as data for one person, place, event, or concept. Tables - ANS An object used to store and organize data in a series of records (rows) with each record made up of a number of fields (columns) and is the foundation of every database. Databases - ANS A collection of data o...

BIS-245 Final Exam 1. 1.Question : (TCO 1) Which object would you use to enter, delete, or modify data? Student Answer: Criteria Form Query Instructor Explanation: Table Chapter 1: Microsoft Access 2010 Comprehensive 2. Question : (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? Student Answer:

Fields Correct Answer the smallest data element of a table, such as first name, last name, address, or phone number. Records Correct Answer a group of related fields representing one entity, such as data for one person, place, event, or concept. Tables Correct Answer An object used to store and organize data in a series of records (rows) with each record made up of a number of fields (columns) and is the foundation of every database. Databases Correct Answer A collection of data organiz...

BIS 245 Final Exam Answer (Updated) 1. (TCO 1) Which object would you use to enter, delete, or modify data? (Points : 5) Criteria Form Query Table Question 2. 2. (TCO 1) In a table the _____ view is where you add, edit, and delete records. (Points : 5) Design Datasheet SQL Layout Question 3. 3. (TCO 1) When creating a report in Access what report tool best outlines the following description: This report tool asks a series of questions and helps the designer create a repor...

BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago.BIS 245 A Small Surgery Center Case Study Week 3 & Week 5 |iLab Week 1-7|Quiz Week 1- 6|Discussions Week 1-7, 2 Sets|Final Exam BIS 245 A Small Surgery Center Case Study Week 3 & Week 5 Scenario A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments. 1. Please identify the attributes and p...