Make a client/property database using microsoft access

Assignment Help Computer Engineering

Reference no: EM1336473

1. Create a Client/Property database using Microsoft Access.
a. Open the Microft Access software program
b. After the Microsoft Access Window opens, select Blank Access Database, then click okay
c. The file New Database window opens, then type the word Client as the name for this file where the cursor is blinking, then click the create bottom.
d. Your Client: Database window opens, then type the word Client as the name for this file where the cursor is blinking, then click the create bottom.
e. Table 1 will appear with 3 columns titled, "Field Name" and "Data type" and "Description." The Field Name column heading is okay so you don't change the name. The Data Type means you need to specify whether it is text, number, data, or other type of information, and a description is used to set the criteria of the field name area cannpt have more than 50 characters, or you cna create your own setting, which may be 25 characters or less. In this case, you would change the 5o to 25 in the Foeld Size category. As you gain greater understanding of what the Access program can do, you will start to get creative in the descrition column.
f. Enter the date in each column and press the tab key after each entry to move your cursor to the next column. A same is shown below under each table heading.
Field Name

Name of Property (tab)
Kind of Property (tab)
Account ID# (tab)
Address (tab)
City property is in (tab)

Data Type
Text (tab)
Text (tab)
Text (tab)
Text (tab)
Text (tab)

Description

Zip code of Property (tab) Number (tab)
Contact Person (tab) Text (tab)
Area Code (tab) Number (tab)
Phone Number (tab) Number (tab)
Sq. Ft. of Property (tab) Number (tab)

Reference no: EM1336473

Questions Cloud

Managing an international business : What are the key major staffing models used in managing an international business

Hrm and a nursing home : How would HRM in a health care organization actually "operate" some of these HRM duties?

Plan a flowchart of the decision structure : A telephone company plan charges 25 cents for each call made. In addition, it charges 5 cents a minute for all calls made to a phone number that has a service plan with the company.

Explain the solution to consumer behavior : Explain The solution to Consumer Behavior and Select a purchase you have made recently and describe in detail how each of the 4Ps

Make a client/property database using microsoft access : The file New Database window opens, then type the word Client as the name for this file where cursor is blinking, then click the create bottom.

Note down a command, assuming your home directory : What will the permission section of an ls -l listing for filex look like after setting the following permissions.

Explain market penetration analysis : Explain Market penetration analysis and What are the steps in creating a market penetration analysis

Prepare a career planning assistance program : Career Planning Assistance Program - Prepare a Career Planning Assistance Program at my organization

What are the latest advancements in cabling : Why would a company want a network on its premises? How will a department or company benefit by having a network.

User Account

All Pages