Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

MS ACCESS

No description
by

Reina Rose Narciso

on 22 June 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of MS ACCESS

Setting up your own database
MS Access 2007 Training
The key to your decision: Is the data relational or not?
MS Access 2007 Database, Why Choose it?
Indications that your data is relational:
your data needs to be stored in more than one table
Getting Started
Few Terms
A
database
is a collection of related information.
An
object
is a competition in the database such as a table, query, form, or macro.
A
table
is a grouping of related data organized in fields (columns) and records (rows) on a datasheet. By using a common field in two tables, the data can be combined. Many tables can be stored in a single database.
A
field
is a column on a datasheet and defines a data type for a set of values in a table. For a mailing list table might include fields for first name, last name, address, city, state, zip code, and telephone number.
A
record
in a row on a datasheet and is a set of values defined by fields. In a mailing list table, each record would contain the data for one person as specified by the intersecting fields.
Design View
provides the tools for creating fields in a table.
Datasheet View
allows you to update, edit, and delete information from a table.
After opening Access, you will be presented with the window shown below.
Select one of the first three options if you are creating a new database, or the fourth if you want to edit an existing database.
Getting Started
Unlike Word documents, Excel worksheets, and Power Point presentations, you must save an Access database before you start working on it.

After selecting "Blank Access database", you will first be prompted to specify a location and name for the database.
Getting Started
Open an existing database
If the database was opened recently on the computer, it will be listed on the main window.

Highlight the database name and click OK. Otherwise, highlight "More Files..." in the list and click OK.

From the subsequent window, click the "Look In:" drop-down menu to find the folder where the database is located, highlight the database name in the listing and click OK.
Database Window
The Database Window organizes all of the objects in the database. The default tables listing provides links for creating tables and will list all of the tables in the database when they have been added.
Tables are grids that store information in a database similar to the way an Excel worksheet stores information in a workbook. Access provides three ways to create a table for which there are icons in the Database Window. Double-click on the icons to create a table.
Introduction to Tables
Full transcript