If you have to move data out of Access database, you can do it with the help of TransferSpreadsheet in Access Macro. It is not that complicated but if you are new to Microsoft Access it might get a little confusing at first. But, it is important to learn this technique, which will be useful for basic database tasks.

Macros are great because they include a bunch of commands into one Access object. When you need to complete a certain task, you start the object and give it certain commands to run the task. For example, you might type your name in Excel into each of cells in one column, or you can save your time and have macro fill up the cells for you.

But, this time, we are going to assign the data that has to be moved to macro and then it will be moved without any interaction. Macro actions that are built in MS Access let us do it easily.

To start doing it, you should create a new macro and select “TransferSpreadsheet” in the first dialog box. You will notice a couple of options available in the lower part of the window. Here is a brief summation of what you will see.

TransferType option is asking if you are importing or exporting data. In this case, we would choose exporting data because we want to transfer data to Excel.

The Spreadsheet type option gives you the opportunity to select different versions of spreadsheets. If you are using any Excel edition after the 97th, it is better to choose the latest version, in this case Microsoft Excel 8-10, which would embrace Excel 97, 2000 as well as XP.

There is also a Table Name option, but it doesn’t have to be a table. In our situation, we would be exporting a query named “qsel_Test”.

The next option is File Name. In order to transfer data, you can use already existing file, or simply type a path and name of a file that doesn’t exist yet and it will be created for you by Access. You can try it and the file will appear magically.

Another option, which is Has Field Names, is not that important but it might be useful if you plan to work with the data in Excel. This option is asking you if you want the headings to be transferred over. If you turn this option off, then no headings will appear and the data will appear right in the Row 1 of Excel sheet.

There is also Range option, where you can define a specific range of your Excel sheet, if there is one. But usually it is a rarity.

Then you can save your macro and run it by clicking on it. And if you check your C: drive you will see that there is an Excel file with the exact data you had in your query.

Anything about microsoft access database: great training info, all sorts of business products (customized for your needs), special microsoft access database blog with tips and advice about MA databases.

All this and more from a reputable UK based company which specializes in microsoft access database and is helping clients all over the world.

If you are using an invoice system in your Access database, you might want to show customers with the related sales. You can achieve this by using a main form and a sub form. A form within a form is called a sub form.

Let’s say there are two tables – Customer and Sales. You can create a form based on the table Customer. Select Forms in the main database window and click New, then Form Wizard and the form “Customer”. You can select the following from the available fields: Customer ID, FirstName, LastName, Address1, Address2, and Tel. Then click “Next” to go to the next screen. As a layout you should choose “Columnar” and then click “Next” again. You can select Standard for your style and click “Next”. Now it is time to name the form “Customers” and click “Finish”. You have created the form “Customers” in Access.

If you want to show sales for the customer you have to create another form which is going to be a sub form. And again you are going to use the Wizard for this. You can repeat the above steps but make sure to choose the table “Sales” for this. Fields to select are OrderID, CustomerID, OrderNumber, OrderDate, ProductNumber, and Price. Then click “Next”. As the layout for this form will be “Datasheet” and the style – “Standard”. Name your form “Sales” and click “Finish” which will create form as a datasheet. It will resemble the Excel spreadsheet. You can close the form now and go back to the database window and then open the form “Customers” in the design view. Make some room by expanding the form edges. Then go back to the database window, leaving the form in design view.

Select form “Sales” and drag it to the empty area in the “Customers” form. You can stretch the form as you like and give it the desirable position. Then you can run it. Now go to the menu option “View” and select “Form View”. Now your forms related. If you go to the Properties of the forms you would see notes like Link Child Fields and Link Master Fields. Access made the link when the sub form was created because fields had the same names in the both tables. Now you can change the color of your forms and add other features to them.

As you can see, it is a very powerful feature of Access to create sub main forms. You can use them for showing a single record and related multiple records. With feature it is easy to model a lot of relationship. One of the customers can have more than one sale, for example. With the above steps you will be able to make the performance of your Access database a little more effective.

