Access Tutorial

Microsoft Access is a 32-bit relational database management system (RDBMS). Access combines its database capabilities with the ability to build a complete front-end user application. This differs from Visual Basic and Powerbuilder as these programs require additional programming to integrate database management facilities in to the application.

Access duplicates in a PC environment what used to be using C and a lot of SQL. Although you can still write your own SQL statement, there is a windows driven query facility that makes creating queries much easier. Such not to be limited to a PC environment, Access also has the option of allowing you to connect to any databases on client/server database like an Oracle server.

Step Number Description
One Creating a New Database.
Two Creating a new table and entering values.
  1. List of Items on Screen
  2. Data Types
  3. The Market Database
  4. Close the Table
  5. Entering Values in the Table
Three Creating a new query.
  1. Creating Queries
  2. Selecting the Fields
  3. Running the Query
  4. Sorting the Results
  5. Showing a field
  6. Removing a field from the query
  7. SQL View
  8. Save the Query
  9. Closing the Query window
Four Specific criteria for a query
  1. Simply Query Criteria
  2. Dealing with Numbers
  3. Dealing with Text
Five Advanced criteria for a query
  1. OR Conditional Query
  2. AND Conditional Query
  3. Calculation Query
Six Creating Forms
  1. Creating the Form
  2. Form Screen
  3. Adding a Label Object
  4. Adding a Text (Control) Object
  5. Form View
  6. Moving in the Form View
  7. Saving the Form
Seven Modifying Objects on Forms
  1. Selecting Objects
  2. Resizing Objects
  3. Moving Objects
  4. Changing the Font and Alignment of an Object
  5. Changing the Colour of an Object
  6. Removing an Object
  7. Properties of an Object
Eight Price and Quantity Form
  1. Creating the Form
  2. Creating a Title for the Form
  3. Placing Field from Products table on Form
  4. Adding "Quantity Received" Text Object
  5. Adding "Retail Price" Text Object
  6. Adding "Total Quantity" Text Object
Nine Price and Quantity Form (con't)
  1. Initializing a Field
  2. Adding a "Save" button
  3. Adding a "Close" button

Lets begin

edited by U.A.C Media

Hosted by U.A.C Hosting