A Microsoft Access view that displays the detailed structure of a table or a query

AB
Append To add on to the end of an object; for example, to add records to the end of an existing table.
AutoNumber Data type A data type the describes a unique sequential or random number assigned by Access as each record is entered and that is useful for data that has no distinct field that can be considered unique.
Best Fit An Access commmand that adjusts the width of a column to accommodate the column's longest entry.
Blank desktop Database A database that has no data and has no database tools- you must create the data and the tools as you need them.
Caption A property setting that displays a name for a field in a table, query, form, or report other than that listed as the field name.
Common Field A field in one or more tables that stores the same data.
Currency Data Type An Access data type that describes monetary values and numeric data that can be used in mathematical calculations involving data with one to four decimal places.
Data Facts about people, events, things, or ideas.
Data Source The table or tables from which a form, query, or report retrieves its data.
Data Type The characteristic that defines the kind of data that can be entered into a field, such as numbers, text, or dates.
Database An organized collection of facts about people, events, things, or ideas related to a specific topic or purpose.
Database Management System (DBMS) Database software that controls how related collections of data are stored, organized, retrieved, and secured; also known as a DBMS.
Database Template A preformatted database designed for a specific purpose.
Datasheet View The Access view that displays data organized in columns and rows similar to an Excel worksheet.
Design View An Access view that displays the detailed structure of a query, form, or report; for forms and reports, may be the view in which some tasks must be performed, and only the controls, and not the data, display in this view.
Destination Table The table to which you import or append data.
Field A single piece of information that is stored in every record and formatted as a column in a database table.
Field Properties Characteristics of a field that control how the field displays and how data can be entered in the field.
First Principle of Good Database Design A principle of good database design stating that data is organized in tables so that there is no redundant data.
Flat Database A simple database file that is not related or linked to any other collection of data.
Form An Access object you can use to enter new records into a table, edit or delete existing records in a table, or display existing records.
Form View The Access tool that creates a form with a single mouse click, which includes all of the fields from the underlying data source.
Import The process of coying data from another file, such as a Word table or an Excel workbook, into a separate file, such as an Access database.
Information Data that is organized in a useful manner.
Layout View The Access view in which you can make changes to a form or report while the object is running - the data from the underlying data source displays.
Link A connection to data in another file.
Multiple-Items Form A form that enables you to display or enter multiple records in a table.
Navigation Area An area at the bottom of the Access window that indicates the number of records in the table and contains controls with which you can navigate among the records.
Navigation Pane An area of the Access window that displays and organizes the names of the objects in a database; from here, you open objects for use.
Normalization The process of applying design rules and principles to ensure that your database performs as expected.
Object Window An area of the Access window that displays open objects, such as tables, forms, queries, or reports; by default, each object displays on its own tab.
Objects The basic parts of a database that you create to store your data and to work with your data; for example, tables, forms ,queries, and reports.
Populate The action of filling a database table with records.
Primary Key The field that uniquely identifies a record in a table; for example, a Student ID number at a college.
Query A database object that retrieves specific data from one or more database objects- either tables or other queries- and then, in a single datasheet, displays only the data you specify.
Record All of the categories of data pertaining to one person, place, thing, event, or idea, and which is formatted as a row in a database table.
Record Selector Bar The bar at the left edge of a record when it is displayed in a form, and which is used to select an entire record.
Record Selector Box The small box at the left of the record in Datasheet view that, when clicked, selects the entire record.
Redundant In a database, information that is repeated in a manner that indicates poor database design.
Relational Database A sophisticated type of database that has multiple collections of data within the file that are related to one another.
Report A database object that summarizes the fields and records from a table or query in a easy-to-read format suitable for printing.
Run The process in which Access searches the records in the table included in the query design, finds the records that match the specified criteria, and then diplays the records in a datasheet; only the fields that have been included niter query design displays.
Second Principle of Good Database Design A principle stating that appropriate database techniques are used to ensure the accuracy of data entered into a table.
Select Query A type of Access query that retrieves data from one or more tables or queries, displaying the selected data in the datasheet; also know as a simple select query.
Simple Select Query Another name for a select query.
Single-Record Form A form that enables you to display or enter one record at a time in a table.
Source File When importing a file, refers to the file being imported.
Structure In Access, the underlying design of table, including field names, data types, descriptions, and field properties.
Table The database objects that stores data organized in an arrangement of columns and rows, and which is the foundation of an Access database.
Tables and Related Views An arrangement in the Navigation Pane that groups object by the table to which they are related.
Truncated Refers to data that is cut off or shortened.
Wizard A feature in Microsoft Office that walks you step by step through a process.
Custom web app a database that you can publish and share with others over the Internet
DBMS an acronym for database management system
Export the process of copying data from one file into another file, such as an Access table into an Excel spreadsheet
Number data type an Access data type that describes numbers that might be used in calculations
Object tab in the object window, a tab that identifies the object and which enables you to make the open object active
Property Sheet a list of characteristics-- properties-- for fields or controls on a form or report in which you can make precise changes to each property associated with the field or control
Secure environment a system that uses controlled servers to ensure the security and privacy of email, to control the storage and use of information and to protect against the loss of cofidential data
Server a computer that provides services on a network such as an email server or a file server
SharePoint a Microsoft application used for setting up websites to share and manage documents
Short Text data type an Access data type that describes text, a combination of text and numbers, or numbers that are not used in calculations, such as a Postal Code

What can be used to display the structure of a table in Microsoft Access?

In the Navigation Pane, right-click the table that you want to explore, and then click Design View on the shortcut menu. As needed, note the name of each table field and the data type assigned to each field. The data type assigned to a field can limit the size and type of data that users can enter in a field.

Which view of a form gives a detailed structure of the form in MS Access?

Design view Design view gives you a more detailed view of the structure of the form. You can see the Header, Detail, and Footer sections for the form. You cannot see the underlying data while you are making design changes; however, there are certain tasks you can perform more easily in Design view than in Layout view.

What are the views in a table in Access?

The two most important views are: Datasheet View allows you to enter information into your database. It is in a table format similar to Excel. Design View allows you to setup and edit the fields of your database.

What is query Design view in Access?

Query Design View displays table schemes, along with their relationships, and allows the user to select columns to return (projection) and specify criteria for the returned data (selection).