Creating a Q&A Database

I am competent with most things computer wise but have never delved into the Access world and to be honest, I'm not 100% sure the answer will even be Access as I have only been told this program will be suitable. But. I shall pose my query anyway.

I work in a call centre in England and am trying to create a Q&A Database. I have tried looking online but can't seem to find what I am looking for.

The idea is - I want the agents in the call centre to be able to type key words or phrases in and answers will be presented. Simple concept really but can't seem to manage it.

Sponsored Links:

Related Topics

Database Fundamentals
Introduction to MS Access and Database, hierarchy used in Access, creating/opening an existing database, creating tables, defining relationships, creating reports and forms, difference between file processing & dbms, characteristics and advantages of DBMS, types of end users and more...


Creating multifunctional database
being away from it for several years. I have been tasked with creating databases to track skills, certifications and licenses for all of our employees. I am in the middle of creating the Skills database for our employees but I was wondering if I could put all of what we are looking to track into one database. Everything would tie back to the employee ID. I would like to have a form that would contain only the Employee Info (Emp ID, Emp Name & Craft Code) and then have 3 command buttons that would link to the different tables for each of the criteria that we are tracking


Using Ampersand in Attachment File Name
I am creating a database for a company named G&G and they use "G&GFileName" format for most of their company documents. Is there a way to use the attachment feature with a filename that includes the &?


Creating User Profiles in Access 2007
Let me start out by saying that I am not the least bit concerned with securing my database. However, because user profiles are a part of security (or at least that is the extent of my limited understanding of them) I am posting in this subform.

All I want is for access to recognize the name of the person who is currently using the database. The reason is that I have a memo section that is used for storing notes made by the user. Each entry is stamped with VBA code as follows:

Me.Memo = Me.Memo.Value & vbCrLf & CurrentUser() & ": " & Me.Text145.Value & " - at " & Now() & " : "

Thus, I just want the memo section to properly identify the person - or currentuser() - leaving notes.

I have created a basic login screen using [LINK]. If only I could somehow tell VBA to recognize the name of the person who has logged on.


Create Backup Of Access 2010 Database
Creating backup of databases is the most important thing and must not be overlooked. Access 2010 offers a simple and easy way of creating backup of database you’re working on. To begin, open the Access 2010 database and close down all table fields. Now on File menu, click Save & Publish.


SQL Running Behind the Scenes
I inherited a database (yet again) and whenever the form loads, I get
Run time error 9
Subscript Out of Range

On this line of SQL

SqlValues = SqlValues & "," & ID(i) & ",'" & CtcName(i) & "','" & Title(i) & "','" & Address(i) & "','" & Phone(i) & "','" & Interviewed(i) & "','" & DM(i) & "'"

Can someone tell what the issue is or if you need further let me know what else I would need to display


How to remove &NBSP from my form
My form shows &NBSP and &AMP although the data looks fine in the database as a memo field (rich text).

Example:
1.Eliminate funding for Web Q&A on the city website.
2. Eliminate the citizen and visitor tracking software that is interfaced with the INFO database.  This software is used  for questions and inquiries for city services. With the upgrades to the city's new website, Web Q&A is no longer a compatable tool.

How do I fix this in my form? It is also affects all my reports.


SQL Running Behind the Scenes
I inherited a database (yet again) and whenever the form loads, I get Run time error 9
Subscript Out of Range

On this line of SQL

SqlValues = SqlValues & "," & ID(i) & ",'" & CtcName(i) & "','" & Title(i) & "','" & Address(i) & "','" & Phone(i) & "','" & Interviewed(i) & "','" & DM(i) & "'"


Formatting an email
Ive been using the outlook.application method to email results from various queries like this:

.Body = "1)" & Chr(13) & Chr(13) _
& s1 & Chr(13) _
& "2)" & Chr(13) & Chr(13) _
& s2 & Chr(13) & Chr(13) _
& "3)" & Chr(13) & Chr(13) _
& s3 & Chr(13) & Chr(13) _
& "4)" & Chr(13) & Chr(13) _
& s4 & Chr(13) _
& "5)" & Chr(13) & Chr(13) _
& s5 & Chr(13) & Chr(13) _
& "6)" & Chr(13) & Chr(13) _
& s6

It works perfectly but I would rather the results be shown in tables, like when you copy and paste selected cells from a select query into an email.


Former marine wasnt made to design access
So I volunteer for Veterans village of San Diego which help veterans. Being a former Marine infantryman myself I am little out of my element creating an access database. I have posted the link to Google docs to show what I have so far. Ive done a majority of the graphical layout and basic programming but some of the more complex features I have no idea how to go about doing. If any one has some free time and expertise in access I would be very appreciative for any help you could lend. Thanks

Database is here, its a little big sorry:

https://docs.google.com/leaf?id=0B9mdwEkZMipINjI4Mzg3YjAtMjhiYS00MTRlLThlN TYtMjc5NzYyYmNlMzQz&amp;hl=en">https://docs.google.com/leaf?id=0B9mdwEkZMipINjI4Mzg3YjAtMjhiYS00MTRlLThlN TYtMjc5NzYyYmNlMzQz&hl=en</a&gt


