Access Chpt. (1)
Relationship skill 5
. This is done by clicking the DATABASE TOOLS tab, and in the Relationships group, clicking the Relationships button, which displays the Relationships tab and Show Table dialog box. To add a table to the Relationship pane, you can double-click its name in the dialog box. As seen in the slide, our two tables have been to the pane.
append row
A blank row in a datasheet in which a new record is entered.
AutoNumber
A data type that automatically adds a unique field value to each record in a table.
Date Picker
A feature used to enter dates by clicking dates on a calendar.
foriegn key
A field that is also a field in another related table. The field in the other table is usually that table's primary key.
quick start field
A predefined set of characteristics and properties that describes a field, including a field name, a data type, and a number of other field properties.
cascading delete
A referential integrity option where you can delete a record on the one side of the relationship, and all the related records on the many side will also be deleted.
cascading update
A referential integrity option where you can edit the primary key values in a table, and all the related records in the other table will update accordingly.
one-to-many relationship
A relationship between two tables in a database in which one record in the primary table can match many (zero, one, or many) records in the related table.
Many-to-many relationship
A relationship where one record in either of the outer tables can have many associated records in the other outer table.
referential integrity
A set of rules that Access uses to ensure that the data between related tables is valid.
database
A structured collection of related information about people, events, and things.
Entity relationship diagram (ERD)
A visual model used to plan a database.
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. can hold up to 255 characters
currency data type
An Access data type that stores numbers formatted as a monetary value.
date/time data type
An Access data type that stores numbers in the date or time format.
landscape
An Access data type that stores numeric values
number data type
An Access data type that stores numeric values.
memo data type
An Access data type that stores up to 65,535 characters of text data and the formatting assigned to that text.
Attachment data type
An Access data type used to store files such as Word documents or digital photo files.
Description
An Access field property that is used to document a field's purpose; it displays in the status bar of the datasheet when the field is active.
field size
An Access field property that limits the number of characters that can be typed into a text or number field.
datasheet
An Access view that displays records in rows and fields in columns similar to a Microsoft Excel spreadsheet.
toggle filter button
Applies or removes the current filter
Best fit- column widths can be changed to match the width of their contents. As data are added, the widths may need to be adjusted.
As an example, to change the width of the first column: Click in the header row Click the HOME tab, and in the Records group, click More From the menu, click Field Width In the Column Width dialog box, click Best Fit.
Navigation Pane
Contains a list of all the objects in the database.
field
Contains a specific piece of information within a record. Each column is a field that each record will store, such as an address or postal code. A set of common characteristics around which a table is organized individual characteristic in a record that displays as a single column in a datasheet
When designing a table, you add field names and properties.
Data Type is a field property that specifies the type of information that a field will hold, for example, text, number, or date.
live preview
Feature that allows you to point to a gallery choice and see its effect in the document window.
Format
For the Currency data type, Access automatically sets the ____________________ to Currency.
For the open objects appear at the top of the work area..
For the open objects appear at the top of the work area..
Title Bar
In the accompanying figure, the database name, Camashaly Design appears on the
When Access is opened, the Start screen displays, giving you several options: Open a recent database Create a new blank database Create a database from a template
Open a recent database Create a new blank database Create a database from a template
Status Bar
Presents information about the database object, the progress of current tasks, and the status of certain commands and keys or The words Datasheet View at the lower left of the screen appear on the..
press Enter to move to the next column after Naming a field
Pressing Enter after the last field moves the insertion point to the append row, and the data for the next record would be added.
Compact and Repair Databases skill 11
Rebuilds database files so data and database objects are stored more efficiently. Decreases the size of a database file and improves database performance. Periodically using the Compact and Repair tool can improve the performance of the databases. Open File Explorer, navigate to and place the pointer over the desired database file to display its file size in a ScreenTip.
data type
Specifies the type of information that a field will hold; for example, text, number, date, and currency.
Database Management .
System Software tool that can be used to create a database; add, change, and delete data in the database
Design grid
The lower half of the query tab that lists the fields that will display in the query results.
Junction table
The middle table in a many-to-many relationship.
Redundancy
The storing of a piece of data in more than one place.
datasheet view
The table is represented as a collection of rows and columns called a datashee
CAPTION
To enter or change a caption, click the field name and in the Properties group, click Name & Caption. In the Enter Field Properties dialog, which we saw in a previous slide, make the desired change
filters
Used to select a subset of data or A temporary view of the data
Report View
View that shows a report on the screen and allows changes to the report.
Layout View
View that shows a report on the screen and does not allow changes to the report.
a command that opens the print dialog box o that you can select a different printer or different print options
quick print
a command that prints the object directly without being able to edit setting. you cannot choose a different printer, or change the printer settings
currency
a data type that stores numbers formatted as monetary values
table
a database object that stores the data base data so that the records are in rows and fields are in columns
caption
a feild property that determines what displays in datasheet, form, and report lables
data type
a field property that specifics the type of info that the field will hold; for example, text number, date, or curency
foreign Key`
a field that is used to related records in a second table. the foreign key field is often the second tables primary key
primary key
a field that uniquely identifies each record in a table
subdatasheet
a format for displaying related records when you click next to a record in a table on the one side of the relationship
quick start
a set of fields that can be added with a single click. for example; the name quick start data type inserts the last name & fist name fields and assigns the text data type to each
table design
an access view that features table fields and their properties
record
each row in a data sheet a collection of related data such as the contact info for a person
Attachment data type
is used to store files such as Word documents or digital photo files. Note: Attached files can then be opened and viewed in the application in which they were created.
An Access file can contain ________
objects such as tables, forms, queries, and reports. In this first chapter, we will concentrate on working with tables, which are used to store our data.
Enter Field Properties dialog box
s used to enter field information you would click the ID column header. On the Fields tab, in the Properties group, click Name & Caption, replace the Name box value with a field name, and in the Caption box, type a caption
Hyperlink data type . skill 14
stores links to websites or files located on your computer. In datasheets, forms, and reports, field values display as hyperlinks. The Yes/No data type stores variables that can have one of two possible values—for example, yes or no, or true or false.
print preview
view that shows a report as it will appear when printed.
