Microsoft Office Access questions & answers

Creates databases and performs various operations
G
Question by Guest #106509744
209 views
April 24, 2018
S
Answer by Sean Hill

Version 15 and 16 of Office are different as you can see in the image below:

Click to viewVersion info

Microsoft doesn't offer the possibility to upgrade for free from one product version to another which means that you will have to pay for the upgrade. They also have a page set up for this procedure where you can buy the whole page or only the Microsoft Office Access.

Guest #30133613
Question by Guest #30133613
265 views
January 23, 2014

I forget the password for a Microsoft Access file. Is there a way to recover it?

L
Answer by Leonard Moore

Yes, it is possible. In order to recover a password for a Micorsoft Access file, you can use a program from the Software Informer database that is developed for this purpose. Depending on your file extension, you can use a program like Password Recovery or Access Password Recovery. To be noticed that both mentioned programs are shareware, but you can obtain a download link for a trial version by visiting their review page at Software Informer.

J
Answer by Julia Bocchetta

Yes, the product can be integrated into Microsoft Access 2010 only. As the time of the release, this is the only version supported by DataDirect Connect XE.

G
Question by Guest
229 views
March 14, 2010

What is the formula use in Microsoft Access when computing a payroll? Where to find an example?

S
Answer by Sean Hill

Since this is a complicated process, you might need to use some tutorials at first. Basically, you will need to create a form with an employee's name, work hours, working time and final check. Try using Google because there are multiple examples available for you.

N
Question by navnita
217 views
March 4, 2010

How can we access all the records from database chronologically? I need the records for a particular date and a syntax for accessing the data between two particular dates of birth (from and to).

P
Answer by Pete Clapp

In order to access the records for a particular date, you will need to use the following syntax:


SELECT * FROM TableName
WHERE Date="dd/mm/yyyy";

In order to access the data between two particular dates of birth, you can use one of the following statements:


SELECT * FROM TableName
WHERE Date BETWEEN "dd/mm/yyyy" AND "dd/mm/yyyy";

or


SELECT * FROM TableName
WHERE Date >= "dd/mm/yyyy" AND Date <= "dd/mm/yyyy";
G
Question by Guest
211 views
November 6, 2009

Is it possible to open a database created with a Borland engine in Access? I keep getting an error message: "External table is not in the expected format." Does anyone have a solution to opening this database up? Just need to be able to grab the data and drop it in an Excel sheet.

R
Answer by Robert Polubinski

Instead of trying to open the database in Access, you'd better use an application to directly export the content to an Excel sheet. There are many applications created for this type of job and it's more easier than finding ways to properly import the database in Access. It's a tedious and complicated. For example, Exportizer is an application that can handle the BDE database to export it to XLS file format.

G
Question by Guest
196 views
November 3, 2010
J
Answer by Julia Bocchetta

Unfortunately, there isn't a database already created for such request. You will have to design it by youself. I recommend following the tutorials on the Google Search results page to find an answer to this issue. The tutorials will teach you how to create a database and how to retrieve it from other applications.

Ask a question about Microsoft Office Access

Alternative downloads

Microsoft Office Word
rating

Program that allows you to create documents.

Microsoft Office OneNote
rating

Program that lets you manage your notes.

Office Product Key Finder
rating

It helps you retrieve the product keys (codes) for MS Office installations.