↓
 

The Place For Free Online Training Courses

Improve Your Career Prospects

  • Home
  • Office Software
    • Understanding Spreadsheets
    • Advanced Spreadsheets
    • Understanding Word Processing
    • Advanced Word Processing
    • Understanding Presentations
    • Advanced Presentations
    • Understanding Databases
    • Advanced Database
    • Math
  • FaQ
1 2 >>

Monthly Archives: August 2017

Post navigation

← Previous Post

Understanding Databases – Create and Name a Form

The Place For Free Online Training Courses

The simplest way to create a new form is to use the ‘Wizard’. Click the ‘Forms’ section in the Database area of the main window and select ‘Use Wizard to Create Form’ from the Tasks area. Use the drop-down menu … Take lesson

Understanding Databases – Forms

The Place For Free Online Training Courses

Understand that a form is used to display and maintain records. Forms display records one at a time in a format that can be customized. Rather than reading the data from a table, it can be laid out in a … Take lesson

Understanding Databases – Edit and Run a Query

The Place For Free Online Training Courses

Edit a query: add, modify, remove criteria Click the criteria you want to modify or remove, highlight it then press delete to remove or type to modify it. To add criteria in another field, simply click on the Criterion cell … Take lesson

Understanding Databases – Create a conditional query

The Place For Free Online Training Courses

Add criteria to a query using ‘NOT’ logical operator From the Queries area of the main window, right click the query and click ‘Edit’. In the Criterion row, add criteria that uses the ‘NOT’ logical operator, e.g. in Description field … Take lesson

Understanding Databases – Modify Reports

The Place For Free Online Training Courses

Change arrangement of data fields and headings in a report Click ‘Reports’ from the Database area of the main window and right click the report you want to change in the Reports area. Click ‘Edit’ from the drop down menu. … Take lesson

Understanding Databases – Create a named two-table query

The Place For Free Online Training Courses

To create a two-table query, first make sure you have created a second table. The two-table query will use the ‘Company employees’ table created in a previous tutorial. Use the table design view to create a table containing personal phone … Take lesson

Understanding Databases – Create a named single table query

The Place For Free Online Training Courses

Queries are used to extract and analyse data from tables. Click on the Queries icon, then select Create Query in Design View. The single table query will use the ‘Company employees’ table created in a previous tutorial. In the ‘Add … Take lesson

Understanding Databases – Retrieving Information

The Place For Free Online Training Courses

Use the search command to find specific data in a field This tutorial demonstrates how to find specific records within a table. This won’t cover forms or reports, which can do the same thing but display the data in a … Take lesson

Understanding Databases – Managing Tables

The Place For Free Online Training Courses

Set a field as primary key To set the primary key, right-click the grey box to the left of the field you want to set as primary key. Check the ‘Primary Key’ option and a yellow key symbol will appear … Take lesson

Understanding Databases – Tables Design

The Place For Free Online Training Courses

Create a table To create a table, click ‘Tables’ in the Database area. Then click ‘Create Table in Design View’ from the Tasks area to open table design window. In this example, we’re going to create a table that holds … Take lesson

Post navigation

← Previous Post


  • Terms and Conditions
  • Privacy Policy
  • Site Map
©2021 - The Place For Free Online Training Courses Privacy Policy
↑