MS-Access unit 5-1

 

MS ACCESS

Microsoft Access is a relational database management system that allows you to create, store, and manage data. It provides various features to create, modify, and maintain a database. Some of the main features of Microsoft Access are:

Tables:

A table is a collection of data that is organized into rows and columns. Tables are the building blocks of a database, and Access provides tools for creating and modifying tables.

Queries:

A query is a request for data from one or more tables in a database. Queries can be used to filter, sort, and group data, as well as to perform calculations on data.

Forms:

A form is a graphical user interface that allows users to view and interact with data in a database. Forms can be used to enter and edit data, as well as to navigate through a database.

Reports:

A report is a formatted presentation of data from a database. Reports can be used to summarize and present data in a clear and meaningful way.

Macros:

A macro is a series of actions that can be used to automate tasks in a database. Macros can be used to perform common tasks, such as opening forms, running queries, and printing reports.

Modules:

A module is a collection of Visual Basic for Applications (VBA) code that can be used to extend the functionality of Access. Modules can be used to create custom functions, automate tasks, and interact with other applications.

Security:

Access provides features for securing a database, such as user-level security and encryption. User-level security allows you to control access to a database based on user accounts, while encryption can be used to protect data from unauthorized access.

These are just some of the main features of Microsoft Access. Access also provides many other tools and features for working with data and creating powerful database applications.

components of ms access

The main components of Microsoft Access are:
Tables:

Tables are used to store and organize data in Access. Each table consists of one or more fields, which define the type of data that can be stored in the table. Tables can be created, edited, and deleted in Access.

Queries:

Queries are used to retrieve data from tables and to perform calculations on that data. Access provides a powerful query designer that allows users to create complex queries using a graphical interface.

Forms:

Forms provide a user-friendly interface for working with data in Access. Forms can be used to enter and edit data, to display data from tables or queries, and to perform other tasks such as running reports or running macros.

Reports:

Reports are used to display data from tables or queries in a format that is easy to read and understand. Access provides a powerful report designer that allows users to create custom reports with a wide range of formatting and layout options.

Macros:

Macros are used to automate tasks in Access. Macros consist of a series of actions that are performed in a specific order. Macros can be used to perform tasks such as opening forms, running queries, and printing reports.

Modules:

Modules are used to extend the functionality of Access by adding custom code. Access uses Visual Basic for Applications (VBA) to allow users to create custom functions, automate tasks, and interact with other applications.

Relationships:

Relationships define the connections between tables in Access. Access allows users to create relationships between tables based on common fields. Relationships ensure that data is stored and retrieved correctly and can prevent errors and inconsistencies in the database.

These are the main components of Microsoft Access. Access provides many other features and tools for working with data, creating database applications, and managing data securely.

ms access data types and properties given examples

Microsoft Access is a relational database management system that allows you to create, store, and manage data. Here are some of the most common data types in Access, along with their properties and examples:

1)Text: This data type is used for storing alphanumeric values, such as names and addresses.

Properties:

Maximum length: 255 characters
Default value: None
Format: Text
Example: Customer Name, Address, Phone Number

2)Number: This data type is used for storing numeric values, such as quantities and prices.

Properties:

Field Size: The number of bytes used to store the number.
Decimal Places: The number of decimal places to display.
Format: General Number, Currency, Percent, Scientific.
Example: Quantity, Price, Age, Weight, Height

3)Date/Time: This data type is used for storing date and time values.

Properties:

Format: Short Date, Long Date, Medium Date, Time, Medium Time.
Input Mask: Allows you to control the format of the data as it is entered.
Example: Date of Birth, Date of Hire, Last Login, Order Date

4)Memo: This data type is used for storing large amounts of text, such as notes or comments.

Properties:

Maximum length: 65,535 characters
Default value: None
Format: Rich Text or Plain Text
Example: Product Description, Order Comments

5)Yes/No: This data type is used for storing Boolean values, which can only be either "Yes" or "No".

Properties:

Default value: No
Example: In Stock, Active Status

6)Attachment: This data type is used for storing files and documents.

Properties:

Default value: None
Format: JPG, BMP, PNG, PDF, DOC, etc.
Example: Employee Photo, Product Specification

7)Hyperlink: This data type is used for storing URLs and email addresses.

Properties:

Default value: None
Example: Website URL, Email Address.

ms access tables

In Microsoft Access, tables are used to store and organize data. Tables are the building blocks of a database and can be used to store different types of data such as customer information, product details, sales transactions, and more. Here are some important aspects of Access tables:

1)Fields:

Tables consist of one or more fields, which define the type of data that can be stored in the table. Fields can be configured to store different types of data such as text, numbers, dates, times, and more. Each field can also have a name, which is used to identify the data in the table.

2)Data Types:

