Topics Search

Basic Skills and Tools Using Access

Basic Skills and Tools Using Access
Views: 56
1. Describe the primary functions using Microsoft Access.
2. Describe the steps for creating a new database file using Microsoft Access.
3. Describe the steps for creating and modifying a table and fields using Microsoft Access.
4. Describe the steps for creating relationships between tables using Microsoft Access.
(pdf file).
Sponsored Links:

More topics

 

Test your Access skills

Preview
Do you know your Access skills? Test your knowledge of MS Access 2003 and 2007 Features! Assess your computer skills or analyse your IT training needs with one of the following tests...
 

Multiple values comparison.

Preview
I got 3 tables called Skills, Employee and Position. Tables Employee and Position have Skills column which is multiple valued.
I need to fetch every employee who has set of skills that is required in given Position. What I am trying to do is to compare set of skills in Employee and Position and select employees with full match of skills.

Below, I attached my ERD diagram of database
 

Multiple values comparison.

Preview
I got 3 tables called Skills, Employee and Position. Tables Employee and Position have Skills column which is multiple valued.
I need to fetch every employee who has set of skills that is required in given Position. What I am trying to do is to compare set of skills in Employee and Position and select employees with full match of skills.

Below, I attached my ERD diagram of database
 

Project Involving Table Relationships

Preview
So I've been given this project where I have to develop an access 2007 database where a query can be used to match employees to available projects based on employee skill set and required project skills.

How should I go about this?

I've tried making a bunch of tables and relating them, but its not matching employee skills to project skills
 

Access 2007 training courses

Preview
A roadmap to Access 2007 training: 1. Get familiar with Access. 2. Build your first database. 3. Start managing your data, fast. 4. Deepen your Access skills. 5. Learn general Office skills.
 

Form design question

Preview
I'm looking for some high-level guidance here. I have two tables, tblVolunteers and tblSkills. tblVolunteers contains a lookup column listing every skill for each volunteer. I'm writing a form that has a listbox with all skills; I want the user to highlight whatever skills she's interested in, and the second listbox will contain all volunteers that have those skills.

What's the best way to do this? Do I bind some VBA to the AfterUpdate event of the skills listbox, which performs a query, and pushes the results into the second listbox? Or do I set the row source of the volunteers listbox to a query whose WHERE clause is based on the skills listbox? Or something else?

How would you approach this
 

How to query boolean values from table

Preview
I am kind of new to Access and SQL in General and have a table of employee skills and have them as boolean values. I want to query the table and find out which columns have been checked also how would I have a form ask to this query so someone could look for certain skills in a emloyee and have the query return employees who have some or all of the skills.
 

Having problems with nested iif

Preview
I have created a database that records whether our staff have specific skills relating to the use of software program. Some skills are mandatory for some staff to have and some are optional.

We plan to assess annually whether they possess each skill. I want to be able to report on how many staff have all their mandatory skills at each assessment but I run out of space in the expression builder in the query that I was building and I don't have much experience with vba.

The code I was using in the expression builder of my query looks something like this.

Proficient: (IIf([Skills]="CHANGE PASSWORD" And [Skills]='OUT OF OFFICE' And [Skills]='CHANGE PERSONAL INFORMATION'.,"Proficient","Not")).

In this example I stopped at three skills but there could be up to 30 that would be necessary for a person to be deemed proficient at their assessment and that is why I am running out of space in the expression builder window.
 

Introduction to Microsoft Access 2003

Preview
Our goal is to assist you to learn the software, understand some basic concepts and show you some tips and techniques so you can develop your database management skills over time. The five workshops are: Introduction to Access; Access Queries; Access Reports; Access Database Design; Access Form Design. (pdf file, install to Acrobat Reader to read this tutorial).
 

Vlook function in Access

Preview
I want to make a database for my workshop tools. There are three catagories of tools. workshop equipment, common tools and hand tools.
I want to know how we can use Vlookup function same as in attched excel file.
If I select in catagory field workshop tools in the tools name field should show me a dropdown list only for workshop tools.If I select hand tools field it should show only hand tools name in tool name field