30 Questions
What is the field type of the 'OrderNum' field in the Order table?
Primary Key
What is the purpose of the 'PlacedBy' field in the Order table?
To store the customer's name
What should be the field size of the 'BillingDate' field in the Order table?
Unspecified
What should be the field size of the 'CustomerNum' field in the Order table?
3
What data type is used for the 'Paid' field added to the Order table?
Yes/No
What is the purpose of the 'InvoiceAmt' field in the Order table?
To store the amount payable for an order
What kind of database is Microsoft Access?
Relational database
What field uniquely identifies each record in a table in a relational database?
Primary Key
When saving in Microsoft Access, what exactly gets saved?
The design of the Access objects
What is a Foreign Key in a relational database?
A field that connects one table logically with another table
What is the primary function of a Primary Key in a relational database?
Identify each record uniquely within a table
Which of the following best describes the relationship between tables in a relational database?
Tables are related based on common fields with matching values
What is the main rule regarding primary keys in the context provided?
Restricting two records from sharing the same primary key
What is a common characteristic of a primary key according to the text?
It is allowed to be a 'composite key'
How does the text suggest ensuring integrity when adding a record to a datasheet?
Ensuring no two records share the same primary key
What differentiates a composite primary key from a regular one in database management?
Composite keys consist of multiple fields
In the context provided, what does it mean when Kyungsoo wants to include tables in the Firm database?
Importing existing tables into the database
What precaution does Kyungsoo recommend before importing an Excel file into the database?
Verify the contents of the Excel file
What is the main purpose of creating a form in a database?
To customize the data entry screen for user convenience
Why did Kyungsoo ask for a form to be created for the Customer table?
To enable staff members to easily work with data in the table
How many records were there in the Customer table before adding record No. 39?
38
Which layout was used when creating the form for the Customer table?
Columnar & Style: International
What was the main requirement for modifying the Test form in the Design View?
Ensure City, State, and Zip Code are on the same line
Why were staff members only allowed to work with data in the Customer table via a form?
To simplify the process of working with data in the table
What fields must be included in the list for determining high invoice amounts?
Customer Name, Invoice Amount, Billing Date
How should the Order Number be sorted in the list concerning Customer Name Begins With R?
Ascending order
What criteria should be met for a client to be considered valuable to Kyungsoo Engineering firm based on the provided information?
First contact date later than 01/01/2018
Which fields must be present in the list to determine those records where InvoiceAmt exceeds 20,000?
Customer Name, Invoice Amount, Billing Date
How should the Product Code be filtered between CS and DS?
$CS < Product Code < DS$
How should And and Or conditions be specified in the query design grid?
And conditions on the same line; Or conditions on different lines
Study Notes
Microsoft Access Database Creation and Management
- Microsoft Access is a relational database management system, along with SQL Server, Oracle, and DB2.
- A relational database is a collection of tables that are related to each other based on a common field.
Creating a New Database
- To create a new database, click on the "Create a new database" button and enter a name, typically in the format of "Last Name + First Initial of First Name".
- When saving a database, Access saves the design of the Access objects, not the database itself.
Characteristics of Relational Database
- Each record in a table must be uniquely identified using a primary key.
- Tables are related to each other based on a common field using foreign keys.
- Primary key (PK) uniquely identifies each record in a table, while foreign key (FK) connects one table to another.
Relating Tables using PK and FK
- The primary key in one table is the common field that relates to another table.
- The foreign key in the second table connects to the primary key in the first table.
Querying a Database
- Using the "Between" operator to retrieve records within a specific range, e.g. "Product Code between CS and DS".
- Using the "Greater than" operator to retrieve records that exceed a certain value, e.g. "Invoice Amount > 20,000".
- Using the "And" and "Or" operators to combine conditions in a query.
- Using the "OR" operator to retrieve records that meet either of two conditions, e.g. "First Contact date < 01/01/2018 or Invoice Amount > 20,000".
Access Data Types and Field Properties
- Access data types include Text, Date/Time, Currency, and Yes/No.
- Field properties include Field Size, Required, and Default Value.
Creating and Modifying Tables
- Creating a table involves defining the fields and their data types.
- Modifying a table involves adding, deleting, or rearranging fields.
- Data can be entered sequentially in Datasheet view.
Data Integrity and Primary Key Rule
- No "null" value can be allowed in a primary key.
- No two records can have the same primary key.
- A primary key can be a composite key, consisting of more than one field.
Importing External Access Tables and Excel Worksheets
- Importing tables from another Access database or Excel worksheets.
- Reviewing the Excel file before importing it into Access.
Forms in Access
- Forms are used to customize the data entry screen.
- Forms are created for the convenience of the user and to update data tables.
- Forms can be used to restrict user access to certain data.
- Forms can be created using the "Form Wizard" and customized in Design View.
Creating and Modifying a Form
- Creating a form involves selecting the table and fields to include, and choosing a layout and style.
- Modifying a form involves rearranging fields and adjusting their properties in Design View.
This quiz provides an overview of Microsoft Access, a relational database management system. It covers topics such as creating a new database in Access, saving the design of Access objects, and the basics of managing databases within Access.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
