Skip to main content

Introduction to Microsoft Access


Microsoft Access

Microsoft Access is data management software. In this software you can store, retrieve and manipulate data. Microsoft Access is similar to excel but the major difference is that in excel all the column heading is dynamic you can make any new column for entering data and in access before entering any data you have to create the column heading along with its data type. Microsoft access is also called database software. Database means to store the data in an organised manner. The database has four components Table, Query, Forms and Reports. All the data in database are stored in tables.

Tables in Access

A table is a database object, which is used to store data in an organised manner. It consists of rows and columns. A database can have more than one table.

Components of table

The important components of a table are:
1. Fields or Attribute – The columns in a table are known as fields or attributes. The fields contain only single type of data. Every field has a data type that determines the type of values that can be stored under it.
Data types are the types of data which can be entered into the field. Once the data type is defined for the fields we cannot enter different data into it.
2. Record – The rows in a table are known as records. A record stores complete information about an object or an item.
3. Primary Key – A primary key is a type of field which represents the unique value in a field. Primary key can be applied in only one field.

Labels:

Comments

Post a Comment

Students you can ask your doubts in comment section

Popular posts from this blog

Q & A Chapter 1 | Internet Basics | Class 10 CBSE | Computer Application

 Q & A of Chapter 1 Internet Basics A. Tick the correct options – 1. (b) TCP/IP 2. (a) Internet Service Provider 3. (a) URL 4. (b) HTTP 5. (a) Bridge 6. (a) home page 7. (d) All of these 8. (b) Domain Naming System 9. (b) Rules 10. (d) ARPANET B. Very Short Answer Type Questions – 1. In the URL http://www.myfirm.co.in/about.html , what do the following components depict? (a) http                                                 (b) in (a) Http represents a type of server and the protocol on the Internet (b) ‘in’ represents the domain extension of the website. 2. In the URL http://www.favmusic.com/contactus.html what does www.favmusic stand for? www.favmusic represents the domain name i.e. favmusic in www. 3. W...
Post a Comment
Read more

Bit by Bit | Chapter 6 - Graphics and Sound in QB64 | QBasic | Class 7 CBSE | Computer Application

Bit by Bit | Chapter 6 - Graphics and Sound in QB64 A. Tick the correct option. 1. (d) screen mode 0 2. (b) 640 x 350 3. (d) White 4. (a) Lower-Right 5. (c) PSET 6. (c) Generate a tone for a short duration B. Fill in the blanks. 1. CIRCLE 2. PAINT 3. PLAY 4. Graphic 5. Pixels 6. Box C. True or False. 1. True 2. False 3. False 4. True 5. True 6. True D. Answer the following questions. 1. What is the use of SCREEN statement? The SCREEN statement is used to set the screen mode for displaying graphics. There are many screen modes and each screen modes have their own number which is from SCREEN 1 to SCREEN 13. The various screen modes differ in resolution. 2. What is a pixel? How is it related to resolution? The graphics which is displaying on the computer screen is made up of thousands of dots called pixel. Pixel stands for picture element. The number of pixels in an image determines the resolution of the image. Higher the resolution, cleaner the image will appear. 3. What is the differenc...
Post a Comment
Read more

Thymeleaf function on button click with multiple parameter

how you can write the onclick attribute using Thymeleaf syntax: <button type = "button" th:onclick= "|rejectSalaryPayment(' ${response.uuid} ', ${dto.id} )|" >Reject Salary Payment</button> This assumes that the response.uuid and dto.id variables are available in the current Thymeleaf context. If they are not, you will need to provide the appropriate values or expressions to evaluate them. Also note that the onclick attribute is written using the Thymeleaf expression syntax ( |...| ), which allows you to include string literals and variable expressions within the same attribute value. 
Post a Comment
Read more