MS Access notes (ccc) by social guide

 

MS Access


Data base:- A data base is an organized way of storing data in the form of rows and columns. A column stores specific type of information and a row consist of a complete set of information. In data base terminology a column is called an attribute and a row is called a record or table.

 

MS Access:- Ms access is rdbms (relational data base management system) this application let you to create table for storing the data records , query to show selective data , report for taking print out of the data base and form is created to set the environment for the data entry programs according to the users choice.

      A part of this you can create web page, macro and also generate the visual basic programs and functions by taking the table at the backend of the programming language.

 

 How to start ms access

Ø  Click on start menu

Ø  Select all programs option

Ø  Select ms officeàms access

Ø  Click on create a new file

Ø  Select blank data base

Ø  Type the data base name àclick create button

Ø  Or click on start menu

Ø  Select run option

Ø  Type msaccess in dialog box

Ø  Click ok

Ø  Click on create a new file

Ø  Select blank data base

Ø  Type the data base name (any name)

Ø  Click create button.

 

                       Objects of ms access

 

Table: - table is the collection of records which smallest unit is data the enter related data sets become records and multiple record of a table.

      Field is just like the column in the table of spread sheet it also define the type of data input into the column.

There are many ways to create the table –

 

1-           Data sheet view:- this option creates the table just like the spread sheet column it is the easiest way to create the table

Ø Steps- click on create menu

Ø  Select table option

Ø  Select rename

Ø  Type the field name (new name)

Ø  Repeat last 2 steps according to your need

Ø  Click closes and save it

Ø  To input the record open the table.

 

Note: - In this table to creating field name there are no (.) or spaces are allowed .

 

2-Design view: - by this view we can create the table in which first of all we have to create the structure by giving field name, data type and description. Data type is the type of data to be inputted like number, text, currency, date & time and others.

 

Ø      Steps- click on create menu

Ø      Select table design option

Ø      Type the field name and data type

Ø      Give the description if required

Ø      Repeat last 2 steps according to your       requirement.                            

Ø      Click closes and save it.

 

Table wizard:-this is another method of table creation, but here the fields are pre defined you can select the fields according to your need from the wizard box.

 

Ø      Steps- click on create menu

Ø      Select table template option

Ø      Select the fields according to your requirement

Ø      Click closes & save it.

 

Import table: - this method creates the table by taking the data from other application it import the table from ms excel or any operator which is divided into row and column (spread sheet).

Ø   Steps- click on external data

Ø   Select  excel / access button

Ø   Click on browse button

Ø   Select your file / sheet

Ø   Click open

Ø   click ok

Ø   Click on next button until finish.

 

Query: - query is used filter the record and also you can show the record from the table on the basic of criteria and the customization of query is based on your give criteria. There are many ways to create the query.

 

Simple query:-it is used to select the record on the basic of single criteria in which you have selected the fields from the table

Ø Steps- click on create menu

Ø Select query design option

Ø A dialog box will be displayed

Ø Add the table and close it

Ø Select the fields one by one

Ø Click close & save it or press ctrl+w to save file

Ø To show the record select the table name and open it.

 

Update query: - it is used to updating the data in the table which you want to update by existing the query file.

Ø Steps- click on create menu

Ø Select query design option

Ø A dialog box will be displayed

Ø Add the table and close it

ü Select the field which you want to update

ü Click on query type box

ü Select update option

ü Type the formula like [Hindi] + [English] + [Maths]

ü Click closes and save it

ü Right click over the query name

ü Select open optionàyesàyes

ü Now open the table to see the updated result.

 

Relational query:-to establish the relation there must be some common fields in two or more tables. If these criteria are satisfied you can make relational query by establishing the relation between the tables on the basis of common fields.

 

Ø Steps- click on create menu

Ø Select query design option

Ø A dialog box will be displayed

Ø   Add the table one by one

Ø   Close the dialog box

Ø   Delete the relation from id to id by right clicking over the relational line

Ø   Drag and drop the common field over the another common field

Ø   Select the fields which you wants to display

Ø   Click closes and save it

Ø   This query will show the record of the both tables which you have selected.

 

