- 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.
- The initial window in Access that shows the objects in the
- A view of database records that looks like a spreadsheet, with
rows and columns
- 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.
DateAdd("yyyy",5,[PurchaseDate]) returns a date that is 5 years later
- DateDiff function
- An Access function that calculates the difference between
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
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
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.
DatePart("yyyy","January, 1, 2004") returns the value 2004.
DatePart("m",[DateHired]) returns the month portion of the value in the
- default data
- Chart: Data that shows instead of data from actual
records in Design View. Access cannot pull the records while in
- default value
- The value that a field will have if you do not enter a
- 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.
- 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
- divider line
- A straight line which separates the sections or records of a
form or report.
- A feature of Access that creates a report for a database
object that describes all of its properties.