The industry of computers and computer applications expands all the time. But you can turn this problem into your advantage by catching up with this knowledge and becoming an expert, for example in microsoft access database niche.

Please visit this site that is dedicated to microsoft access database topic and has a great line of microsoft access database products available.

There are many benefits to using the Microsoft Access database. One of the useful functions it has is the ability to link the Excel spreadsheets. After reading this article you will know how to do it.

The first thing to do is to click on the main window of the database and select “Link Tables”. You could also do this by referring to the file menu and choosing “Get External Data” and “Link Tables” will follow.

The next step is to select the spreadsheet. Access might ask you which spreadsheet to select if the worksheet has several of them. The program will also ask you about the range you would like. When you make your selection, you should click on the Next button.

Then you will have to decide whether you want to leave the table headings in Access the same that were specified in Excel spreadsheet or not. If you want that then you should put a cross in the box next to the words “First row contains column headings”. In order to continue click the Next button.

Then Access will ask you how you would like to name your linked table. When you are done click the Finish button.

Then go to your main database window and select “Tables”. You will be able to see your table that is linked to the spreadsheet because it has the Excel symbol. Then you can test it. Open it and try to change some data in it. You will notice that even if the spreadsheet is open at the moment the changes will display there too. The great thing about it is that you can create queries and forms around the linked tables and have all the updates appear automatically in the spreadsheet. You can even graph your data in MS Access.

You might not want to link the Access table to the spreadsheet but instead want to keep all the data from it and create a separate table. You can easily do it by selecting “Make table query”. As you can see, Microsoft Access makes such tasks like linking very easy. Hopefully, this article has given you an insight of the benefits and power of the MS Access and Excel spreadsheet linking which has lots of advantages for your personal database development or for your company’s use. You must know all these benefits if you already successfully use Access databases for your needs. If you don’t use it yet but plan to implement it, it would be wise to get a proper Access training and education in order to get the most out of this software and to avoid the common mistakes people make because of the lack of the Access knowledge.

Anything about microsoft access database: great training materials, all sorts of business products (customized for your needs), special microsoft access database blog with hints, tips and tricks about MA databases.

All this and more from a trustworthy UK based company which majors at microsoft access database and is assisting clients all over the world.

Dan Hentschel is a video game collector. He has 2000 video games for multiple systems and now he’s selling is entire Nintendo collection, including a thumb drive containing a full catalog of his collection. That is, friends, 700 different games, consoles, and controllers for on low, low price of whatever the madmen out there bid this up to.

Sadly the auction isn’t live yet but Dan has set up an informational page to tease us all a little bit about his collection. He’s included a friendly video and full photo album and he’s giving 50% to charity, which is noble.

Here are his reasons to bid:

Likely one of the most complete NES auctions you will ever see.
All the games have been alphabetized and cataloged. As part of the auction, you will receive a thumb drive containing pictures of every game, box, and manual. Also on the thumb drive will be videos of the collection, useful for insurance purposes, and an Excel spreadsheet containing a game checklist.
Every single game has been surface cleaned so that you can examine your collection without getting your hands dirty.
This collection has been stored in a smoke-free home. I.e. it doesn’t smell.
Each game has had the contacts meticulously cleaned, and each game has been tested in the top-loading NES included in the auction.
Included in the auction are nine extremely rugged Rubbermaid storage containers that are the ideal size and shape to hold NES games. They almost seem like they were designed specifically for that purpose.
I have a very good E-Bay profile with a solid feedback rating and selling history that goes back more than 10 years.
I will be donating 50% of the sale price on this auction to Victory. Some of you may not care too much about this one, but even if you are not a Christian, you may appreciate knowing that your money is going towards a charitable organization that is very active in helping the community.

And here’s mine:

You, too, can appear as crazed about video games as Dan. Pass the torch of obsession!