Split Form - A Form split into two panes where you can view the fields of one record and a datasheet of a few records at the same time., Maintaining the database - To add, change, and delete records in database tables to keep them current and accurate, Restructure the database - Adding new fields to a table, changing the characteristics of existing fields, and removing fields, as well as creating validation rules and referential integrity, Filter - To specify a set of restrictions to only display specific database records, online images, or files, Common filters - Provided filters that allow you to filter for specific values or for a range of values, Searching - To look for records that satisfy some criteria, Multivalued fields - Fields that can contain more than one value, Structure - The tables, fields, and field characteristics that comprise a database, Lookup field - A field that has lookup properties, which are used to create a drop-down list of values to populate the field, Delete query - An action query that deletes selected records from one or more tables, Update query - An action query that updates the values in a field, Computed field - A field used in a query that is not contained in a database, but can be computed from fields that are., Action query - A query that adds, deletes, or changes data in a table, Calculated field - A field used in queries that are not contained in a database, but can be computed from fields that are, Append query - An action query that adds selected records to an existing table., Make-table query - A query that lets you add query results to a new table, which can be in the current database or another database, Validation rules - Rules that a user must follow when entering data to ensure valid data, Required field - A field in which a user must enter data; neglecting to do so generates an error, Validation text - A field property that determines what message appears if a user attempts to make a field entry that does not pass the validation rule for that field, Range of values - A validaation rule that specifies that the values in a field must fall within a certain range, Legal values - A validation rule that specifies that the values in a field must come from a certain collection of possibilities, Default value - A value that Access will display on the screen in a particular field before the user begins adding a new record, Referential integrity - A set of rules that Access enforces to maintain consistency between related tables when you update data in a database, and prevents the creation of orphan records, Allowable values - A validation rule specifying that field values must come from a certain collection of possibilities, Subdatasheet - A datasheet that is nested within another datasheet to show related records; the subdatasheet shows the records on the "many" side of a one-to-many relationship, Foreign key - A primary key field from one table that you include as a field in a second table to form a relationship between the two tables, One-to-many relationship - The relationship between two tables in a database in which a common field links the tables together,

Maintaining a Database in Access

Trykke
Integrere

Rangliste

Visuel stil

Indstillinger

Skift skabelon

Gendan automatisk gemt: ?