MS - Access - 1

In database design and Entity-Relationship modeling, attributes are properties or characteristics that describe entities. Entities are the objects/concepts (like Customer, Product), while attributes are their details (like CustomerName, Price). Switchboards, macros, and pages are Access interface elements, not structural database components that have attributes.

A Make-Table query creates a new table from the results of a select query. It is used to archive data, create backups, or export data in a specific format. The other query types serve different purposes - Simple Query Wizard builds basic queries, CrossTab query creates summary tables, and Append query adds records to existing tables.

Microsoft Access is a database management system (DBMS) that stores data in its own format based on the Access Jet Database Engine. Excel is a spreadsheet application, Word is a word processor, and PowerPoint is a presentation software - none of these are database management systems.

MS Access has seven main types of database objects: Tables, Queries, Forms, Reports, Macros, Modules, and Pages (for data access pages). These objects work together to create a complete database application.

Queries in MS Access can be opened in three different views: Design View (for visually designing the query), Datasheet View (for viewing query results in a table format), and SQL View (for viewing and editing the SQL statement). These three views provide different ways to interact with the query object.

The default field size for Text data type in MS Access is 50 characters. This can be modified up to 255 characters for Text fields. The question specifically refers to the default setting for Text fields when they are first created.

Database normalization in MS Access follows three main normal forms: First Normal Form (1NF) eliminates repeating groups, Second Normal Form (2NF) removes partial dependencies, and Third Normal Form (3NF) eliminates transitive dependencies. These three forms are the foundation of database design.

In MS Access table field properties, the $ symbol is used in the Format property to align text to the right. The < symbol aligns text left, > is not used for alignment, @ is a placeholder for text characters, and % is used for percentages. The $ symbol specifically indicates right-aligned formatting.

In MS Access, the Tools menu contains the Relationships command for defining relationships between tables. This is where you go to establish referential integrity, define one-to-many or one-to-one relationships, and enforce cascading updates and deletes between related tables.

In MS Access, the < symbol is used in format specifications to display text in lowercase. The > symbol displays text in uppercase, $ is for right alignment, and % is for percentage format. These symbols are used in the Format property of fields to control how data is displayed.

To include pictures or other binary data in MS Access, the OLE (Object Linking and Embedding) data type must be used. OLE allows storage of objects like images, documents, or other files. Hyperlink is for web links, Yes/No is for boolean values, and Picture is not a valid data type in Access.

In MS Access forms, the Label control is used to display headings, titles, or descriptive text. Labels are used for static text that users don't interact with - they're for display purposes only. Textboxes are for user input, Option Groups for radio button choices, and Insert is not a control type.

Ctrl+W is the standard keyboard shortcut to close the current Datasheet view in MS Access. This works similarly to closing documents in other Windows applications. Ctrl+C is for copying, Ctrl+O is for opening, and Alt+F4 closes the entire application.

The MS Access Query menu typically shows 4 main query categories: Select Query, Make-Table Query, Update Query, and Append Query. Some versions may show different categorizations, but 4 is the standard count in the basic Query menu.

The Parameter command is found in the Query menu in MS Access. This allows you to create queries that prompt for user input when run. The Tools menu contains database utilities, Insert adds new objects, and View changes display modes.

The Get External Data command (often on the File or Data tab) is used to link or import data from external sources including Excel worksheets. This creates a connection to the Excel file. Join, Attach, and Merge are not the correct commands for this purpose in Access.

MS Access has 5 main summary (aggregate) operators available in the Totals row: Sum, Avg, Count, Min, and Max. Additional operators like StDev, Var, First, and Last exist but the 5 listed are the primary summary functions.

Queries are saved as database objects in Access, similar to tables, forms, and reports. Unlike filters which are temporary view settings, queries are reusable objects stored in the database. Filters cannot be saved as standalone objects.

MS Access supports 3 types of table relationships: One-to-One, One-to-Many, and Many-to-Many. These are the fundamental relationship types in relational database design and Access specifically supports these three.