MS ACCESS - MAKE CUSTOMER / SALES DATABASE FOR EBAY on eBay (end time 16-Jan-10 17:56:28 GMT)

Description

P&P and payments

Last updated on 09:05:43 BST, 30 Jun, 2009 View all revisions

MICROSOFT ACCESS

HOW TO MAKE A CUSTOMER / SALES DATABASE

Step - by - Step Instructions in PDF File

with

239 Screenshot Illustrations on

144 Pages - can be printed out or follow the PDF Hyperlinks.

**********************

This instruction ebook / manual is ideal for either Small Traders / eBay Traders or Students:

Enables Traders to maintain a list of customer information and associated product sales

Features include the analysis of product data including date of sales, sales per month etc.

Ideal for Students who want to design their own project databases.

No previous experience of Microsoft Access necessary - illustrations are based on Access 2002 and 2003 versions - but will be similar for MS Access 2007.

No Previous Experience Necessary

*** GREAT VALUE - ONLY £6.50 ***

INCLUDES ILLUSTRATED STEP BY STEP INSTRUCTIONS AND THEORY ON HOW TO MAKE A CUSTOMER / SALES DATABASE USING THE FOLLOWING FEATURES !
	1.0 Overview 2.0 What is a Database? 2.1 Database Tables 2.2 Databases and Spreadsheets 2.3 Relational Database 2.3.1 Normalisation 2.3.2 Normal Forms 2.4 Microsoft Access Database Fundamentals 2.4.1 Tables 2.4.2 Queries 2.4.3 Forms 2.4.4 Reports 2.4.5 World Wide Web & SQL Server 3.0 Problem Analysis
	4.0 Getting Started 4.1 The Database Window 4.2 Making Tables 4.3 Customer Table 4.3.1 Enter Customer Field Names 4.3.2 Customer Primary Key 4.3.3 Saving the Table 4.3.4 Completed Table Design 5.0 Design Customer Sales Table 5.1 Using a Lookup Table to Minimise Data Entry 5.2 View / Edit the Lookup Data 5.3 Setting a Default Value for a Field 5.4 Saving the Sales Table
	6.0 Making a Relationship 7.0 Product Table Design 8.0 Linking Product Table to Sales Form.
	9.0 Using Forms for Data Entry 9.1 Product Data Entry Form 9.2 Customer Details Data Entry Form 9.3 Customer & Sales Form 9.4 Modification of Form Design 9.4.1 Adding a Form Header 9.4.2 Resize the Form 9.4.3 Moving & Editing Fields in the Form 9.4.4 Viewing the Changes 9.4.5 Removing a Field from a Form 9.4.6 Resize the Sales Subform Columns 9.5 Edit the Customer Details Data Entry Form 9.6 Edit the Products Table Form
10.0 Enter Data to Test the System 10.1 Product Table Sample Data 10.2 Customer Details Table Sample Data 11.0 Adding another Field to the Products Table 11.1 Modify Products table 11.1.1 Add Data for Product Price 11.2 Modify Sales Table 11.3 Modify Products Data Entry Form 11.4 Modify Sales Subform 11.4.1 Changing the Tab Order 11.4.2 Modify Label Names in Sales Subform 11.5 Enter Customer & Sales Sample Data 11.5.1 Customer Form & Sales Subform 11.5.2 Record Selection & Display 11.5.3 Adding Customer Sales Details	12.0 Navigation & User Interfaces 12.1 Main Menu Form 12.1.1 Main Menu Title 12.1.2 Command Button – Open Customer / Sales Form 12.1.3 Testing the Command Button 12.1.4 Adding an Exit Button 12.1.5 Remove Record Selectors 12.2 Navigation from Customer / Sales Form 13.0 Searching for Customer Details 13.1 Search by Customer id 13.2 Search by Email Address
	14.0 Using Queries to Extract Data 14.1 Sales by Date 14.1.1 Testing the Sales by Date Query 14.1.2 Automating the Sales by Date Query 14.1.3 Make a Sales Statistics Form 14.1.4 Sales Statistics Form - Return to Main Menu 14.1.5 Main Menu Form – Button to Open Sales Statistics Form 14.2 Sales by Product 14.2.1 List All Sales 14.2.2 Run Query from a Command Button 14.3 Query Products Sold using a Combo Box 14.3.1 Setting up the Combo Box 14.3.2 Naming the Combo Box 14.3.3 Designing the Query 14.3.4 Allocate a Command Button to run the Query 14.3.5 Testing the Sales by Product Query 14.4 Printing Queries
