COMPUTER -LEARN TO USE MS ACCESS 2003

COMPUTER PROJECT : 

COMPUTER PROJECT TOPIC:LEARN TO USE MS ACCESS 2003 BY:Pranav

DATABASE OBJECTS: 

DATABASE OBJECTS In Access , all objects of a database are stored in a single file. The file name has MDB (Microsoft Date Base) as extension . All objects are managed through the database window . They are discussed below:

1. Table: 

1. Table Tables are the part of the database where the actual data is stored. Access stores the related entries in its row. This row is called a record. Each type of detail on a record is stored in its columns know as fields .

2.Query: 

2.Query A query is used to extract information from a database. It is a record or a group of record that fulfills a certain condition. An example of a query is to-get the record of the student with roll ni.32.

3.Forms: 

3.Forms All the data that is entered into the database ends up in a table for storage. Any information can be entered directly into a table. Most people find it easier to create a special onscreen form to enter data. A form resembles a fill-in-the-blanks sheet that you would complete by hand. Access link stores the information that you put in a form into the table.

4.Reports: 

4.Reports Just as forms are designed to be on screen , reports are designed to be printed. With access , one can design reports quickly , based on the data.

STARTING MS ACCESS 2003: 

STARTING MS ACCESS 2003 YOU CAN SEE IT 3D

CREATING AN ACCESS DATABASE: 

The database in access consists of different tables. These tables contain records. The data is stored in tables in the form of records . The collection of tables constitutes a database. cont….. CREATING AN ACCESS DATABASE

PowerPoint Presentation: 

Before you create a database in Access , you must have the following things: The purpose of the database. The user of the database. The table (table)of the database. The queries and reports that the users of this database. The queries and reports that the users of this database need. The forms you need to create.

h: 

Microsoft Access provides three methods to create a database in Access: Creating a blank or empty database. Using the database Wizard. Using a template. h