Risk/Issues Database
I am creating a Risk/Issues database for a construction company I work for. Within this database, there is a table for Issues, RFIs, & Change Orders so that each Project logs the aboverelated information and creates the associated reports.

I have most of the database constructed without too many issues but have came across one thing that I can't seem to find or get established.

In theory, Each RFI requires an Issue but an Issue may have more than one RFI and Each CO also requires an Issue. Issues may not always have an RFI or CO.

I would like to have a way of ensuring that each new RFI &/or CO is assigned to an Issue.


Risk/Issues Database
I am creating a Risk/Issues database for a construction company I work for. Within this database, there is a table for Issues, RFIs, & Change Orders so that each Project logs the above related information and creates all the associated reports.

I have most of the database constructed without too many issues but have came across one thing that I can't seem to find or get established.

In theory, Each RFI requires an Issue but an Issue may have more than one RFI and Each CO also requires an Issue. Issues may not always have an RFI or CO.

I would like to have a way of ensuring that each new RFI &/or CO is assigned to an Issue. Is there a way to code this


Creating a workbook from Access
hope you're all well.

Hopefully a quicky, not sure what I'm missing.

I am creating a workbook a outputting an array after some of its values have been run through some parameters.

My code for creating the and naming the workbook:

Set wbOutput = xlApp.Workbooks.Add With wbOutput
.Name = .Path & "\NHH GMTV Forecast " & Now() End With

I get the compile error "Can't assign to a read only property


Relationship & Query Interconnect
Access 2010 is very useful tool for designing database and provides intermediate-level data mining. It has done and continues to do wonders especially when it comes to managing, creating and most importantly making use of Relational Database up to its acme. This post will cover how relationships and queries interconnect to make database more dynamic.


Dymo Printer labels to print correctly
I've been struggling for some time to get Dymo labels to print correctly. They're rotated 90 degrees, and the only posts I could find showed no way of resolving the issue.

I corrected the problem by creating a label with only one text box. In that text box, I concatenated all the values I needed on the label, and then set the property of the entire text box to vertical (on the "Other" tab of the text box properties). Here's what's in my text box:

[FirstName] & " " & [LastName] & chr(13) & chr(10) & [Address1] & chr(13) & chr(10) & [Address2] & chr(13) & chr(10) & [City] & ", " & [Province] & " " & [Postal]

Who knew that learning the ASCII codes for Carriage Return (chr13) and Line Feed (chr10) would actually come in handy at some point?

A simple, elegant solution to anyone looking to rotate several lines of text within any report in Access.


Download in MS Word file format (.doc)
This tutorial has been designed to give an introduction to some of the basic features of MS Access. The tutorial will cover the following topics:
Creating a database; Creating tables; Changing the Field Properties in the tables; Adding Lookup Tables; Creating relationships; Adding Passwords to the database; Creating simple forms using the Form Wizard; Adding graphics and creating customized forms; Creating forms using multiple tables; Creating reports using the report wizard; Formatting reports; Creating Switchboards.


Schedule Conflict Coding
on a database I am creating. I need to write a vb program which detects if the current inputs already exists or if it is in conflict with existing records.

My method is I create a query from the current inputs

qrySQL= Select From [tblRegis].Subject
Where [tblRegis].TimeIn = '" & txtTimeIn & "'
And [tblRegis].Days = '" & cboDays & "'
And [tblRegis].Room = '" & cboRoom & "'
qd.SQL = qrySQL

(lets assume that the query is created)

after that I place the field value of subject into strSubject using DlookUp on the query
If it is null it means that there are no similar fields in the tblRegis and there is no conflict.
am I missing anything?because as of now I am not receiving proper outputs.

If you guys have a solution for this as simple as possible


6 key considerations when creating Access 2007 databases
In this article:
1. Creating a database from a template
2. Migrating a database from a previous version of Access
3. Importing information from other sources
4. Controlling the features available to database users
5. Assigning a password to a database
6. Securing a database for distribution
Creating the structure for a database is easy. But an empty database is no more useful than an empty document or worksheet. It is only when you fill, or populate, a database with data in tables that it starts to serve a purpose. As you add queries, forms, and reports, it becomes easier to use. If you customize it with a switchboard or custom categories and groups, it moves into the realm of being a database application. This article discusses six key things you should consider when creating a database application by using Microsoft Office Access 2007.


Return full value of field in Query?
I am creating a query to give each student in my database a Student Number based on values for their record in the Student tbl.

My query creates a calculated field: Student Number where:

Student Number: "BR" & [Joining School ID] & "-" & Right([Joining Year],2) & "-" & [Student ID]

This gives something like: BR101-11-1. However, what I would like is BR101-11-00001 with the full value o the Student ID field. Is there a function I can use to get the full value with all the 0000s?


Database with 20k-40k items per day.
I am only new to Access & need to create a database that will record 20k-40k transactions per day. Would keeping all the transactions in the one database eventually reach maximum capacity? I have tried creating a database with 6 month's worth of transactions but it became very slow when running queries searching for a single transaction.
My queries would range from searching for 1 transaction to creating monthly tables. Should I create monthly databases or tables and create relationships with them. If so, would a primary key be necessary?