MOS Access Expert flashcards
MOS Access Expert · Build recall with a focused review session.
32 cards. Read the term and the definition here. The deck at the top of this page is optional.
- Compact and Repair
- A Database Tools command that rebuilds the file, removes unused space, and can fix corruption. Run it on a copy first; it also resets AutoNumber seed values in some cases.
- ACCDE file
- A compiled, locked copy of an ACCDB that removes VBA source code and prevents design changes to forms and reports. Tables and queries remain usable, and conversion back to ACCDB is impossible.
- Trusted Location
- A folder registered in Trust Center that lets databases open with active content enabled, bypassing the Message Bar. Files placed there run macros without prompting.
- Split database
- An architecture with a front-end file holding queries, forms, reports, and macros linked to a shared back-end file holding only tables. Linked Table Manager repoints the connections.
- Object Dependencies
- A task pane listing which queries, forms, and reports reference a selected table or query. It ignores references made in VBA code and macros.
- Navigation Pane options
- Settings that control how objects are grouped and displayed, such as by object type or creation date, and whether they appear as a list, icons, or details.
- Database encryption
- The Backstage Info option Encrypt with Password that applies AES encryption to the entire database file. A password is required on every open until encryption is removed.
- Short Text limit
- A data type storing up to 255 characters. Longer text requires the Long Text type, which can hold about one gigabyte and supports rich-text formatting.
- Currency data type
- An eight-byte exact numeric type with four decimal places, used for money to avoid rounding errors. It is faster than Decimal and avoids floating-point imprecision.
- Validation Rule property
- A table- or field-level expression that data must satisfy, such as Between 1 And 100. Validation Text supplies the message displayed when a value fails.
- Input Mask sections
- A three-part string: the mask pattern, a 0 or 1 indicating whether literal characters are stored, and the placeholder character shown while typing.
- Composite primary key
- A key made of two or more fields selected together in Design View. The combination must be unique, though each individual field may repeat values.
- Cascade Delete Related Records
- A relationship option that deletes matching rows in the many-side table when the one-side record is deleted. It requires referential integrity to be enforced.
- Indexed property values
- Three settings: No, Yes (Duplicates OK), and Yes (No Duplicates). Duplicates OK builds a non-unique index; No Duplicates rejects repeated values in that field.
- Calculated field
- A table field whose data type is Calculated and whose expression, such as [Qty]*[Price], is evaluated at run time. It cannot reference another calculated field.
- Totals query
- A select query with the Total row enabled, grouping rows and applying aggregates such as Sum, Count, or Avg. The Where option filters rows before grouping occurs.
- Outer join
- A join returning all rows from one table plus matches from the other. Left outer keeps all left-table rows; right outer keeps all right-table rows.
- Parameter query
- A query whose criteria contain a bracketed prompt such as [Enter City]. Access asks for the value at run time and applies it as a filter.
- Crosstab query
- A query that summarizes data in a grid with one Row Heading, one Column Heading, and one aggregated Value field. Column heading parameters must be declared in SQL view.
- Update query
- An action query that writes a new value or expression into a field for every row matching the criteria. With no criteria, it changes all rows.
- Append query
- An action query that adds rows from a source to an existing table. Fields map by name or position, and data types must be compatible or the append fails.
- Top Values property
- A query property limiting returned rows to a number or percentage after sorting, such as Top 10 or Top 25 Percent. Ties on the sort field are included.
- Find Unmatched Query Wizard
- A wizard that builds a query returning records in one table with no related records in another, using a left join and an Is Null criterion.
- Layout View versus Design View
- Layout View displays live data and allows moving and resizing controls. Design View shows no data but is required to edit properties, the Record Source, sections, and events.
- Control layout group
- A container that aligns and evenly spaces bound controls. Stacked arranges them vertically; Tabular arranges them in rows. Remove Layout detaches controls without deleting them.
- Tab Order dialog
- A Design View dialog that sets the sequence in which controls receive focus in the active form section. Controls with Tab Stop set to No are skipped.
- Control Source property
- The binding of a control to a table field or expression. An empty Control Source means the control is unbound and holds no stored data.
- Split Form view
- A form view showing a datasheet and a form for the same record at once. Split Form Orientation and Split Form Datasheet properties control the arrangement.
- Link Master Fields
- The property pairing a main form's field with a subform's Link Child Fields, synchronizing the subform's records to the current main-form record.
- Report sections
- Report Header and Footer print once, Page Header and Footer print on every page, Group sections print per group, and Detail repeats for each record in the source.
- Group & Sort pane
- A report design pane that adds grouping and sorting levels, each with its own header and footer sections, and supports up to four grouping levels.
- Running Sum property
- A control property that accumulates values down the report, either Over Group or Over All, producing subtotals that grow with each record.