term 2

Edit 0 3 …
13/01/10

What is a database?

A data base is a place where you can put information of people, like age, birhtday, adress, etc.

What is access?

Access is a system to make the database, and work with windows.

What are key features of access?

  1. data entry and update
  2. queries
  3. reports
  4. web supports.


What we know?


  1. data
  2. information

20/01/10

What are diferebt object in access?


  • Tables
  • Queries
  • Forms
  • Reports
  • Macros
  • Modules

What are their functions?


  • Tables: stores and organizes data
  • Queries: retrieve certain data from the table through questions
  • Forms: allows you to insert information of one record at a time, it can help you choose the format and arrangement of fields.
  • Reports: summarizes and presents current table in order to include funtions in groups or as a whole, enables you to print the info.
  • Macros: can perform activities such as opening a report, running a query, or closing the database, it automates tasks
  • Modules: a collection of declarations and statements and procedures that add functionality, it also automates tasks


How to create a blank database?


3. What is a field? How to create new field?
A field is a colum in database.
Go to a database, double click on "Add new Field".
Blu ray essay.docx