MS Access notes steps by steps RCSAS Naoholiya

 

 

       1.To open MS Access

1.     Click on start button
2.     Click all programs
3.      Click Microsoft Office
4.     Click MS Access

 

2. To create a blank database

1.     Open MS Access
2.     Select blank database
3.      Give file name
4.     Browse folder where you want to save your database files
5.     Click create

 

3. Design and creating tables

1.     Right click table → select design view.
2.    Give Table name → Click OK
3.     Make the table
4.    Press CTRL+S or F12 (To save)
5.     Click create tab → Click Table
6.       Right click to the newly created table → select design view.
7.    Give table name → click OK
8.    Make the table
9.       Press CTRL+S

 

4. Creating relationships

1.     Click Database tools tab → select relationship
2.    Select all the tables one by one and click add → Click close
3.     Click hold and drag primary key field of one table to the key field of other table and release mouse on table.

(NOTE: No relationship required for one table. It is only for two or more tables)

 

5. Creating the Query

1.     Click create tab
2.    Select query design
3.     Repeat step by (creating relationships)
4.    Drag fields from each table to the lower area for query
5.     Press CTRL+S → give name → OK
6.       Click on Create tab – Click on Query Design from other group – Add tables –

Update –

Field:

Table:

Update to: 

Criteria:

Or:

 

6. Creating form (used to enter data into database)

1.     Click create tab
2.    Select form wizard
3.     Tables/Queries → Query : Query 1
4.    Click >>
5.     Click next two times → Finish

 

7. Creating Report (To see the database)

1.     Click create tab
2.    Select report wizard
3.     Tables/Queries → Query : Query 1
4.    Click >>
5.     Click next two times
6.       Ascending → Primary Key field
7.    Click next two times → Finish

 

8. To enter information into database

1.     Double click Query 1 under forms (see the left pane)
2.    Fill the information
3.     Click next record.

 

9. To see the  database

1.     Double click query 1 under report (see the left pane)

 

  10. To add background image in a form of report

1.     Right click on the form/report
2.    Select Design view
3.     Click format tab
4.    Select background image → Click browse
5.     Select desired image
6.       Right click on the form
7.    Select properties
8.    Picture size mode → Stretch

_________________________________________________

 

Q. Create a database and following tables on MS Access given below.

 

Solution:

 

Blank database – create – Table 1 (right click → design view) – OK

 

Table 1

 

Field Name	Data Type
Name	Text
Address	Memo
Course	Text
Duration	Text

 

• Press CTRL+S to save → Close Table 1 → Create Table Design → Table 2

 

Field Name	Data Type
Name	Text
Fess	Currency
Roll No	Number (General →Field size → Double)
Phone No	Number (Double)

 

• Save (CTRL+S)
• Database tools → Relationships → Table 1 add → Table 2 add → Close.
• Name to name → Create → CTRL+S
• Close Relationship
• Create → Query Wizard → Simple Query Wizard → OK
• Table 1 → >> 
• Table 2 → > (select required fields) → Next → CTRL+S → Close
• Table 1 Query – Form Wizard → Table 1 → Query >> → next → next → Finish
• Next report after filling up
• After completing go to → create report

 

 

 

 

Converted to HTML with WordToHTML.net