↓
 

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
  • Learn Computer Skills
    • Basic Computer Skills
    • Common Tasks
    • Intermediate Computer Skills
  • Website Building
    • Web Building Lessons
    • Using WordPress
  • Business Tutorials
    • Management
    • Career Tutor
  • FaQ
1 2 >>

Monthly Archives: February 2018

Post navigation

← Previous Post

Advanced Database – linked subform

The Place For Free Online Training Courses

Create, delete a linked subform. A subform allows you to display associated data from a different table within a form. Create a new form using the wizard. On the first step, add all of the fields from the table ‘Jobs’, … Take lesson

Advanced Database – sequential tab order

The Place For Free Online Training Courses

Modify sequential tab order of controls on a form. You may need to change the tab order of a form, for instance if you add a new response box or want to give certain fields priority over others. Right click … Take lesson

Advanced Database – bound controls: option group

The Place For Free Online Training Courses

Create, modify, delete bound controls: option group Open the car and owner detail form in design mode. We are going to create options for the title field to save time typing them out. The options are going to be Mr, … Take lesson

Advanced Database – bound controls: check box

The Place For Free Online Training Courses

Create, modify, delete bound controls: check box For this example, we need to set up a new form. Start the wizard and create a form from ‘Car and owner details’ including all the fields. Then open this in design mode … Take lesson

Advanced Database – bound controls: list box

The Place For Free Online Training Courses

Create, modify, delete bound controls: list box A list box is similar to a combo box, but you cannot enter values manually. They are a good option if you want to tightly control which values can be entered for a … Take lesson

Advanced Database – bound controls: combo box

The Place For Free Online Training Courses

Create, modify, delete bound controls: combo box Replace the Staff Number entry box with a Combo Box. A combo box allows you to select from a list or manually enter data. Right click and select ‘Control’ You have the options … Take lesson

Advanced Database – bound controls: text box

The Place For Free Online Training Courses

Create, modify, delete bound controls: text box We are going to use the form ‘Jobs Entry’ that we created in an earlier lesson. Right click on Jobs Entry form and select ‘Edit’ to open design view. Hold CTRL and right … Take lesson

Advanced Database – Group information in a query using functions.

The Place For Free Online Training Courses

Add a ‘Staff Number’ field to the Job Hours table and fill in the Staff Numbers from the jobs table. We could have used a join to link the Staff Number field between the two tables, but grouping information in … Take lesson

Advanced Database – Create and name a calculated field that performs arithmetic operations.

The Place For Free Online Training Courses

For this example we are going to create a new table called ‘Job Hours’ Create and save it with the data shown (NB. Set decimal places to 2 for the Normal and Overtime Hours) Create a new query and add … Take lesson

Advanced Database – Show highest & lowest range of values in a query.

The Place For Free Online Training Courses

First, we are going to try and display the 3 highest priced jobs. Create a new query and add the table Job Costs In the first column display all fields *. In the second column choose the Cost field and … Take lesson

Post navigation

← Previous Post

Latest Lessons

  • Advanced Database Quiz
  • Advanced Database – Assign/attach a macro to a control
  • Advanced Database – Assign/attach a macro to a command button
  • Advanced Database – Create a simple macro
  • Advanced Database – Import from existing database into a database.

Available Courses

  • Customising Your PC (5)
  • IT Training (12)
  • Learn Computer Skills (25)
    • Basic Computer Skills (12)
    • Common Tasks (8)
    • Intermediate Computer Skills (5)
  • Microsoft Certified Professional (79)
    • Disaster Recovery (5)
    • Hardware (5)
    • Installations (1)
    • Interoperability (3)
    • Introduction To Networking (25)
      • Managing Disks (9)
      • Windows Quickstart (8)
      • Windows XP Server 2003 (8)
    • Local Security (6)
    • Local Users and Groups (4)
    • Monitoring and Optimisation (5)
    • NTFS (4)
    • Printing (3)
    • Remote Desktop and Terminal Services (6)
    • Shared Folders (5)
    • TCP/IP (7)
  • Microsoft Certified Systems Engineer (86)
    • Active Directory Overview (8)
    • Active Directory Sites And Replication (5)
    • Active Directory Trusts (2)
    • Active Directory Users and Groups (4)
    • Certificate Services (6)
    • Deploying Applications (3)
    • DFS (5)
    • DHCP (5)
    • DNS (8)
    • Group Policy (5)
    • IIS (5)
    • IPsec (3)
    • Remote Access (6)
    • RIS (7)
    • Routing (6)
    • SUS (3)
    • WINS (6)
  • Microsoft Certified Technology Specialist (129)
    • Windows Server 2008 Active Directory, Configuring (78)
      • Active Directory Federation Services (3)
      • Active Directory Rights Management (3)
      • Active Directory Sites And Replication (3)
      • Active Directory Trusts (2)
      • Administration (5)
      • Authentication (5)
      • Certificate Services (9)
      • Computers (4)
      • Directory Business Continuity (5)
      • Domain Controllers (4)
      • Group Policy (4)
      • Groups (6)
      • Installation (5)
      • Integrating Domain Name System (6)
      • Lightweight Directory Services (2)
      • Users (9)
    • Windows Server 2008 Network Infrastructure, Configuring (59)
      • Configuring IP Routing (4)
      • Configuring Name Resolution (8)
      • Configuring Windows Firewall and Network Access Protection (4)
      • Connect To A Network (6)
      • Creating a DHCP Infrastructure (5)
      • Managing Files (11)
      • Managing Printers (3)
      • Managing Software Updates (4)
      • Monitoring Computers (4)
      • Protecting Network traffic with IPSec (3)
      • TCP/IP (7)
  • Office Software (287)
    • LibreOffice (285)
      • Advanced Database (54)
      • Advanced Presentations (25)
      • Advanced Spreadsheets (47)
      • Advanced Word Processing (38)
      • Base (29)
      • Calc (20)
      • Math (16)
      • Presentations (33)
      • Writer (22)
        • Mail Merge (3)
  • Uncategorized (1)
  • Website Design (22)
    • Creating websites with HTML (9)
    • CSS (6)
    • Extras (3)
    • What is the internet (4)
  • Windows Maintenance (9)
  • Wordpress (12)
  • Terms and Conditions
  • Privacy Policy
  • Site Map
©2019 - The Place For Free Online Training Courses Privacy Policy
↑