Purchase Solution

Data Fields Microsoft Words

Not what you're looking for?

Ask Custom Question

Using Microsoft Word, list all of the data fields that would be needed for a sales contact database system. Think of it as an extended address book with additional fields to keep track of things that interest salespeople. The only requirements are that you must consider how to store notes about the contact, track any follow up items, and store multiple phone number for each contact. Be sure to include the field type and size. Please do not jump ahead and try to create tables. Right now I'm just looking for a list of fields. This is somewhat vague on purpose. I want you to decide what is needed in the database.
This is what I did for the above instruction. And I want someone to help me by using Microsoft Access (Word or Excel are fine if you don't have Access), create the preliminary database tables for the sales contact system from above Question. Be sure to include field type and size. Indicate what fields you believe will be primary keys, foreign keys, and indexes.

Purchase this Solution
Solution Summary

The expert examines data fields for Microsoft Words.

Solution Preview

Table: Customers
CustomerID Text 8 PK
CustomerLastName Text 12
CustomerFirstName Text 12
CustomerHousePhNo Int 7
CustomerOffciePhNo Int 7
CustomerMobileNo Int ...

Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Networking Questions

This quiz consists of some basic networking questions.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

View More Free Quizzes
Related BrainMass Solutions

  • relational database

    4307 Understanding a relational database and how to use the Microsoft Access program to create a relational database. Solution provides an introduction to relational databases and Microsoft Access.

  • Microsoft Access as a Database: Clerical Placements

    In a staffing agency application, Microsoft (MS) Access can be used to create tables that contain data of prospective and current employees, for example the following fields can be used in an "Employee" table: Last Name, First Name, Date of Birth, Address

  • Basic Programming

    Once you have designed the classes, design a program that creates an object of the ProductionWorker class and prompts the user to enter data for each of the objectââ?¬â?¢s fields. Store the data in the object and then use the objectââ?¬â?

  • Normalization of an Excel Spreadsheet

    Description and supporting image of transforming spreadsheet data into a normalized set of database tables.

  • Microsoft SQL Server 2000 Problem

    fields of your choice. 2.

  • Feasibility Analysis and System Design Methods

    To help keep better track of the recordings, you have decided to develop a simple inventory system in Microsoft Access.

  • Retail company to convert data in Microsoft Excel spreadsheets

    451972 Retail company to convert data in Microsoft Excel spreadsheets Explain the usefulness and benefits for a retail company to convert data held in Microsoft Excel spreadsheets into a relational database using Microsoft Access.

  • income statement analysis

    (2.5 points) You may consolidate data into the summary fields: Company A: (name) Company B: (name) Year 1 % Year 2 % Year 1 % Year 2 % Net Sales Cost of Goods sold Gross profit

  • Creating a databse using Microsoft SQL Server

    In the Kudler Fine Foods Database, use the CREATE TABLE statement to create the following two tables with the fields identified below: Note: Specify appropriate SQL Server data types for the fields in these tables.

View More Related Solutions