SETHA SITE INFORMATION

  • Increase font size
  • Default font size
  • Decrease font size
Microsoft Access

How to Make ACCDE file in Microsoft Access 2010 (MDE in Microsoft 2003)?

E-mail Print PDF

This article shows you the way to make Microsoft Access 2010 ACCDB file into the ACCDE file which equivalent to the MDE file in Microsoft Access 2003.

If you develop database by creating Access Form, Access Report and VBA in Microsoft Access 2010 then your database file will be extension .ACCDB (eg. data.accdb) (which is the .MDB file in Microsoft Access 2003). To avoid other people viewing the VBA code in your file you have to convert the .ACCDB file into .ACCDE file (in Microsoft Access 2003 is converting from .MDB to .MDE).

To begin just open the Microsoft Access 2010 Database and follow the instructions below:

  1. Click Home Tab
  2. Click Save & Publish
  3. Click Save Database As
  4. Click Make ACCDE
  5. Click Button Save As
  6. Choose File Location
  7. Save

 

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

E-mail Print PDF
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

Download Sample Here
 
See video below
Part 1:

Part 2:
 

How to Create Table in Microsoft Access 2010

E-mail Print PDF

After you created new blank database you will see one table is created named Table1 which is not yet save. If you do not prefer to continue with that default table just click on the x button on the right hand side without saving.

Create New Table in Microsoft Access 2010
  • Click on Create Tab
  • Click on Table Design Button
  • You will see the table designation windows appear
  • Enter fields name and its data type as below:
  • Set field stdid to Primary Key (Not allow duplicate data for stdid) by Right Click on that field and choose Primary Key
  • Click <Ctrl-S> to Save the Table
 

How to Create New Blank Database in Microsoft Access 2010

E-mail Print PDF

This article shows you how to create new blank database in Microsoft Access 2010. This article is targeted to the beginner of Microsoft Access 2010.

  • Open Microsoft Access 2010 from Start Menu
  • Click on the Blank database (on the middle page of MS-Access start page)
  • Enter Database File Name (example: student.accdb) (on the right page of MS-Access start page)
  • Click button Create
  • One database is created
  • Continue to create table in Microsoft Access 2010
 

How to Set Database Password in Microsoft Access 2007

E-mail Print PDF
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
  3. Click on Set Database Password

    If you have problem here, please follow instructions below:
    1. Click on Microsoft Office Button
    2. Click on Close Database
    3. Click on Microsoft Office Button again
    4. Click Open Under the Office Button (Open Dialog Windows is Appeared)
    5. Choose database file (eg. ...\bin\debug\data.mdb)
    6. Click the Drop-down of Open Button
    7. Choose Open Exclusive
  4. Click on Database Tools -> Set Database Password
  5. One Dialog appears for you to set password (Enter your password)
  6. Done
 
  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  Next 
  •  End 
  • »


Page 1 of 2