Form:- it is the graphical representation of data it creates the data entry control objects with command buttons you can create the form automatically using the procedure like wizard and you can design the form manually with the help of control objects you can also creates the switch board items through the form for this you must create memo to assign the procedure for the command buttons.

 

Ø   Steps -select any table

Ø   Click on create menu

Ø   Select form option

Ø   add the table

Ø   Drag and drop the table over the form area

Ø   Click closes and save it.

 

Design view form:- select any table

Ø   click on create menu

Ø   Select form design option

Ø   Select the table

Ø   drag & drop it over the form area

Ø   Click closes and save it.

 

Report:-it prints the records from the table as u have designed or created through the auto report

Ø      Steps- select the table

Ø      Click on create menu

Ø      Select report

Ø      Click closes and save it

 

Report in design view:-

Ø      Click on create menu

Ø      Select report design option

Ø      Drag and drop the table over the form area

Ø      Click on finish button

Ø      Click closes and save it.

 

Macro:- Macro record the series of action which you can implement in future . With the help of macro we can make the switch board items like the shortcut of any component of access like (table, query, report etc...)

 

Ø  Steps- Click on create menu

Ø   Select form design view

Ø   Click on command button drag it over the form area

Ø   Click closes and save it.

 

Note: - you can make many command buttons according to your use.

Ø   Click on create menu

Ø   Click on macro

Ø   Give the action like open table or open form

Ø   Select your table / formàclick close and save it

Ø   Repeat last 3 steps according to your need

Ø   Open the form (where you makes the buttons)

Ø   Right click over the button àselect properties

Ø   Give the events (on mouse and on click)

Ø   Click closes and save it

Ø   Repeat last 3 steps according to your need .

 

 

       Now open the form to see the desired result .

Comments

Post a Comment

Popular posts from this blog

LibreOffice Impress Notes

                                                         File   Menu New   :- Creates   a   new   LibreOffice   document. Open :-   Opens   a   local   or   remote   file,   or   imports   one. Open   Remote :-   Opens   a   document   located   in   a   remote   file   service. Recent   Documents :-   Lists   the   most   recently   opened   files.   To   open a   file in the list,   click   its   name. Close   :-  Closes the current document without exiting the   program. Wizards :-   Guides   you   through   creating   business   and   personal   letters,   faxes,   agendas,   presentations,   and   more. Templates :-   Lets   you   organize   and   edit   your   templates,   as   well    as save   the current   file   as a   template. Reload :-   Replaces   the   current   document   with   the   last   saved   version. Versions :-   Saves   and   organizes   multiple   versions   of   the current document in the same file. You can
Read more

HTML

  HTML   HTML file Html stands for Hyper Text Markup Language an html file is text file which contain small markup tags. The markup tags tell the web browser how to display the page. An html file must have an extension .html or html.   An html file can be created by using a simple text editor like notepad and dream viewer.   Html elements: - html elements are text files that are made up of html elements. Html elements are defined with the help of html tags.   Html tags:- html tags are used to markup the html elements html tags are surrounded by the two character < and > . The surrounding characters are called angle brackets. the html tags normally come in pair like <a>----</a> the first tag in a pair is the start tag and the second tag is ending tag the text between the start and ending tag is called element contents html tags are not case sensitive For Ex-<b> is same as<b>   There are two types of tags which are used in html - 1-
Read more

MS Excel notes (ccc) by social guide

  MS Excel   Ms excel is a spread sheet based application.   The previous name of ms excel spread sheet was VisiCalc it was developed in 1979 . It is used for creating ledger invoices and analysis report, it shows the file in the form of work book, the work book contains many work sheets each work sheet has 1048576 rows   and 16384 column, the column is given name a, b, c like that and the rows are numbered 1, 2, 3. The page is divided into different cells & each cell can hold one set of value and the value is referred by the address; there are different type of addressing in ms excel. The extension of excel file is .xls or .xlsx   1-              Relative addressing: - this addressing is used when you require copying the formula in different cell and need the address to be adjust according to the corresponding cell and column. for ex-   A B C D E F G 1 Roll No. Name
Read more