Access 2010: Part III

Forms and Reports

:
( 27 )
154 pages
Idioma:
 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.
Éste es un eBook de negocios
30 días de prueba gratis
Suscripciones corporativas gratis durante los primeros30 días, luego $5.99/mo
 
Compra el eBook :
No hay publicidad dentro del libro
Últimos agregados
Sobre el autor

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...

Description
Content

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 third part of a series of four ebooks. The first part consists of an introduction to Access 2010. In the second part you have learned how to create tables and queries in Access 2010. In this part you will learn how to create forms and reports.

Simply put, a form is an easy way to input data into a database. It contains fields that let you type the information for each field in, it can have an input mask which will make the field look for example like an empty phone number field. A form as well can contain a required field that you must enter in order for the database entry to be valid. Forms in a database can be compared to paper forms: information is written on a form, and the information on the form is entered into a database or kept on file in some way for retrieval later. Access can make some very powerful and functional forms for use with your databases. In this ebook you will learn how to create forms with Access 2010 by using a wizard or from design view.

A report is a formal way of displaying data that has been retrieved from a query. Reports, like forms, are completely customizable and easy to create by using a Wizard. If the Wizard is not specific enough, you can change the colour, layout, style, and more, to suit your tastes. In this ebook you will learn how to create a report with Access 2010, you as well will learn how to add and format controls and how to set up a report for printing.

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

  1. Section 6 Forms
    1. Creating Forms
    2. Create form Alternatives
    3. Touring Design View To Modify Your Form
    4. Build form in design view
    5. Bind Form to data source
    6. Basic Field Controls
    7. Formatting Controls
    8. Form Types
    9. Layout View
    10. Modal and Pop-Up Forms
    11. Advanced Features for form and controls
    12. Formatting Your Forms
  2. Section 7 Reports
    1. Working with Reports
    2. Common Report Tasks
    3. Header and Footer Options
    4. Create report in design view
    5. Subreports
    6. Formatting Reports