Quiz 8 part 2

5. Differentiate between a file processing approach and the database approach.

File processing is the process of creating, storing and accessing content of files. For example, you are saving a word processing file to a hard drive. Similarly, if you store some files on a floppy disk or you retrieve a file from CD-Rom it is file processing. To perform file processing on an application a program is required like C++.

File processing can be used in opening saved files for read only purpose. It can be used to save a new file or displace the existing one. Through file processing you can make new files and save the existing files. You can also modify files through this process.  

Processing data allows organizations to understand what information is being held in their databases. Reporting tools allow users to create reports on specific sets of data for trending and other data identification needs.

6. Describe characteristics of relational, object-oriented, and multidimensional databases.

OBJECT ORIENTED DATABASE is a database management system in which information is represented in the form of objects as used in object-oriented programming. Object databases are a niche field within the broader database management system (DBMS) market dominated by relational database management systems. Object databases have been considered since the early 1980s and 1990s, but they have made little impact on mainstream commercial data processing, though there is some usage in specialized areas.

RELATIONAL DATABASE matches data by using common characteristics found within the data set. The resulting groups of data are organized and are much easier for many people to understand.

For example, a data set containing all the real-estate transactions in a town can be grouped by the year each transaction occurred, the sale price, a buyer's last name and so on. Such a grouping uses the relational model (a technical term for this is schema). Hence, such a database is called a "relational database."

The software used to do this grouping is called a relational database management system (RDBMS). The term "relational database" often refers to this type of software.

Relational databases are currently the predominant choice in storing data like financial records, medical records, personal information and manufacturing and logistical data.

MULTIDIMENSIONAL  DATABASE

 A multidimensional database is a form of database that is designed to make the best use of storing and utilizing data. Usually structured in order to optimize online analytical processing (OLAP) and data warehousemultidimensional database can receive data from a variety of relational databases and structure the information into categories and sections that can be accessed in a number of different ways. Even persons who have relatively little experience working with a database often find that a multidimensional database, or MDB, requires only a short time to master. applications, the

While just about every relational database is structured for keyword searches and building a query by specifying fields and perimeters, the multidimensional database goes one step further. Rather then building a query, a user simply poses the question in everyday verbiage. This approach is used with several online help tools associated with software programs such as word processing and spreadsheet applications, as well as several of the more popular search engines currently in use.

7. Explain how to access Web databases.

Exporting Data from Microsoft Access 2007 to Microsoft Excel

It’s often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel’s unique analytical capabilities or simply share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward and quick.

View and Edit SQL in Microsoft Access

Did you know that you can view and edit the SQL statements that drive every Microsoft Access database query? In this article, we take a look at the process of accessing the underlying SQL code and tweaking it to perfect Access queries.

Compact and Repair an Access Database

Over time, Microsoft Access databases grow in size and unnecessarily use disk space. Additionally, repeated modifications to the database file may result in data corruption. Therefore, it's a good idea to periodically run the compact and repair database tool to ensure the consistency of your data.

Collecting Information for an Access Database by E-mail

Microsoft Access allows you to collect information from individuals and update your database automatically based upon their replies. Access includes a wizard designed to facilitate this task. In this tutorial, we walk through the process of populating an Access table with user-provided information.

Add a Date or Time Stamp to an Access Database Table

There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It’s easy to do this in Microsoft Access 2010 using the Now() function. In this tutorial, I explain the process step-by-step.

Add a Date or Time Stamp to an Access Database Table

There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It’s easy to do this in Microsoft Access using the Now() function. In this tutorial, I explain the process step-by-step.

Include Attachments in an Access Database

Microsoft Access allows you to include attachments in database tables. You may store photos, graphics, documents and other files in your Access database using Microsoft's Object Linking and Embedding (OLE) technology. Database attachments are a new feature in Access 2007.

Show or Hide Tabs in Microsoft Access 2007

Access 2007 introduces the tabbed document format found in other Microsoft Office products. In some cases, you may wish to hide these tabs to change the look and feel of your database or more closely simulate the appearance of older versions of Access.

Create an Adobe PDF File From an Access 2007 Database

Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access database.

Back Up a Microsoft Access Database

Backing up your Microsoft Access databases is an important part of protecting your critical data. In this tutorial, we walk through the process of backing up an Access database, step-by-ste.

The Quick Access Toolbar provides you with immediate access to commonly used functions in Microsoft Access 2007. In this tutorial, we explore the process of adding your own favorite icons to the Quick Access toolbar, step-by-step.

Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry situation. If you’re working with users you don’t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we’ll walk through the process of creating an Access form.

The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet. In this tutorial, we’ll walk through the process of creating a relationship between two tables in an Access database.

In an earlier article, we reviewed the process for creating an Access database from a template. While this is certainly an agreeable, easy approach to building a database, there isn’t always a template available that meets your needs. In this article, we review the process for creating an Access database from scratch.

Microsoft provides quite a few prebuilt database templates to assist you in jumpstarting your database development process. In this tutorial, we'll walk through the process of creating an Access database using these templates.

Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of encrypting your database and protecting with a password, step by step.

Have trouble remembering function names or arguments in Microsoft Access? We all do! Access' Expression Builder is a great tool that walks you through the process of creating expressions for your forms, tables, reports and queries while keeping a handy reference at your fingertips.

Change the Default Database Format in Access 2007

Access 2007 uses the ACCDB format by default. In this article, we walk you through the process of changing this default setting for newly created databases.

Access 2007 uses the ACCDB format by default. In this article, we walk you through the process of changing this default setting for newly created databases.

The ACCDB database format introduced in Access 2007 provides a number of enhanced features over the older MDB format. In this article, we'll walk you through the process of converting an MDB format database to the new ACCDB format.