Access provides different data types for fields, such as Text, Number, Date/Time, Yes/No, Memo, Attachment, and more. The data type selected for a field depends on the type of data that will be stored in the field.

3)Primary Key:

A primary key is a field or set of fields that uniquely identify each record in a table. Access requires each table to have a primary key, which is used to ensure data integrity and to link tables together.

4)Relationships:

Relationships define the connections between tables in Access. Access allows users to create relationships between tables based on common fields. Relationships ensure that data is stored and retrieved correctly and can prevent errors and inconsistencies in the database.

5)Indexes:

Indexes are used to improve the performance of queries and sorting operations in Access. An index can be created on one or more fields in a table to speed up searches and sorting.

6)Validation Rules:

Access allows users to define validation rules for fields in a table. Validation rules are used to ensure that data entered in a field meets specific criteria, such as a range of values, a specific format, or other conditions.

7)Data Entry Forms:

Access provides tools for creating custom data entry forms for tables. Data entry forms allow users to enter and edit data in a user-friendly way, and can be customized with buttons, combo boxes, and other controls.

These are some of the key aspects of tables in Microsoft Access. By using tables effectively, users can create powerful and flexible databases that can store and manage large amounts of data.

ms access create table

To create a table in Microsoft Access, follow these steps: Open Microsoft Access and create a new blank database or open an existing database. Click on the "Create" tab in the ribbon at the top of the screen. Click on "Table Design" to open a new blank table in design view.

In the "Table Design" view, you can add fields to the table by entering the field name in the "Field Name" column and selecting the data type for the field in the "Data Type" column. You can also set properties for each field, such as the field size, format, and default value.

Set the primary key for the table by selecting the field or fields that will uniquely identify each record in the table and right-clicking on the field name. Select "Primary Key" from the context menu.

Save the table by clicking on the "Save" button in the Quick Access Toolbar, or by pressing Ctrl+S on your keyboard.

Enter a name for the table when prompted and click "OK" to save it.

Once you have saved the table, you can start entering data into the table by switching to "Datasheet View" or by creating a form to enter data into the table.

Create Table

goto a
1) click on datasheet
2) click on view option
3) click on design view
Write a data example 1st year B.com students data

Comments

Post a Comment

Popular posts from this blog

digital marketing ppt-u1

 ppt unit 1-1   download unit 1-2 download unit 2-1 download unit 2-2 download Migrating from Traditional Channels to Digital Channels Migrating from traditional to digital channels can be a significant undertaking for businesses, but it can also lead to significant benefits, such as increased reach, improved customer engagement, and better data-driven decision-making. Here's a breakdown of the process: 1. Define Your Goals and Objectives: What are you hoping to achieve with your digital presence? What specific metrics will you use to measure success? Who is your target audience, and what are their digital habits? 2. Assess Your Current Situation: What are your strengths and weaknesses in terms of digital marketing? What resources do you have available (budget, personnel, technology)? What are the potential risks and challenges of migrating to digital? 3. Choose the Right Digital Channels: Social Media: Which platforms are your target audience most active on? S...
Read more

SOFTWARE

Image
 01 Winrar -64-bit version-623 Download link click- 02 chrome setup Download link click- 03 Turbo-c Download link click-  Dev  C , C ++ 04 typing master 11 Download link click- 05 java software 64-bit version-8 Download link click-               64-bit                                        32-bit        06 Adobe-version-10 Download link click- 07 sublime text -64-version-4 Download link click- 08 python -64-bit-version-3.8.6 -32-bit-version-3.8.10 Download link click- 64-bit                                                  32-bit     09 MS-office 2007 Download link click-    Download link click-wps-office-2020    10 xampp ...
Read more

cn lab

