Topics Search

Creating a Q&A Database

Creating a Q&A Database
Views: 5
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:

Similar posts...


Creating User Profiles in Access 2007

Creating User Profiles in Access 2007 Icon
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

Create Backup Of Access 2010 Database Icon
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.

Risk/Issues Database

Risk/Issues Database Icon
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.

Formatting an email

Formatting an email Icon
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.

Relationship & Query Interconnect

Relationship & Query Interconnect Icon
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.

6 key considerations when creating Access 2007 databases

6 key considerations when creating Access 2007 databases Icon
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.

Importing Data causes Numeric Overflow on Linked table

Importing Data causes Numeric Overflow on Linked table Icon
I am using Access 2003. I created a blank database & then imported over a table including the data, delete all & update queries & macro that runs all this.

all works just fine.

I then returned to the main database I copied this table from & deleted the table. Next I linked to the table in the new database (Access 2003 & in the same folder on my HD). The link works just fune as I can see the data when I open the table.

Database with 20k-40k items per day.

Database with 20k-40k items per day. Icon
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?

Survey Database Table Design

Survey Database Table Design Icon
I'm creating a survey database (Access 07). I have multiple tables and was wondering if you could help me with the design. Currently I have a tblQuestions & tblAnswers which contain only the questions themselves and the possible answers, respectively.

Would you recommend a 3rd table which ties the responses from the tblQuestions & tblAnswers together? Forsome reason I'm stumped by this and I'm sure it's a very easy solution.

Submitted via EggHeadCafe - Software Developer Portal of Choice Design Patterns for .NET

Return full value of field in Query?

Return full value of field in Query? Icon
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?