Showing posts from October, 2022

How to create table in MS-Access: Table Creation MS-Access

  Creating Table: Tables can be created in five different ways that are shown as follows. 1.       Data sheet view 2.       Design View 3.       Table wizard 4.       Link table 5.       Import table   v   Data sheet View: o    It allows creating new tables in data sheet view. That is a grid that is similar to Excel sheet. o    In the data grid directly you can rename the field names, which are initially field1, field2... by default. o    Data can be directly entered into the cells. v   Design View: o    In design view you need to enter the field names first. o    You can also setup data type for each field. o    The size of the fields can be changed or it will have the default values. o    Save the table. Give a name for the table. o    If you want to add primary key. Then add it. o    Open the table to enter the records. v   Table Wizard: o    Open table wizard. o    Select either business or personnel type table. o    From the selected tabl

Creation of Database In MS-Access

  Creating a Database:               Database can be created in two different ways. Those are: ·        Selecting “open blank database” ·        Selecting “database wizard” v   Selecting “open blank database” o    Choose File/New or Ctrl+N (or) click on new button on database tool bar o    In new dialog box double click on blank database o    When you see file new database dialog box type a filename. o    Choose the folder name. By default it is stored in My documents o    Click “create”. o    You can see a new empty database window. o    Click the New, you will be offered a number of choices. Select table wizard and click ok. v   Selecting “database wizard”: o    Select database wizard option. o    It is a method of design databases by a step by step procedure. o    Choose some of the readymade databases like ledger, accounts. o    When you see file new database dialog box type a file name. o    Choose the folder name. By default it is stored in My do

PHP Coding standards

 PHP Coding Standards : Below are the practices every programmer should follow for clean and neat code. By following these code will be readable and easily understandable by other fellow programmer. Comments There should be comments in appropriate format. Do not use short tags as it creates confusion There 2 naming conventions we can follow Consistently Using Braces BSD style K&R style Using Loops in appropriate ways Avoiding Deeply Nested Loops Variable Names: handling word breaks in multiword variable names $numElements $num_elements Function Names They should be all lowercase, and multiword names should be separated by underscores. A function’s, class’s, or variable’s name should always reflect what that symbol is intended to do, to enhance the readability of your code Naming Consistency Variables that are used for similar purposes should have similar names Matching Variable Names to Schema Names Variable names that are associated with database records should always have matchin