PRACTICAL
Write MS Access code to create database, table and modify table.
Practical Outcome (POs):
1) create database
2) create tables and assign primary key.
3) Modify table structure add column , change the datatype of column , delete column from table.
4) Insert , update and delete record from table.
5) Retrieve data from table according to condition given.
Resources required :
Operating system: windows 7 and above / LINUX version 5.0 or later
Software – Any MS Access software
Exercise:
1. Create a ‘student’ database and save the database.
2. Create ‘Employee’ database and save it.
3. Create multiple tables in database ‘Employee’
4. Assignment of primary key..
Download
0 formats
No download links available.
Write MS Access code to create database, table and modify table | NatokHD