Computer Awarness

                                         Ms ACess

Microsoft Access, created by Microsoft, is a database management system (DBMS) that combines the relational Access Database Engine (formerly known as the Jet Database Engine) with a user-friendly graphical interface and software development tools. It is part of the Microsoft 365 suite of applications and is included in the Professional and higher editions, but it can also be purchased separately.


Microsoft Access stores data in its proprietary format, utilizing the Access Database Engine. Additionally, it can import data from or establish links to data stored in various other applications and databases.




Software developers, data architects, and power users leverage Microsoft Access to build application software. Similar to other Microsoft Office applications, Access is complemented by Visual Basic for Applications (VBA), an object-oriented programming language capable of referencing a wide range of objects, including legacy DAO (Data Access Objects), ActiveX Data Objects, and numerous other ActiveX components. Visual elements employed in forms and reports provide their methods and properties within the VBA programming environment, and VBA code modules can both declare and execute operations related to the Windows operating system.




Microsoft Access features a user interface that is consistent with other Microsoft Office applications, both in its layout and navigation. However, it stands out as a database software, specifically a relational database system.



Prior to Microsoft Access 2007, files used the extension *.mdb, but from Access 2007 onwards, the extension was changed to *.accdb.

Earlier versions of Access are unable to read files with the accdb extension, but MS Access 2007 and subsequent versions have the capability to open and modify databases created in earlier Access versions.

An Access desktop database, whether in .accdb or .mdb format, serves as a fully functional relational database management system (RDBMS). It offers comprehensive features for defining data structures, manipulating data, and exercising control over data, making it suitable for handling substantial data volumes.

An Access desktop database can be employed either as a standalone RDBMS on a single workstation or in a shared client/server mode when accessed across a network. Moreover, it can also serve as the data source for displaying data on webpages within your organization's intranet.

When you create an application using an Access desktop database, Access takes on the role of the RDBMS for that application.




Types of Database:-



Structured Query Language (SQL) is a widely recognized database language that enables users to carry out operations on an existing database and even create a new one. SQL relies on a set of commands such as CREATE, DROP, INSERT, among others, to execute the desired tasks.

Think of SQL commands as directives to a database table. They serve as the means to interact with the database, facilitating various operations, functions, and data queries. SQL's capabilities encompass tasks like table creation, data insertion, table deletion, table modification, and user permission management.

These SQL commands are typically organized into five fundamental categories:


1. DDL - Data Definition Language: DDL commands are used for defining and managing the structure of the database, including creating, altering, and deleting tables and schema.

2. DQL - Data Query Language: DQL is focused on querying and retrieving data from the database, allowing users to extract specific information.

3. DML - Data Manipulation Language: DML commands facilitate the modification and manipulation of data stored within the database, including inserting, updating, and deleting records.

4. DCL - Data Control Language: DCL commands deal with access control and user permissions, determining who can access, modify, or perform operations on the data.

5. TCL - Transaction Control Language: TCL commands are used to manage transactions in the database, ensuring data consistency and integrity through operations like COMMIT and ROLLBACKIn essence, SQL serves as a powerful and versatile language for managing and querying databases, offering users a structured framework to interact with and control their data effectively.





Data Manipulation Language (DML): DML commands are responsible for manipulating the data stored in the database. They are among the most frequently used SQL statements. DML includes commands for inserting, updating, and deleting data, as well as managing concurrency and calling subprograms. Key DML commands are:

1. INSERT: Used to add new data records to a table.

2. UPDATE: For modifying existing data in a table.

3. DELETE: This command removes records from a database table.

4. LOCK: Controls table concurrency.

5. CALL: Invokes a PL/SQL or JAVA subprogram.

6. EXPLAIN PLAN: Describes the access path to data.


Data Control Language (DCL): DCL commands, including GRANT and REVOKE, focus on rights, permissions, and access control within the database system.
GRANT: Grants specific access privileges to users for certain database objects.