15.0 Reports 15.1 Customer Details Full Report 15.2 Contact Details Report 15.3 Produce Reports from Queries 16.0 Macro Programming 16.1 Navigation Macros 16.2 Attach the Macro to the Main Menu Command Button 16.3 Additional Navigation Macros	17.0 Final Changes 17.1 Main Menu to Product Data Entry Form 17.2 Reports Command Buttons 17.3 Password Protection 17.3.1 Unset Password Security 17.3.2 Forgotten Passwords 17.4 Remove Customer Details Data Entry Form 17.5 Automatic Start up 17.5.1 Changing Startup Settings 17.5.2 Overriding Startup Settings 18.0 Further Help 18.1 Office Assistant 18.2 Microsoft Office Online 18.3 Expanding your Access Skills
Also Includes: Adobe Acrobat Version 7.07	No need to download Adobe Acrobat, simply run the latest version from the CDROM. Operates up to 50% faster than version 6.0.
WHY WAIT BUY IT NOW!

PLEASE NOTE:
These products are not for resale but for your personal use only.
Any person found illegally copying and selling these products
will be reported to eBay

Member of VeRO (Verified Rights Owner) scheme

All ebooks contain well organised information and are published in Adobe Acrobat PDF format with full print rights.

01243

Postage and packaging

Item location: Worthing, United Kingdom

Dispatches to: Worldwide

Quantity: Change country:	Postcode:

Postage and packaging	Each additional item	To	Service	Estimated delivery*
£0.95	£0.35	United Kingdom	Royal Mail 1st Class Standard	2-3 business days after seller receives cleared payment

*The estimated delivery time is based on the seller's dispatch time, the postal service selected, and when the seller receives cleared payment. Sellers are not responsible for shipping service transit times. Transit times may vary, particularly during peak periods.

Domestic dispatch time

Will usually dispatch within 1 working day of receiving cleared payment.

Return policy

Returns Policy

We are happy to provide the following returns policy which is accordance with current legislation.
"Statutory Instrument 2000 No. 2334
The Consumer Protection (Distance Selling) Regulations 2000
 
Exceptions to the right to cancel: -
     13.  - (1) section (d) for the supply of audio or video recordings or computer software if they are unsealed by the consumer;"
 
According to these regulations we have no obligation to provide a refund or exchange on computer software media if the seals have been broken

If you have ordered the wrong CD then we'll be happy to exchange it for you provided it has not been opened.

Please contact us by email or post within 14 days of the date of receipt of your order to arrange this. 

Please be aware that we will not refund or exchange CDs that have been unsealed unless they are faulty.  All returned CDs must be in an unopened and original condition for a refund excluding our postal and packing costs.  We cannot offer an exchange or arrange a refund on any CD that has been opened. 

We recommend that all returns are sent via recorded delivery for your own protection. 

Faulty CDs

All of our CDs are checked and working before dispatch. On the rare occasion that there is a fault please contact us and we will be happy to arrange a return and replacement.  

Please note that this MUST be arranged within 14 days of receipt of the CD.

Most Buy It Now purchases are protected by the Distance Selling Regulations, which allow you to cancel the purchase within seven working days after the day you receive the item. Find out more about your rights as a buyerand exceptions.

Payment details

Payment method	Preferred/Accepted	Buyer protection on eBay
	PayPal Preferred

Seller's payment instructions

CD will be sent to your PayPal / eBay address on the first working day following the sale. It will be sent by first class post for UK and by Airmail for the rest of the world.