L7+-+06A+Using+Databases

L7+-+06A+Using+Databases - ACCOUNTING INFORMATION SYSTEM...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
ACCOUNTING  INFORMATION SYSTEM Using Databases
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ACCESS OBJECTS  Tables   Queries  Forms  Reports
Background image of page 2
A query is a stored definition that specifies  all tables involved in data retrieval which columns are to be retrieved which records are to be included in the result and any calculations to be performed  Posing a question which returns an answer in the  form of a virtual table known as  dynaset. Access  uses a query method call Query by Example  (QBE) Usefulness of queries:  helpful for combining info from several tables into a single,  cohesive result  provide a way to reduce the data volume by returning and  displaying only the subset of table rows in which you are  interested Used to summarize data, displaying only the aggregate  results QUERIES
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
  Types of queries:   Selection Queries retrieve rows from tables  the most common queries, therefore  they are simply called “queries”   Action Queries: make changes to a database’s tables, such as creating a new table, removing  records, updating one or more fields, and adding new records to an existing  table  include: o Make-table Query:  retrieves a subset rows from one or more tables and  save the dynaset as a table o Update Query:  allows you to change existing database information Cannot be reversed Always select Datasheet View before running it to check the scope of your  changes o Delete Query:  selects and removes records from one or more tables o Append Query:  adds records from a table or query to the end of another  table o Crosstab Query:  summarizes and combines data from more than one  source to present a compact, spreadsheet-like result    QUERIES
Background image of page 4
CREATING A ONE-TABLE QUERY You can form one-table queries by  selecting a table and then placing column  names in the QBE grid corresponding to  the columns you wish to see.  You can specify selection criteria to  restrict the returned rows to those which  satisfy the criteria
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
SAVING A QUERY Queries can be saved and re-executed 
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 20

L7+-+06A+Using+Databases - ACCOUNTING INFORMATION SYSTEM...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online