ICT

47問 • 1年前

Lynzey Bataller

通報

問題一覧

Provides access to miscellaneous tools and wizards.

Database tools

Contains commands used to import from or link to data in external sources or export data to external sources.

External Data

Contains commands used to create new database objects.

Create

Contains the most frequently used commands.

Home

Displays the Backstage view which contains commands related to managing files and customizing the program

File

These tabs may appear only when you are working with certain objects that belong to it.

Contextual tabs

Contains multiple tabs with several groups of commands needed in order to do common tasks.

Ribbon

Displays information about the database and provides certain program functions.

Status Bar.

Displays open database objects

Object Window

Displays a list of all the objects in a database.

Navigation Pane

Consists of a set of tabs, each of which contains groups of related command

Ribbon

Contains the frequently used commands that are independent of the tab displayed on the Ribbon

Quick Access Toolbar

Displays the name of the database and the program.

Title Bar

Provides various Access options

Options

Provides access to Microsoft Office Help

Help

Provides advanced options to save the database

Save and Publish

Contains options for print

Creates new database from scratch or from a selection of available templates.

New

Displays a more complete list of recently opened databases.

Recent

Contains information about the database

Info

Displays the last four databases recently opened.

Recently opened

Only stores the current object, not the entire database.

Save command

Offers to save, open, and close commands.

Save, Open, and Close

If you want to create a database that is compatible with earlier versions of Microsoft Access like 2007 use the extension

.mdb

A database created in Microsoft Access 2010 must have the extension

.accdb

Is a relational database program that it is usually used to create and maintain tables, queries, forms, and reports.

Microsoft Access

It can be used for a simple information management system in a small business to organize and manage data, or in an enterprise to communicate with servers.

Microsoft Access

Is a software application used to create and manage computerized databases on a single computer or on a network

Microsoft Access

DBMS systems provide mechanisms to present concurrent access of data to multiple users.

Control concurrency

When data is centralized, it is easier to maintain it than having to maintain different file systems.

Lowers development and maintenance cost

A DBMS must provide facilities for recovering from hardware or software failures. The backup and recovery subsystem of the DBMS is responsible for recovery.

Provides backup and recovery

Since many types of users with varying level of technical knowledge use a database, a DBMS should provide a variety of user interface.

Solves enterprise requirement than individual requirement

This centralized system is able to represent the complex data and interfile relationships, which results to better data modeling properties.

Develops data model

When multiple users share a database, it is likely that every user has different access type to it.

Restricts unauthorized access

A standard can be enforced easily at various levels since the standardized data is very helpful during migration or interchanging of data.

Enforces standard

In a centralized system, the applications may be developed without having to create any new stored files since the files are shared by the users.

Shares data

If redundancy is controlled in a centralized system, there is lesser chance that the data is inconsistent.

Avoid inconsistency

Some integrity constraints are enforced on the database making the integrity of data always accurate.

Enforces integrity

Each application has its own private files which cannot be shared between multiple applications.

Controls redundancy

Serves as the middle person between the programs and the data.

Database management system (DBMS)

Is basically a collection of computer programs that enables users to store, modify, and extract information based on per requirements.

Database management system (DBMS)

A field in mathematics that describes how to deal with sets of data.

Set theory

Standard industry design

Relational database

Are collections of different sets of data related to each other.

Relational database

Contains one specific category of data

Simple database

Types of Computerized database

Simple database Relational database

Is compact, flexible, and fast. It can store thousands of data without occupying too much space.

Computerized database

examen Alexandru

ユーザ名非公開 · 40問 · 8日前

examen Alexandru