databases_2

databases_2 - Mail Merge Overview Export appropriate fields...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
124 Database data fle main fle output fle export mail merge Word FileMaker Pro (or other source) Mail Merge Overview Export appropriate fields from one or more databases Create a new document in Word and create a form letter to be mailed to your customers
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
125 Mail Merge Example: Specifics Export appropriate fields from the FileMaker database(s) using SYLK / Excel delimited format Open the file in Excel and save it as an Excel 2003 worksheet if necessary (this is the data file) Create a new document in Word and go to the Mailings tab to create a form letter to be mailed to your customers Follow the sequence: Start Mail Merge, Select Recipients, Insert Merge Field (from the data file) – « and » enclose the field names
Background image of page 2
126 Database Design Logical database design is from the perspective of the user; there is a logical connection among the fields of each record – For a teacher, each student has a group of fields associated with him or her: name, student id, homework grades, test grades, etc. – For a bank: name, account number, type of account, balance, etc. – For an airline: name, flight number, seat number, etc. The information about the meaning of the data stored in a database can be stored in a data dictionary , which contains all relevant information about the data items in a database Schema is the term used for the complete logical design; subschemas are subsets of the schema - each user has a subschema (can be thought of as the user’s view of the database) Physical database design is from the perspective of the computer (or programmer); what type of media, what type of file, etc.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
127 The Database Design Process Six steps to designing normalized database Example: – Creation of student grading system Step 1— Overall Definition Investigate and research data to be modeled – Involve the end user in design process – Define purposes and uses of the database – Use any documents the end user works with to complete tasks Specify entities: – An entity is some identifiable thing that users want to track – For the example of a student grading system based on a course syllabus, some entities are: students, courses, grades
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/07/2009 for the course MGMT E-110 taught by Professor Koltz during the Summer '09 term at Harvard.

Page1 / 43

databases_2 - Mail Merge Overview Export appropriate fields...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online