Microsoft Access 2013
Microsoft access is one of the most powerful and flexible data base program
because it can be used for both simple and complex data base project.
It also has the relational data base.
M.S. access provides us with set powerful tools for defining entering, managing
manipulating and resulting data.
Data-Base
It is the organized collection of data or related information that is shared and used
for multiple purpose.
How to open the access
1. Start Button
2. All Program
3. Microsoft Office
4. Microsoft office Access
Or
- Start button
- Run
- Type the Msaccess.
- Press Enter key
Planning the data base.
- What data do you want to store and what is the best way to organize it?
- This determinatives what table you need.
- What information do you want to know about the status of the data base?
- The answers tell you what reports and the queries you will want.
Data Organize in Access.
1. Table :- Heart of data base.
2. Queries :- Retrieving and editing information.
3. Form :- Ending the table for storage.
4. Reports : - How you want to see.
Your design or Summarizing Printing.
Creating a blank data base.
1. Office Button.
2. New option.
3. Blank Data Base.
Dialogue box will appear.
4. Choose Local Disk. (If you want to save.)
5. Create a own Folder
6. Create.
Creating table (By using design view)
1. First Click table
2. Choose creating table in using design view.
3. Click on Design option.
4. Choose the field name and data type
5. Then last save this file.
Project- 1 Sales Report
Field Name Data type
SN Number
Particular Text
Quantity Number
Rate Number
Amount Text
Discount Text
Net amount Text
Project – 2 Salary Report
Field Name Data type
SN Number
Staff's Name Text
Address Text
Date of birth Date/time
Post Text
Salary Number
Bon us Text0
Tax Text
Total Text
Photo OLE object
Project – 3 Ledger sheet
Field Name Data type
SN Number
Symbol No Number
Address Text
English Number
Nepali Number
Science Number
Math Nu0mber
Social Number
OPT I Number
OPT II Number
Health Number
Total Text
Result Text
Percent Text
Division Text
Remarks Text
Photos Ole object
Project:- 4 Per capita Income
Table: Country (Design view)
Field Name Data Type
Citizen Code Text
Country Lok up wizards
(USA, Africa, Nepal)
In look up wizard.
1. I will type the value that I want.
2. Next.
3. Set the column you need
4. type
5. Your need
6. Click on tab key again write.
7. I complete click on next.
8. Click on finish.
Color Text
Per Capita in come Currency/Number
Level Text
Project-5 Student's Record Form
Field Name Data type
SN Number
Student's code Number
First Name Text
Middle Name Text
Last Name Text
Address Text
Date of birth Date/time
Parent's Name text
Qualification text
Courses text
Shift time text
Cont address text
Cont number text
Cont email text
Photos Ole object
Queries:-
A query is the way of retrieving and editing the information in to the
condition asked.
Some crated area.
Well be there to solve this.
1. Click on Queries.
2. Creating using design view.
Dialogue box will appear.
3. Add the any file (staff records)
4. Close it.
5. Double click on field item.
6. Repeat it up to the last.
7. Save it.
Inserting the formula
1. Open the req. Query.
2. Put the color (:) Mark.
3. Click on Build button on the tool bar.
4. Dialogue box will be appearing.
5. Before the req. operation click.
Note1. If you put formula in query then it's effect will display in all of other
option.
Note2. If you put formula in form its effect will not display in report. (We have to
use (=))
# Some formula and its syntax use in msaccess.
Numerical formula:- This formula is used for all types of arithmetic operation
like: add, subtract Multiply and division etc.
1. + 2. - 3. * 4. /
#. Logical Formula: -
This formula is used for decision marking. Various logic
are used while soling any problem.
1. = 2. >
Formulas
Project -1
Amount: [Quantity]×[Rate] ok Run
Discount: [Amount]×15/100 ok Run
Net Amount: [Amount]-[Discount] ok Run
Project – 2
Bonus: [Salary]×10/100 ok Run
Tax: [Salary]×5/100 ok Run
Total: [Salary]+[Bonus]-[Tax] ok Run
Project – 3
Total: [English]+[Nepali]+[Math]+[Science]+[Social]+[Health]+[Opt I]+[Opt
II] ok Run
Result:
IIF([English]>32and[Nepali]>32and[Math]>32and[Science]>32and[Social]>3
2and[Health]>32and[Opt I]>32and[Opt II]>32,"Pass","Fail") ok
Run
Percent: [Total]/ 800×100 ok Run
Division: IIF([Percent]>=80and[Result]="Pass","Distinction",
IIF([Percent]>=60and[Result]="Pass","First division",
IIF([Percent]>=45and[Result]="Pass","Second Division",
IIF([Percent]>=32and[Result]="Pass","Third division","No Division"))))
ok Run
Remarks: IIF([Division]="Distinction","Excellent", IIF([Division]="First
division","Very good", IIF([Division]="Second division","Well",
IIF([Division]="Third division","Good","*")))) ok Run
Project-4 Currency Income
Color:IIF([Country]="USA","White",
IIF([Country]="AFRICA","Black","Olive")) ok Run
Level: iif([Per capita Income]>=100000,"Rich","Poor") ok Run
Forms: -
All the data you enter into your data base ends up in the table for storage you
can enter any information directly into a table.
But it is little bit difficult to do so.
Most users want to show it in the uncommon so we use the form to
inter the data.
Example:-
First you have to create by design wizard so.
1. Click on forms.
2. Design wizard
3. Place all the field list into it.
4. Next
5. Design the type of the shape(Next)
6. Click on Finish.
To Insert Field Least.
1. First Table entry.
2. Second you page
3. Third select the inserted column.
4. Fourth Insert column.
Double click on the field type your required.