Syntax: GRANT SELECT, UPDATE ON MY_TABLE TO SOME_USER, ANOTHER_USER;


REVOKE: Withdraws access privileges previously granted using the GRANT command.




Syntax: REVOKE SELECT, UPDATE ON MY_TABLE FROM USER1, USER2;




Transaction Control Language (TCL): TCL commands are used to BEGIN: Initiates a new transaction.
COMMIT: Confirms and finalizes the transaction.


Syntax: COMMIT;

ROLLBACK: Undoes a transaction in case of an error or failure.


Syntax: ROLLBACK;

SAVEPOINT: Establishes a save point within a transaction to allow for partial rollbacks if necessary.Syntax: SAVEPOINT SAVEPOI





A database object is a fundamental component within a database management system (DBMS) that helps in the organization, storage, retrieval, and manipulation of data. These objects serve various purposes and structures within a database, allowing users to efficiently manage data. Here, I'll provide an explanation of some common database objects and illustrate them with a simple diagram.

1. Tables:Explanation: Tables are the core database objects for storing structured data. They consist of rows and columns, where each column represents an attribute or field, and each row represents a record or data entry.
Example: Let's say you have a database for a library, and you want to store information about books. You can create a "Books" table with columns like "Title," "Author," "ISBN," and "Publication Year." Each row represents a specific book in the library.

Diagram------------------------------------ | BookID | Title | Author | ISBN | Pub Year | ------------------------------------ | 1 | Harry Potter | J.K. Rowling | 9780439708180 | 1997 | | 2 | To Kill a Mockingbird | Harper Lee | 9780061120084 | 1960 | | 3 | The Great Gatsby | F. Scott Fitzgerald | 9780743273565 | 1925 | ------------------------------------


2. Queries:Explanation: Queries are objects used to extract, filter, and manipulate data from tables. They allow you to pose specific questions to the database to retrieve desired information.
Example: You want to find all books published after 2000. You create a query that filters the "Books" table to display only those books meeting this criterion.

3. Forms:Explanation: Forms are user interface objects used for data input, display, and interaction. They provide an organized and user-friendly way to enter and edit data in tables.
Example: In your library database, you create a "Book Entry Form" where librarians can input book details conveniently, and the data is then stored in the "Books" table.

4. Reports:Explanation: Reports are objects for presenting data in a structured and printable format. They are typically used for generating summaries, analyses, or formatted lists of data from tables and queries.
Example: You design a "Monthly Book Report" that summarizes the new book arrivals in the library, including the title, author, and publication year. This report can be printed and shared with library patrons.



These database objects work together to organize, store, retrieve, and manage data in a structured and efficient manner. They enable users to interact with the database, input data, and obtain meaningful information through queries and reports. The diagram demonstrates how the "Books" table data can be presented in a "Monthly Book Report.

How To create A database in A Table :-



Creating a table in a database is like setting up a structured spreadsheet to store specific types of information. Here's how to do it in a straightforward, coaching way:

1. Open Your Database Software:Launch your database management software, such as Microsoft Access, MySQL, or SQLite. You need to have a database open or create a new one if you don't have one yet.

2. Choose "Create a Table":In most database software, there's a clear option like "Create Table" or "Design Table." Click on it to begin.

3. Define Your Table Structure:Think of your table like an Excel spreadsheet. You're setting up columns (also known as fields) to organize your data.
Each column should have a name (e.g., "Name," "Age," "Email") and a data type (e.g., text, number, date).

4. Set the Primary Key (Optional):If you have a unique identifier for each row, like an ID number, designate it as the primary key. This ensures each row is distinct.

5. Add Rows and Data:Now, you can start adding data to your table. Think of each row as a new entry.
For example, if you're creating a table for a contact list, each row could represent one person, and each column might be for their name, phone number, email, and so on.

6. Save Your Table:Give your table a name, and then save it. This stores the structure and data you've added.

7. You're Done!You've successfully created a table in your database. Now you can use it to organize and manage your data.

