D

database
A method of keeping records which are made up of fields. A database can be written by hand, kept in a ledger or address book, or use software.
database programmer
A person who designs databases and writes code to create and control them. A programmer may use computer languages like C or COBOL or special purpose languages.
Database windowDatabase Window
The initial window in Access that shows the objects in the database
 
datasheet
A view of database records that looks like a spreadsheet, with rows and columns
 
Table Datasheet
data type
What kind of data is allowed in a field, like text, numbers, currency, date/time, OLE object, or hyperlink.
DateAdd function
An Access function which adds a certain number of intervals to a date. The intervals can be years, months, days, hours, minutes, seconds, quarters, weeks, or weekdays.
Syntax: DateAdd(interval, number, date)
where interval is a string expression that picks what kind of intervals you want to use. For example, "m" would be months, "d" would be days. number is how many intervals you want to add. A negative number would subtract, of course. date is the date to which you want to add.
Example:
 
DateAdd("yyyy",5,[PurchaseDate]) returns a date that is 5 years later than [PurchaseDate].
DateDiff function
An Access function that calculates the difference between two dates.
Syntax: DateDiff(interval, date1, date2)
where interval is how you want the difference reported - in years, months, days, etc.
date1
should be earlier than date2 to get a positive answer.
Examples:
 
DateDiff("d","3/4/1995", Now()) returns the number of days since Mar. 4, 1995. The answer will be different every day as time marches on!
  DateDiff("yyyy",[BirthDate],[DeathDate]) returns the number of years from birth to death.
DatePart function
An Access function that picks out a particular part of the Date/Time, such as the year or the hour or the day of the week.
Syntax: DatePart(interval, date)
where interval is a string expression that tells Access which part you want to see. For example, "yyyy" would be the year. "h" would be the hour. date is the date or a string expression that identifies the value.
Examples:
 
DatePart("yyyy","January, 1, 2004") returns the value 2004.
  DatePart("m",[DateHired]) returns the month portion of the value in the field DateHired.
default data
Chart: Data that shows instead of data from actual records in Design View. Access cannot pull the records while in Design View.
default value
The value that a field will have if you do not enter a different value.
Delete query
An action query that deletes the selected records from a single table. Whole records are deleted even when only one field from the table is actually in the query.
delimiter
A character used to separate records or fields in a text database. Commonly, records are separated by a new line character, which does not show in the text document. Fields are usually separated by a comma (,), semi-colon(;), tab, space, or pipe character(|).
detailed report
A report which shows records, from the Detail section of the report's design.
divider line
A straight line which separates the sections or records of a form or report.
Documenter
A feature of Access that creates a report for a database object that describes all of its properties.