The ACCDB database format introduced in Access 2007 provides a number of enhanced features over the older MDB format. In this article, we'll walk you through the process of converting an MDB format database to the new ACCDB format.

Are you ready to convert your unwieldy Excel spreadsheet to a flexible Access database? Let us walk you through the process!

Are you ready to convert your unwieldy Excel spreadsheet to a flexible Access database? Let us walk you through the process!

Report snapshots offer a portable format that can be used to view Access reports on systems that don't have Microsoft Access installed. It's available for most versions of Windows and allows you to share reports via e-mail, the web or automated processes.

Have trouble remembering function names or arguments in Microsoft Access? We all do! Access' Expression Builder is a great tool that walks you through the process of creating expressions for your forms, tables, reports and queries while keeping a handy reference at your fingertips.

One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.

One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.

Oftentimes, you wish to share data with users in your organization who may, in turn, wish to create their own forms and reports. While you may want them to have the ability to view and/or update your data, you may not wish them to modify the interface you use to work with the data yourself. Fortunately, Microsoft Access provides the ability to...

Oftentimes, you wish to share data with users in your organization who may, in turn, wish to create their own forms and reports. While you may want them to have the ability to view and/or update your data, you may not wish them to modify the interface you use to work with the data yourself. Fortunately, Microsoft Access provides the ability to split a database into front-end and back-end components. You can safely share data with other users while keeping your interface private.

Create an Adobe PDF File From an Access Database

Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access database.

Backing up an Access Database

I've often been asked "How do I create a backup of my Access database?" Until now, that's been a difficult question to answer. Prior to Access 2003, you would have to manually copy your Access .MDB files into a secure storage location. 

Backing up an Access Database

I've often been asked "How do I create a backup of my Access database?" Until now, that's been a difficult question to answer. Prior to Access 2003, you would have to manually copy your Access .MDB files into a secure storage location. That's all changed with Access 2003. 

How To Install Microsoft Access

Due to its widespread availability and flexible functionality, Microsoft Access is arguably the most popular database software in use today. In this "How To", we explain the Access installation process in a straightforward manner.

Creating Forms in Microsoft Access

Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

Designing Data Access Pages

Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process.

Creating Dynamic Web Pages with Microsoft Access

Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Publishing Access Data on the Web

Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.

Creating a Form in Microsoft Access

Forms offer a quick and easy way to offer a graphical data environment to users of your database. Follow along as your About.com Guide to Databases creates a simple form in Microsoft Access.

Creating a Report in Microsoft Access

Would you like to create professional-looking reports from your Microsoft Access database with the click of a mouse? Follow along as we walk through the simple process of designing a reusable report.

Creating a Simple Query in Microsoft Access

Microsoft Access offers a powerful query function that allows you to extract information from your database. In this tutorial your About.com Guide to Databases walks you through the creation of a simple query.

Creating Dynamic Web Pages with Microsoft Access

Do your web users need real-time access to the information contained within your database? Server-generated HTML might be just the solution you need.

Creating Relationships in Microsoft Access

Microsoft Access offers powerful relationship functionality. This step-by-step illustrated tutorial walks you through the relationship creation process.

Data Access Pages

Data Access Pages provide Microsoft Access 2000 users with a powerful tool for viewing and manipulating database information through the web.

Exporting Access Tables to Excel

Microsoft Access allows you to export data to a variety of formats for sharing and analysis. In this tutorial, we walk through the process of exporting an Access table to an Excel workbook.

Fundamentals of Microsoft Access

Not sure if your organization needs a database? Your About.com Guide to Databases provides an overview of database concepts as well as the fundamental components of Microsoft Access.

Modifying a Query in Microsoft Access

Learn how to apply advanced techniques to refine your database queries. Your About.com Guide to Databases provides an introduction to adding and removing fields, adding query criteria and sorting your results.

How To Export Data from Microsoft Access 2010 to Microsoft Excel

It’s often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel’s unique analytical capabilities or simply share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward and quick.

How To Show or Hide Tabs in Microsoft Access 2010

Access 2010 uses the tabbed document format found in other Microsoft Office products. In some cases, you may wish to hide these tabs to change the look and feel of your database or more closely simulate the appearance of older versions of Access.

How To Create an Adobe PDF File From an Access 2010 Database

Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access database.

Creating Forms in Microsoft Access 2010

Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry.

Creating Relationships in Microsoft Access 2010

The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet. 

Creating an Access 2010 Database from Scratch

In an earlier article, we reviewed the process for creating an Access database from a template. While this is certainly an agreeable, easy approach to building a database, there isn’t always a template available that meets your needs. In this article, we review the process for creating an Access database from scratch.

Create a Microsoft Access 2010 Database Using a Template

Microsoft provides quite a few prebuilt database templates to assist you in jumpstarting your database development process. In this tutorial, we'll walk through the process of creating an Access database using these templates.

Password Protecting an Access 2010 Database

Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of encrypting your database and protecting with a password, step by step.

Converting an Access Database to SQL Server

Is your Access database growing too large or unwieldy? Perhaps you need to allow more robust multiuser access to the database? Converting your Access database to Microsoft SQL Server might be the solution you’re trying to find. Fortunately, Microsoft provides an Upsizing Wizard in Access that makes it easy to convert your database.

8. Define the term, computer security risks, and briefly describe the typesof cybercrime perpetrators: hacker, cracker, script kiddie, corporate spy,unethical employee, cyberextortionist, and cyberterrorist.

9. Identify database design guidelines and discuss the responsibilities ofdatabase analysts and administrators.

10. Discuss techniques to prevent unauthorized computer access and use