Image
download   01 programs import java.net. * ; import java.io.*; class Ports { public static void main (String [] args) throws Exception { InetAddress h = InetAddress.getLocalHost(); String host =h. getHostName(); String haddr = h. getHostAddress();  System.out.println("\nHost Name: :"+ host);  System.out.println("In Host Address:: "+haddr); for (int i=0; i < 1024; i++) { Socket s=null; try  { s = new Socket ((host), i); System.out.println(" port "+ i + "Active"); } catch (SocketException se) { } catch(Exception e) { System.out.println(" Error...."); } } } } Output:- 02 -program 2 a) import java.io.*; import java.net. *; import java.lang. * ; class chats extends Thread { public static void main (String args []) { try { ServerSocket ss = new ServerSocket (111);  System.out.println ("server ready ");  Socket s = ss.accept (...
Read more

Computer Operations and Performing - D L Unit-1-1

Image
unit-1-1 download   unit-1-2 download   unit-1-3 download  unit-1-1 download  DIGITAL LITERACY syllabus :    Computer      A computer is a programmable electronic device that processes data to perform various tasks. It can store, retrieve, and process information and it is capable of executing a wide range of operations based on instructions provided to it. Computers come in various forms, including personal computers, laptops, servers, and embedded systems. 1.       Central Processing Unit (CPU): Often referred to as the brain of the computer, the CPU performs calculations and executes instructions.   2.       Memory (RAM): Random Access Memory is used to temporarily store data that the CPU needs to access quickly. It is volatile memory, meaning it loses its contents when the power is turned off.   3.       Storage: This includes devices l...
Read more

DBMS Degree Lab Records

Image
  PRACTICAL-I ER-DIAGRAM FOR TRAIN SERVICES  DRAW   ER-DIAGRAM FOR TRAIN SERVICES IN A RAILWAY STATION                              An Entity can be any object, place, person or class. Entity is represented using rectangles. An “ Entity–Relationship Model’’ ( ER- model ) modelling was developed for database design by “ Peter Chen ” and published in a “1976”. An ER- model describes about the inter-related things of interest in a specific domain of knowledge. An ER model is composed of entity types and specifies relationships that can exist between instances of those entity types. RAILWAY MANAGEMENT SYSTEM :-     ·         Railway management System is the computerized system of reserving the seats of train seats in advanced . ·      On-line reservation has made t...
Read more

DS-Record-mca-04) write a program for evaluating a given postfix expression using stack.

Image
    Program:-04   AIM:- write a program for evaluating a given postfix expression using stack. #include<stdio.h> #include<conio.h> int stack[20]; int top = -1; void push(int x) { stack[++top] = x; } int pop() { return stack[top--]; } void main() { char exp[20]; char *e; int n1,n2,n3,num; clrscr(); printf("\nEnter the expression :: "); scanf("%s",exp); e = exp; while(*e != '\0') { if(isdigit(*e)) { num = *e - 48; push(num); } else { n1 = pop(); n2 = pop(); switch(*e) { case '+': { n3 = n1 + n2; break; } case '-': { n3 = n2 - n1; break; } case '*': { ...
Read more

Java unit-1 history , C++ vs Java , java environment

Java History   Java is one of the most influential programming languages, widely used in various applications, from web development to mobile applications and large-scale enterprise systems. Here's a brief overview of its history: 1. Origins and Development: 1991: Java's development began at Sun Microsystems as part of the Green Project, led by James Gosling, Mike Sheridan, and Patrick Naughton. The project aimed to create a language for programming digital devices like set-top boxes and televisions. 1995:Originally called Oak (after an oak tree outside Gosling's office), the language was later renamed Java, inspired by Java coffee. It was officially released by Sun Microsystems as Java 1.0. The language was designed to have the "Write Once, Run Anywhere" (WORA) capability, allowing code to run on any device that supports the Java Virtual Machine (JVM). 2. Key Features: Java's popularity grew due to several features: Platform Independence: Java applications a...
Read more

Access the Internet to Browse Infromation & E-Mail Operation- D L Unit-2-1

    1. what is internet and what are the applications        The internet is a global network of interconnected computers and other electronic devices that communicate with each other using standardized protocols. It allows users to access and share information, resources, and services across vast distances. The internet facilitates various activities such as communication, research, entertainment, commerce, and much more. Key components of the internet include: 1. **Network Infrastructure** :       This comprises physical and virtual components, including cables, routers, switches, servers, and data centers, that enable the transmission of data across the network. 2. **Protocols** :       Protocols are rules and standards that govern how data is transmitted, routed, and received across the internet. Examples include TCP/IP (Transmission Control Protocol/Internet Protocol), HTTP (Hypertext Transfer Protoc...
Read more

OAT-Record-01) Visiting card

Image
  Aim:-To a Design a visiting card for Managing Director of a company as per the following specification. ·          Sizeofvisitingcardis3½×2 ·          Name of the company with big font ·          Phone number, Fax number and E-mail address with appropriate symbols. ·     Office and Residence address separated by a line Procedure:- STEP 1:       Enter into MS-Word environment by choosing start à Programs à Ms Office à MS Word STEP 2:       Now save the opened Blank document with the following step Office Button à save à visiting card STEP 3:       Insert a text box by clicking insert—> text box. STEP 4:       Set the size of the text box to 3(1/2) X2 either with the help of ruler or with Format text box option, which is Available on right click, w...
Read more

java program structure,java Tokens, keywords,

Image
java program structure                     Java program may contain many classes of which only one class define a main method. Class contain data members and methods that operate on the data members of the class.   Documentation Section In Java, comments are used to annotate code and are ignored by the compiler. Java supports two types of comments: single-line and multi-line comments. 1.Single-Line Comments Syntax: Single-line comments start with `//` and continue to the end of the line. Use Case: Ideal for brief explanations or notes that occupy only one line. Example: class MyClass {      public static void main(String[] args)            {              int number = 10; // This is a single-line comment              System.out.println(number); // Outpu...
Read more