Term
| What are tables? When designing tables, what should you do? |
|
Definition
| Tables are made up of fields or columns of information that stores records or rows of information. When designing tables, consider all the field values needed and how to relate the tables to each other. |
|
|
Term
| Normalization rules and guidelines to help with the design of the MS Access database |
|
Definition
| These guidelines include items such as identifying the purpose of the database, what fields of information do you need to track, how can the fields be divided into tables, what field is an unique identifier for each table and setting up table relationships. A good database design is the key to making the database as efficient as possible. |
|
|
Term
| what's new in ms access 2010 |
|
Definition
| ew templates, exporting data to .pdf files, applying conditional formatting to fields, and working with office themes. You will also see the new layout view, backstage view, the click to add fields in datasheet view and some other new feature |
|
|
Term
| shortcut for entering the same data in the previous record |
|
Definition
|
|
Term
| shortcut to enter the current date |
|
Definition
|
|
Term
| shortcut to enter the current time |
|
Definition
|
|
Term
| SQL syntax for an inner join |
|
Definition
Inner joins are specified in SQL in the FROM clause, as shown:
FROM table1 INNER JOIN table2
ON table1.field1compopr table2.field2
INNER JOIN operation has these parts:
Part (Description)
table1, table2 (The names of the tables from which records are combined)
field1, field2 (The names of the fields that are joined. If they are not numeric, the fields must be of the same data type and contain the same kind of data, but they do not have to have the same name)
compopr (relational comparison operator: "=," "<," ">," "<=," ">=," or "<>.") |
|
|
Term
| How do I write a full outer join query in access? |
|
Definition
SELECT *
FROM AA
JOIN BB ON AA.C_ID = BB.C_ID
UNION ALL
SELECT *
FROM AA
LEFT JOIN BB ON AA.C_ID = BB.C_ID
WHERE BB.C_ID IS NULL
UNION ALL
SELECT *
FROM AA
RIGHT JOIN BB ON AA.C_ID = BB.C_ID
WHERE AA.C_ID IS NULL |
|
|
