How to Insert, Delete, Update Data in MS-Access 2010 Using MS-Access Blank Form

Before reading this article you might need to read two prerequisites article as below:

1. How to Create New Blank Database in Microsoft Access 2010
2. How to Create Table in Microsoft Access 2010

This article shows you how to:

• Create Form (Non-wizard Form) in Microsoft Access 2010
• Design your own Form using TextBox, ComboBox, Command button and Subform control
• Write VBA (Visual Basic for Application) Programming to Insert, Delete and Update data in MS-Access Table
• Use SQL statements to Insert, Delete and Update Data in MS-Access Table

Read More…

How to Set Database Password in Microsoft Access 2007

This article shows you how to set database password in Microsoft Access 2007 whether its format is *.mdb or *.accdb.

1. Open existing database or create new database (.mdb or .accdb)
2. Click on Database Tools tab
   

Read More…

How to Create Customized Ribbon in Microsoft Access 2007

This article shows you one scenario about how to create a customized Office Fluent Ribbon in Microsoft Access 2007. This article applies to only Microsoft Office Access Database not include the Microsoft Office Access Project (*.ADP). To customized our own Ribbon we need to know some of XML markup text.

Scenario for creating customized Office Fluent Ribbon in Microsoft Access 2007

• Step 1: Create New Project Database or Open your existing Project Database
• Step 2: Create New Table named USysRibbons with the following fields:
  

  Field Name	Data Type	Description
  RibbonName	Text	Unique name that identifies the UI extensibility customizations in the RibbonXML field.
  RibbonXML	Memo	RibbonXML that describes a set of customizations to be applied to the Office Fluent UI.

Read More…