Skip navigation

Bookboon.com Download free eBooks and textbooks

Choose a category

Access 2010: Part IV

Macros, Import and Export

Access 2010: Part IV
4.6 (17 reviews)
ISBN: 978-87-7681-860-9
1 edition
Pages : 106
  • Price: 75.50 kr
  • Price: €8.99
  • Price: £8.99
  • Price: ₹150
  • Price: $8.99
  • Price: 75.50 kr
  • Price: 75.50 kr

Download for FREE in 4 easy steps...

We are terribly sorry, but in order to download our books or watch our videos, you will need a browser that allows JavaScript.
After entering your email address, a confirmation email will be sent to your inbox. Please approve this email to receive our weekly eBook update. We will not share your personal information with any third party.
eLib
Unlock your organization's learning potential
See Demo

Corporate eLibrary

Discover our employee learning solutions

This is a Premium eBook

Bookboon Premium - Gain access to over 800 eBooks - without ads

You can get free access for a month to this - and 800 other books with the Premium Subscription. You can also buy the book below

  • Start a 30-day free trial. After trial: 39.99 kr p/m
  • Start a 30-day free trial. After trial: €5.99 p/m
  • Start a 30-day free trial. After trial: £4.99 p/m
  • Start a 30-day free trial. After trial: ₹299 p/m
  • Start a 30-day free trial. After trial: $3.99 p/m
  • Start a 30-day free trial. After trial: 39.99 kr p/m
  • Start a 30-day free trial. After trial: 39.99 kr p/m
eLib
Unlock your organization's learning potential
Click here!

Corporate eLibrary

Discover our employee learning solutions

About the book

  1. Description
  2. Content

Description

Access 2010 is a powerful database application that allows users to produce tables, forms, queries and reports within a database it can also contain calculations, graphs, pictures and files. This ebook is the final part of a series of four ebooks. The first part explained the basics of Access 2010. In the second part you have learned how to create tables and queries in Access 2010. In the third part you learned how to create forms and reports in Access 2010. The final part will learn you more about macros and how to import and export in Access 2010.

A macro is a set of commands that can be played back at will to perform a given task. These tasks can be something simple from inserting your name and address into a document to something much more complex such as launching a program, copying data from it, activating another program, pasting the data into it and repeating this several times. Tasks performed by macros are typically repetitive in nature allowing significant savings in time by executing the macro instead of manually repeating the commands. In the chapter about macros you will learn how to use Access 2010 to create and run a macro, to apply a macro to an event and to convert macros to visual basic.

One of the most useful features of Access is its ability to interface with data from many other programs. In other office programs, you use the Save As command to save a document in another format, so that you can open it in alternative program. In Access, however, the Save As command is not used in the same way. You can save Access objects as other Access objects, and you can save Access databases as earlier versions of Access databases, but you cannot save an Access database as, say, a spreadsheet file. Likewise, you cannot save a spreadsheet file as an Access file (.accdb). Instead, you use the commands on the External Data tab in Access to import or export data between other file formats. In this ebook you will learn step by step how to import or link to data in another format, how to export data to another format and how to add data collected via e-mails to your database

On installation of Access, the installation of sample databases like Northwind is an option.

Content

  1. Section 8 Macros
    1. Macro definitions
  2. Section 9 Printing
    1. Printing a Database Object
  3. Section 10 Other advanced Features
    1. Web Database
    2. Split a Database
    3. Import and export data
    4. Add data collected via e-mails to your database
  4. Section 11 Getting Help
    1. To Access Help
  5. Section 12 Access 2010 Specifications
    1. Discontinued & modified functionality in 2010
    2. Database specifications for Access 2010
    3. Project specifications
    4. Keyboard shortcuts for Access
This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with EU regulation.