Skip navigation

Bookboon.com Download free eBooks and textbooks

Choose a category

Access 2010: Part II

Tables and Queries

Access 2010: Part II
4.7 (57 reviews)
ISBN: 978-87-7681-858-6
1 edition
Pages : 201
  • 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 second part of a series of four ebooks. In the first part Access 2010: Learn Access you found an introduction to Access 2010. In this part you will learn how to create tables and queries.

Tables are the main objects used in databases. (Without tables, and thus without data, you don’t have much of a database!) In Access 2010: Part I you learned that a table contains one or more records (or rows of data) and a record contains one or more fields. In this ebook you will go a step further and learn much more about the usage of tables, including how to build them from scratch. Further you will learn how to set field properties, create lookup fields and relate tables.

A query is a question that is asked of a database control program about the data it contains. We specify what particular fields we are interested in finding out, tell the database where to look for those fields, and specify any conditions under which to search. In this ebook you will learn to understand the use of queries, to use the query wizard and to build basic queries in Query design. Furthermore you will learn more about applying criteria and building calculations.

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

Content

  1. Section 4 Tables
    1. Creating Tables
    2. Primary Key
    3. Format Data and appearance (Design View)
    4. Relationships
    5. Controlling Data EntryIn a Table.
    6. Creating A Lookup Field
    7. Enter Data In a Table
    8. Formatting A Table in Datasheet view
    9. Working with records
    10. Sorting and Finding Data In a table
    11. Filtering data in a table.
    12. Using Advanced Filter Options
    13. Changing Field Data Types
  2. Section 5 Queries
    1. Creating Queries
    2. Basic Query use.
    3. Filtering a Query
    4. Select Queries and criteria
    5. Using Multiple Tables In Queries
    6. Building queries on queries
    7. Parameter Queries
    8. Crosstab Query
    9. Action Queries
This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with EU regulation.