Remember, creating a table is like setting up a digital spreadsheet for your data. You define the columns (fields), assign data types, and then start entering your information. It's a fundamental step in organizing your data within a database

Data types of Database:_.


· What are text/string data types in databases?


· Text/string data types are used to store character-based information. For example, CHAR for fixed-length strings and VARCHAR for variable-length strings.


· How are numeric data types used in databases?


· Numeric data types store numerical values. For instance, INT is used for whole numbers, while DECIMAL handles fixed-point numbers.


· What purpose do date and time data types serve?


· Date and time data types are used to store temporal information. DATE stores dates, TIME stores times, and DATETIME stores both date and time.


· What does a boolean data type represent in a database?


· The boolean data type (BOOLEAN) represents true or false values, typically used for binary decisions.


· How are binary data types utilized in databases?


· Binary data types, like BLOB, store binary information such as images, documents, or other binary data.


· What is the role of enumerated (ENUM) data types in databases?


· Enumerated data types (ENUM) allow you to define a list of permissible values for a specific column, restricting the possible inputs.


· How do spatial data types function in databases?


· Spatial data types like GEOMETRY are used to manage geographic or geometric data, enabling operations like point-in-polygon checks.


· What is the purpose of a JSON data type in databases?


· The JSON data type is used to store data in JSON (JavaScript Object Notation) format, which is commonly used for semi-structured data.


· What are custom or user-defined data types in databases?


· Custom data types are defined to meet specific application needs. They allow you to create data types tailored to your business requirements.


· How do XML data types work in databases? - XML data types store structured data in XML (extensible Markup Language) format, often used for documents with hierarchical or tagged data.










How to create Database (Microsoft Access, follow these steps):


1. Open Microsoft Access: Launch the Microsoft Access application.

2. Select a Database: Open an existing database or create a new one. You can choose to start a blank database or use a template.

3. Design View or Datasheet View: You have two views to choose from:


· Design View: This view allows you to define the table's structure, including field names, data types, and other properties. It's more detailed and is ideal for precise table design.

· Datasheet View: In this view, you can directly enter and edit data in a grid, and Access will automatically create a table structure based on your input. It's useful for quick data entry.


4. In Design View:


· Click on the "Table Design" button.

· Define the table's fields by specifying the field name, data type, and any other properties (e.g., primary key, validation rules).

· Save your table design with a name.


5. In Datasheet View:


· Start entering data in rows and columns. Access will prompt you to save the table and give it a name.


6. Set Primary Key (if necessary):


· In Design View, you can specify a primary key field that ensures each record is unique.


7. Save the Table:


· Make sure to save the table with an appropriate name.


8. Close the Table Design View:


· Save your changes and close the table design.


You've now successfully created a table in Microsoft Access. You can begin entering and managing data in this table.






: Data base Key:- :





In a database, a "key" is a crucial concept used to identify and organize data efficiently. There are several types of keys, each serving a different purpose
1. Primary Key (PK): A primary key is a unique identifier for each record in a table. It ensures that each row in a table is distinct. A primary key enforces data integrity and provides a quick way to locate specific records.

2. Foreign Key (FK): A foreign key is a field in one table that relates to the primary key in another table. It establishes relationships between tables, enabling the creation of linked data across different tables.

3. Super Key: A super key is a set of one or more attributes (columns) that can uniquely identify records within a table. It can include more fields than needed to ensure uniqueness.

4. Candidate Key: A candidate key is a minimal super key, meaning it's the smallest set of fields required to uniquely identify records. Among candidate keys, one is chosen as the primary key.

5. Composite Key: A composite key consists of two or more fields used together as a primary key. It's often used when no single field can uniquely identify records.

6. Alternate Key: An alternate key is a candidate key that isn't chosen as the primary key but remains unique and enforces data integrity.


Keys are fundamental to ensuring data accuracy, maintaining relationships between tables, and optimizing database performance. The primary key is especially important for uniquely identifying records, while foreign keys establish connections between tables.