Flashcards in Midterm Deck (47):
A meaningful category of information, such as FirstName or HireDate, is called a
Two different actions that cause Access to automatically save changes you've made to the current record
1. Moving to another record
2. Closing the table/form
On an access datasheet, which symbol indicates a dirty record?
To connect records from one table to records in another table, you must use this type of field
Primary - Foreign Key
A table's ___ uniquely identifies each record in the table
What 4 database objects are created in Module 1?
Tables, queries, forms, and reports
Which Access object is used to view and edit data on the screen in a customized layout?
Data organized as a collection of tables created this type of data system?
Relational Database Management System (RDBMS)
The specific content of a field is referred to as the
A field used to connect one table logically with another table is called a
Which data type would be the best logical data type for a field named PaidDate
A table can be created in which two views
Datasheet and design view
To begin importing data from an Excel Spreadsheet, click on the ___ tab on the ribbon
Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?
The ___ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition
Before creating a relationship between a primary key in one table and a foreign key in a related table, what two things must be true regarding those fields, so the relationship can be established?
Both fields must be the same data type and the same size
The default character length for the Short Text data type is
The ___ property allows the database designer to explain the purpse of a field or how a field is used
What are some examples of comparison operators?
=, <>, , >=, Between...And, In, and Like
InvoiceMessage: IIF([InvoiceAmt] >= 100, "large invoice", "small invoice"
If the value in InvoiceAmt is $99, what will be displayed in the InvoiceMessage field?
Selection criteria that are placed in different rows in the query design grid indicate an ___operator
What is wrong with the following concatenated column?
PatientName FirstName, Lastname
1. There needs to be a colon (:) between PatientName and FirstName
2. There needs to be an ampersands (&) between FirstName and LastName
3. There should be two double quotations and a space between the ampersands.
It should look like this:
PatientName: FirstName & " " & Lastname
The sort priority for a query is
Leftmost sort first
The process of adding, modifying, and delteing records in a database to keep the records current and accurate is referred to as _______ a database
For most queries, you can updat the information in their datasheets. What two types of queries don't allow you to update the data within them?
1. A totals query
2. A query that uses four or more tables
A field with the Short Text data type sorted in descending order will display the data in which order
Z to A
Statistical information such as totals and averages are calculated using
Queries based on more than one table, must have a _____ field
The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters
Using a find unmatched query is useful for doing 2 specific things, what are they?
1. Finding records in one table that do not have matching records in a related table
2.Finding the cause of data violation error when trying to create a relationship between two tables/trying to enforce referential integrity
An ___ is a predefined format used to define a pattern for data to be entered into a field and control the values a user can enter into a field
Which of the following pattern match selection criteria would return zip codes with the characters 704 anywhere within the field
How does the Lookup Wizard hide the column of key values
By setting the column's Width property to 0"
Which wildcard symbol represents a single numerical digit
What is the purpose of a parameter query?
To provide a prompt for users to see and then type in a vlaue that will be used as a criterion value when the query is run
A criterion may be negated by using the ___ logical operator
Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashes separating the parts of the telephone number?
Create a parameter criteria for a City field that prompts a user to "Please enter a city" but will return every record if the user doesn't enter a value
Like "*" & [Please enter a city] & "*"
Another acceptable answer (less-preferred):
Like [Please enter a city] & "*"
Problems caused by data redundancy and by partial and transitive dependencies are called
How is a many-to-many table relationship resolved?
1. By creating third table (junction/intersection/ link table) to serve as a bridge between the two many-to-many tables
What are the formal names for:
1. Table: Relation
2. Record/Row: tuple
3. Field/Column: Attribute
What are the naming conventions for the following Access objects/ controls?
3. Text Box
4. Combo Box
5. Command Button
1. Report: rpt
2. Image: img
3. Text Box: txt
4.Combo Box: cbo
5. Command Button: cmd (or btn)
A table is in first normal form once any ___ have been removed
What are specific examples of domain integrity constraints?
1. The data type for a field
2. Utilize validation rules for a field
List three desirable characteristics of a primary key
2. Minimal (Doesn't contain any unnecessary extra columns)
3. Static (Must not change in value)
List 3 different reasons to create a one-to-one relationship between tables?
1. If the table has a large number of fields (to overcome Access 255 field limit in tables) you can divide it into two tables with a 1-to-1 relationship.
2. For security reasons (to control field access - one department may have permission to view some of the fields and another a seperate set of fields)
3. To avoid space waste created by null field values