Categories Pricing Corporate
Professional eBook

Access 2010: Part IV

Macros, Import and Export

24 Recensioner
(24 ratings)
Language:  English
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.
Professional Plus subscription free for the first 30 days, then $8.99/mo
Få åtkomst till boken på vår läsplatta. Ingen reklam i boken.

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.

  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
About the Author

Stephen Moffat, The Mouse Training Company

Stephen Moffat has been a teacher in one form or another most of his life.

In 1998 Steve completed his studies and qualified with many training qualifications and started IT training for a little known company in the north of England. Restricted by company politics he quickly went freelance and never looked back. Training Microsoft Applications in the Public and private sector He moved to London and worked for many prestigious firms in the square mile and further afield. Training not only in England but working for international companies based in Europe saw him in several European countries training there.

Writing manuals since the early office versions found him basing his manuals on his classroom and mentoring experience shaping the structure of the manuals he wrote adding many topic hints not found in standard how to manuals.

Fully experienced with all Microsoft Applications Saw his manual writing, expand from the standard Word, Excel and PowerPoint to applications like Project and Visio.