Create New Table in Access

-

 Create New Table 

1. click on create tab

2.click table


Go to Design View

1.Go to Design View         
       a. Process-1 
          b. Process-2

2. Type Table Name
3.Type Filed Name and Data type


4. Right Click on Table name and click Datasheet view

Add New Filed
    a. Go to design View
    b. Right click on column name
    c. Type field name and data type


    d. go to datasheet view and type data
    e. save table
Set Field Properties




Apply Validation Rules
 Filed accept only value between 10 and 20



Comments

Post a Comment

Popular posts from this blog

Basic Web Design with HTML and CSS

-
Image
Webpage A  web page  or  webpage  is a document, commonly written in  HTML , that is viewed in an Internet  browser . A web page can be accessed by entering a  URL  address into a browser's  address bar . A web page may contain text, graphics, and  hyperlinks  to other web pages and files.   WebSite : A website is a collection of several web pages. These pages are linked together with hyperlinks. A website has a unique domain name, and we can access it by entering that domain name in the URL. A domain name is a string of characters that identifies a website. It is what users type in their browser to visit your site.   Web hosting is a service that provides space on a server for your website files, allowing it to be available on the internet. When visitors access your domain name, the hosting provider will transfer those files to their web browsers.   Two types of website Static website ...
Read more

Project Web Design Assignment

-
Image
  Assignment-3 <!DOCTYPE html> <html lang="en"> <head>     <meta charset="UTF-8">     <meta name="viewport" content="width=device-width, initial-scale=1.0">     <title>Employee Information Form</title> </head> <body>     <div style="width:30%; margin: auto;">         <form action="#" method="POST">             <fieldset>                 <legend>Employee Details</legend>                                 <!-- Name Field -->                 <label for="name">Name:</label>                 <input type="text" id="name" name="name" required><br><br>           ...
Read more