Com Sci Final Exam

If you sorted a table which had 53 records by two fields, one ascending and the other descending, how many records would display?

53

Comparison operators

<>, =, >, <

Examples of filter criterion.

<>4, >2000, ="Fred"

Which of the following is not a valid comparison operator?

=>

Sort

A method of listing records in a specific sequence (such as alphabetically); Listing records in a specific sequence; Changes the order of how records are displayed.

What is the difference between a Selection filter and a Filter By Form?

A Selection filter lets you filter records by a single field while Filter by Form lets you filter records based on multiple criteria.

Database

A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported.

Relationship

A connection between two tables using a common filed; A connection between tables using a common field.

ACCDE

A database format that only allows data entry.

What is the purpose of creating a filter?

A filter enables you to view a subset of records based on specified criteria.

Selection Filter

A filtering method that displays only records that match selected criteria; A way of limiting the number of records displayed.

Filter by Form

A filtering method that displays records based on multiple criteria.

Datasheet View

A grid that enables you to add, edit, and delete the records of a table.

What is SharePoint?

A host server

What is the most important thing you need if you are going to create a Web app?

A host server

Object

A main component that is created and used to make a database function, such as a table or form; A component which makes the database function.

Field

A piece of information stored in a table, such as a company name or city; Category of information.

Template

A predefined database that includes professionally designed tables, forms, reports, and other objects; Used to jumpstart your database.

Query

A question you ask about the data in your database; Asks a question of your data.

Application Part

A set of common Access components that can be added to an existing database.

Database Management System (DBMS)

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

Macro

A stored set of commands.

Compact and Repair Database

A utility that makes a database smaller and fixes errors.

Boolean operators

AND, OR, NOT

DBMS

Access is one example.

Navigation Pane

An Access interface element that organizes and lists database objects in a database; An interface that lists Access objects.

Form

An Access object that simplifies entering, modifying, and deleting table data; Using this is the normal way of entering data.

Module

An advanced object within VBA.

If you want to add a component to an existing database (such as Contacts table), what would you use?

An application part enables you to add a set of common Access components to your database, such as a table, a form, and a report for a related task.

Report

An object that contains professional-looking formatted information from underlying tables or queries; An object which displays formatted information in a professional manner; A way of displaying data in which the data cannot be changed.

Table

An object used to store data, organizing data into columns and rows; The object which actually stores the data; Stores all your data.

Which of the following would be matched if you use a Selection filter's exact match option for the name Ann?

Ann, ANN, and ann

To add a predefined table into an exiting database, you should use which of the following?

Application Part

How does Access handle saving differently than other Office programs such as Excel?

As you enter and update the data in an Access database, the changes are automatically saved in the storage location you specified when you saved the database rather than working from memory as Excel does.

Examples of Data Types.

AutoNumber, Short Text, Number

Which of the following utilities is used to recover in the event of loss or damage?

Back Up Database

To create a database from a template you would use which view?

Backstage

Which of the following is true regarding table views?

Changes made in Datasheet view are automatically saved when you move the insertion point to a different record.

What is a comparison operator and how it used in a filter?

Comparison operators can be used to evaluate the relationship between two quantities. A comparison operator can be used in a filter to determine if two quantities are equal, not equal, greater than, less than, greater than or equal to, or less than or equal to.

Record

Complete set of all the fields about one person, place, event, or concept; Complete set of fields; A complete collection of all fields about one entity.

Could be used in a selection filter

Contains "Bill"

Which of the following is not one of the three methods for creating a database?

Create a blank cloud database

Filter

Enables you to specify conditions to display only those records that meet certain conditions.

Which of the following conditions is available through a Selection filter?

Equal condition

Which of the following is not true of an Access database?

Every table in a database contains the same number of records as every other table.

As long as your data is accurate there is no real need to print preview your reports.

False

Using a template to create a database is not an effective use of time because of all the modifications you need to make so the database will fit your needs.

False

Using the Back Up Database utility only saves the structure of the database, not the content.

False

You can only sort records by one field.

False

Your birthday would be a good candidate for a primary key.

False

Which of the following objects is an example of an Access object?

Form

Examples of field names.

LastName, FirstName, CellPhone.

A more advanced DBMS.

Oracle

You edit several records in an Access table. When should you execute the save command?

Records are saved automatically; the save command is not required

Examples of Primary keys.

Social Security Number, Student ID, AutoNumber.

How would you sort or filter records in a field that begins with both numbers and letters so that the records which begin with numbers appear before the records that begin with letters?

Sort ascending

What are the benefits of sorting records in a table?

Sorting enables you to list records in a specific sequence, such as alphabetically by last name, making information easier to locate and organizing the information.

Objects open in their own area under the Ribbon.

Tabbed Documents interface

Where is data in a database stored?

Table

Name the four main types of objects in an Access database and briefly describe the purpose of each.

Tables store the data in the database. Queries are used to display only records that meet certain conditions and only the fields that you require. Forms give the user a way of entering data into the database. Reports enable the user to present professional-looking information from tables or queries

What is the difference between Datasheet view and Design view in a table?

The Datasheet view is a grid containing columns (fields) and rows (records), similar to an Excel spreadsheet in which the user can view, add, edit, and delete. The Design view gives the user a detailed view of the table's structure and is used to create and modify a table's design by specifying the fields it will contain, the fields' data types, and their associated properties.

How do relationships benefit a database user?

The benefit of a relationship is the ability to efficiently combine data from related tables for the purpose of creating queries, forms, and reports.

Primary Key

The field (or combination of fields) that uniquely identifies each record in a table; Uniquely identifies a record; That which uniquely identifies records in a table.

All of the following statements are true about creating a database except:

The objects provided in a template cannot be modified.

A good practice is to make backups of your databases on different storage devices.

True

A primary key can be a combination of several fields.

True

Creating a database from a template can help you get started more quickly.

True

Filters do not delete data or records.

True

If you see plus signs (+) next to records in Datasheet view then you know that two or more tables are related.

True

Reports can draw data from tables or queries.

True

Using Filter by Form enables you to filter on multiple criteria.

True

Using the Compact and Repair Database utility on a regular basis is good practice.

True

SQL

Used in several database programs.

VBA

Used to create modules.

Which method of creating a database demands the least amount of expertise in Access?

Using a template

What are two benefits of using a template to create a database?

Using a template saves time because it jumpstarts database creation. It also helps a new Access user become familiar with database design.

Examples of field properties.

Validation Rule, Field Size, Caption

Design View

View that enables you to create and modify a table design.

RAM

Where most Office programs store their files while the user is working.

One reason to begin with a template is that you do not have to .................

create as many objects

To move a field you ................

left-click the column heading, then drag the field to where you want it