Sawka.com Logo

 

About Access

  • What is Access?
 <database> A relational database running under Microsoft Windows. Data is stored as a number of "tables", e.g. "Stock". Each table consists of a number of "records" (e.g. for different items) and each record contains a number of "fields", e.g. "Product code", "Supplier", "Quantity in stock".

Access allows the user to create "forms" and "reports". A form shows one record in a user-designed format and allows the user to step through records one at a time. A report shows selected records in a user-designed format, possibly grouped into sections with different kinds of total (including sum, minimum, maximum, average).

There are also facilities to use links ("joins") between tables which share a common field and to filter records according to certain criteria or search for particular field values.
 
  • What you need to know?
  • Tell me more.
  
  • Test Me.
  

 

 

 

Access 2000 Core

Planning and Designing Databases

  • Determine appropriate data inputs/outputs for your database
  • Create table structure
  • Establish table relationships

Working with Access

  • Use the Microsoft Office Assistant
  • Select an object using the Objects Bar
  • Print database objects (tables, forms, reports, and queries)
  • Navigate through records in a table, query, or form
  • Create a database (using a wizard or in-design view)

Building and Modifying Tables

  • Create tables by using the Table Wizard
  • Set primary keys
  • Modify field properties
  • Use multiple data types
  • Modify tables using Design View
  • Use the Lookup Wizard
  • Use the Input Mask Wizard

Building and Modifying Forms

  • Create a form with the Form Wizard
  • Use the Control Toolbox to add controls
  • Modify Format Properties (font, style, font size, color, caption, etc.) of controls
  • Use form sections (headers, footers, and detail)
  • Use a Calculated Control on a form

Viewing and Organizing Information

  • Use the Office Clipboard
  • Switch between object views
  • Enter records using a datasheet
  • Enter records using a form
  • Delete records from a table
  • Find a record
  • Sort records
  • Apply and remove filters (filter by form and filter by selection)
  • Specify criteria in a query
  • Display related records in a subdatasheet
  • Create a calculated field
  • Create and modify a multitable select query

Defining Relationships

  • Establish relationships
  • Enforce referential integrity

Producing Reports

  • Create a report with the Report Wizard
  • Preview and print a report
  • Move and resize a control
  • Modify Format Properties (font, style, font size, color, caption, etc.)
  • Use the Control Toolbox to add controls
  • Use report sections (headers, footers, and detail)
  • Use a Calculated Control in a report

Integrating with Other Applications

  • Import data to a new table
  • Save a table, query, or form as a Web page
  • Add Hyperlinks

Using Access Tools

  • Print database relationships
  • Back-up and restore a database
  • Compact and repair a database

 

 

Microsoft Access 97 Expert

Creating a Database

  • Plan a database
  • Create a table
  • Enter data into a table
  • Modify data in a table
  • Enter data into a form
  • Navigate through a table
  • Delete data from a table

Using Forms

  • Create a simple form
  • Modify a form
  • Create controls on a form
  • Modify controls
  • Add a record using a form
  • Show related records on a form

Modifying a Database

  • Open a database
  • Modify field properties
  • Modify field layout
  • Modify the presentation of a database

Viewing Information

  • Present information in a chart
  • View information in a form
  • View multiple records
  • Switch between views

Organizing Information

  • Sort data on single fields
  • Sort data on multiple fields

Locating Information

  • Find a specific record
  • Create a simple query
  • Create a query with multiple criteria
  • Add filters (selection and form)
  • Remove filters

Refining Results of a Query

  • Add fields to a query
  • Remove fields from a query
  • Sort a query
  • Join tables in a query
  • Remove joins in a query
  • Save a query

Analyzing Data

  • Build summary queries
  • Calculate fields
  • Set cross-tab queries

Creating Sub Forms

  • Identify appropriate use for sub forms
  • Add a record with a main form
  • Add records with sub forms
  • Merge two tables into a form

Building a Relational Database

  • Identify relationships
  • Relate tables

Integrating Information from Other Applications

  • Import data
  • Link data
  • Add pictures to records

Utilizing Web Capability

  • Create hyperlinks
  • Build order forms for Internet use

Maintaining Data Integrity

  • Identify criteria for data integrity
  • Validate text
  • Set required properties
  • Set validation rules
  • Set look up fields
  • Use expressions in calculated controls

Building a Form for Other Users

  • Title a form
  • Modify form design
  • Improve accuracy in forms
  • Enhance design of a form

Producing Reports

  • Create a report
  • Modify a report
  • Label a report
  • Customize headers and footers
  • Make a calculation on a report
  • Group data in a report
  • Sort data in a report
  • Add custom pages

Printing

  • Print a report
  • Print a form
  • Print the result of a query

Creating a Database

  • Plan a database
  • Create a table
  • Enter data into a table
  • Modify data in a table
  • Enter data into a form
  • Navigate through a table
  • Delete data from a table

Using Forms

  • Create a simple form
  • Modify a form
  • Create controls on a form
  • Modify controls
  • Add a record using a form
  • Show related records on a form

Modifying a Database

  • Open a database
  • Modify field properties
  • Modify field layout
  • Modify the presentation of a database

Viewing Information

  • Present information in a chart
  • View information in a form
  • View multiple records
  • Switch between views

Organizing Information

  • Sort data on single fields
  • Sort data on multiple fields

Locating Information

  • Find a specific record
  • Create a simple query
  • Create a query with multiple criteria
  • Add filters (selection and form)
  • Remove filters

Refining Results of a Query

  • Add fields to a query
  • Remove fields from a query
  • Sort a query
  • Join tables in a query
  • Remove joins in a query
  • Save a query

Analyzing Data

  • Build summary queries
  • Calculate fields
  • Set cross-tab queries

Creating Sub Forms

  • Identify appropriate use for sub forms
  • Add a record with a main form
  • Add records with sub forms
  • Merge two tables into a form

Building a Relational Database

  • Identify relationships
  • Relate tables

Integrating Information from Other Applications

  • Import data
  • Link data
  • Add pictures to records

Utilizing Web Capability

  • Create hyperlinks
  • Build order forms for Internet use

Maintaining Data Integrity

  • Identify criteria for data integrity
  • Validate text
  • Set required properties
  • Set validation rules
  • Set look up fields
  • Use expressions in calculated controls

Building a Form for Other Users

  • Title a form
  • Modify form design
  • Improve accuracy in forms
  • Enhance design of a form

Producing Reports

  • Create a report
  • Modify a report
  • Label a report
  • Customize headers and footers
  • Make a calculation on a report
  • Group data in a report
  • Sort data in a report
  • Add custom pages

Printing

  • Print a report
  • Print a form
  • Print the result of a query