Podcast
Questions and Answers
What is the purpose of Design View in Microsoft Access?
What is the purpose of Design View in Microsoft Access?
Which tool in Microsoft Access allows you to automate repetitive tasks and operations?
Which tool in Microsoft Access allows you to automate repetitive tasks and operations?
What is the purpose of Forms in Microsoft Access?
What is the purpose of Forms in Microsoft Access?
Which component of a database represents a single piece of data or attribute of every record?
Which component of a database represents a single piece of data or attribute of every record?
Signup and view all the answers
What is the intended purpose of Reports in Microsoft Access?
What is the intended purpose of Reports in Microsoft Access?
Signup and view all the answers
Which component in Microsoft Access is used to ask questions about the data stored in the database?
Which component in Microsoft Access is used to ask questions about the data stored in the database?
Signup and view all the answers
What is the purpose of a Lookup Wizard in a database?
What is the purpose of a Lookup Wizard in a database?
Signup and view all the answers
Which Field Property helps prevent 'Garbage In, Garbage Out' (GIGO) in a database table?
Which Field Property helps prevent 'Garbage In, Garbage Out' (GIGO) in a database table?
Signup and view all the answers
What does the 'Validation Rule' in a database table enforce?
What does the 'Validation Rule' in a database table enforce?
Signup and view all the answers
In database terminology, what is a 'Primary Key'?
In database terminology, what is a 'Primary Key'?
Signup and view all the answers
What does the 'Caption' Field Property do in a database?
What does the 'Caption' Field Property do in a database?
Signup and view all the answers
How does the 'Input Mask' Field Property enhance data entry in a database table?
How does the 'Input Mask' Field Property enhance data entry in a database table?
Signup and view all the answers
What is the purpose of a Primary Key in a database table?
What is the purpose of a Primary Key in a database table?
Signup and view all the answers
Which data type should be used to store a website address or email address?
Which data type should be used to store a website address or email address?
Signup and view all the answers
What does the AutoNumber data type do in a database table?
What does the AutoNumber data type do in a database table?
Signup and view all the answers
Why should the Number data type not be used to store zip codes?
Why should the Number data type not be used to store zip codes?
Signup and view all the answers
Which data type would you choose to store a link to an Excel spreadsheet?
Which data type would you choose to store a link to an Excel spreadsheet?
Signup and view all the answers
What does the Yes/No data type store in a database?
What does the Yes/No data type store in a database?
Signup and view all the answers
Study Notes
Lookup Wizard
- Enables creating a drop-down list of values for user selection in a table, making data entry easier and reducing errors.
- Values can be typed in manually or dynamically based on another table in the database.
Field Properties
- Sets boundaries on data entry in table fields to prevent bad data (GIGO).
- Field Size: sets the maximum number of characters that can be entered into a text field.
- Format: sets how data is displayed in the table field.
- Input Mask: sets rules for correct data entry.
- Default Value: sets the default value that appears in the table field when a new record is entered.
- Caption: provides alternative field names for database objects that reference the field.
- Required: sets whether a value is required to be entered into the table field.
- Validation Rule: sets specific data entry rules that must be followed strictly.
- Validation Text: displays an error or warning message when the user enters invalid data.
Primary Key
- A field or combination of fields that uniquely identifies a record in a table.
- Must be unique and follows the rule of thumb for primary keys.
Microsoft Access Database
- A collection of data organized to allow access, retrieval, and use of that data.
Tables
- Store data in a database and contain records (rows) and fields (columns).
- Can be viewed in two ways: Datasheet View and Design View.
- Datasheet View: used to add, edit, and delete records in a table.
- Design View: used to create and modify the structure of a table.
Queries
- Allow asking questions about the data in a database.
Fields
- Represent a single piece of data or attributes of every record in a table.
Forms
- Used for entering data and display the data or build a menu system.
- Built off of tables and queries.
Reports
- Typically built off of tables and queries.
- Used to format and present data in a professional, logical, and useful manner.
Macros
- A tool that allows automating repetitive tasks and operations.
- Often used to open forms and reports to automate portions of the database.
Report Wizards
- A tool used for building reports and forms.
Database Hierarchy
- Field → Records → Table → Database (from smallest to largest).
Designing Database Tables
- Include necessary data determined by reporting needs.
- Store data in its smallest parts (e.g., split last and first names).
- Avoid storing calculated data due to continuous updating.
- Avoid data redundancy.
Table Wizard
- Not recommended for use.
Primary Key
- Must be unique and follows the rule of thumb for primary keys.
Field Data Types
- AutoNumber: automatically assigns a unique number to each record.
- Short Text: stores up to 255 characters of text, numbers, and symbols.
- Number: stores numbers used in mathematical calculations.
- Long Text: stores up to 63,999 characters of text, numbers, and symbols.
- Date/Time: stores dates and times.
- Currency: stores currency values up to four decimal places.
- Yes/No: stores binary representation of data (e.g., Yes/No, True/False, or ON/OFF).
- OLE Object: stores links to objects such as Microsoft Word documents, image files, or Microsoft Excel spreadsheets.
- Hyperlink: stores website addresses, email addresses, and hyperlink data.
- Attachment: stores various file formats in the database with the option of editing files within the database.
- Calculated: a special data type used to display results of calculations or expressions based on other fields in the table.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Learn about the fundamental concepts of Microsoft Access databases including tables, records, fields, and queries. Understand the difference between Datasheet View and Design View and how to interact with data in a database.
