Send the link below via email or IMCopy
Present to your audienceStart 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
Transcript of MS ACCESS
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
is a collection of related information.
is a competition in the database such as a table, query, form, or macro.
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.
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.
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.
provides the tools for creating fields in a table.
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.
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.
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.
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