Microsoft Access Beginner Level 1 Quiz

One of the things I've been wanting to do for the longest time is to put together quizzes for my various courses. I'm not sure if you've noticed, but I recently started doing them with the TechHelp videos as a test.

Now that AI is becoming very helpful, I can feed the transcript of my videos into the AI, and it can put together a quiz for me based on the material presented. Just today, I decided to feed all the videos from Access Beginner Level 1 into this quiz generator, and here's what it came up with.

Whether or not you've watched Access Beginner 1, give this quiz a try and see how well you do.

Post your score below in the comments.

The next step is to build an actual online quiz taker that will give you a score, but for now, you'll find the answers below each section.

(Yes, Alex, I know you've built one - but you know how I am with integrating things into the website. LOL)

And once again, these questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. I gave it a quick read-thru, but I haven't taken the quiz myself yet. Thanks.

-RR

P.S. When you're finished with this one, take the Access Beginner 2 Quiz. 

LESSON 01:

Q1. What is a database primarily used for?
A. To store and organize photographs
B. To store, organize, and manipulate data
C. To run complex mathematical calculations
D. To design graphic art

Q2. How does Microsoft Access handle relationships between different types of data?
A. It doesn't recognize relationships.
B. It can only recognize relationships with external plugins.
C. It can recognize relationships and can relate data types together.
D. It requires manual linking for each related data item.

Q3. Why might one prefer to use Access over Excel for managing large amounts of data?
A. Excel is not capable of storing large amounts of data.
B. Access is cheaper than Excel.
C. Access provides relational data management and a user-friendly interface.
D. Excel can only store numerical data.

Q4. How can Microsoft Access distinguish it from early databases and simple spreadsheets?
A. By recognizing relationships between types of data.
B. By exclusively using text documents for data storage.
C. By limiting data storage to a few spreadsheet rows.
D. By preventing any form of data sorting.

Q5. Why do databases like Microsoft Access allow for more control over data compared to spreadsheets?
A. Databases lock all data fields by default.
B. They enable strict controls over the types of data that can be input into each field.
C. Databases automatically encrypt all data.
D. They allow unlimited data entry without validation.

Q6. What are tables in Microsoft Access used for?
A. Presenting data in printed form
B. Storing data
C. Automating tasks
D. Editing videos

Q7. What feature of Microsoft Access enables viewing and editing data on the screen in a user-friendly way?
A. Queries
B. Macros
C. Forms
D. Reports

Q8. What is the purpose of a query in Microsoft Access?
A. To print out data
B. To secure the database
C. To manipulate and view data in different ways
D. To write visual basic programming code

Q9. When should a report be used in Microsoft Access?
A. To edit data on the screen
B. To create drop-down lists
C. To present data outside the database, such as in printed form
D. To store data about employees

Q10. Can you build a complete and functional database in Access without using macros or writing any code?
A. No, code is essential for building a database.
B. Yes, but macros are mandatory.
C. No, databases cannot function without advanced features.
D. Yes, all you really need are tables, queries, forms, and reports.

LESSON 02:

Q1. What is the first step that should be taken when planning a new database?
A. Start building the database in Access.
B. Identify the forms and reports needed.
C. Sit down with paper or a whiteboard to figure out what you want the database to do.
D. Begin programming with visual basic.

Q2. In database planning, what is the reason for separating types of information into different tables?
A. To make programming with visual basic easier.
B. Because all types of information require the same fields.
C. To maintain database normalization and organize data efficiently.
D. Because Access only allows one type of information per database.

Q3. When you are planning fields within tables, why is it beneficial to be as specific as possible upfront?
A. To reduce the need for visual basic programming later on.
B. It makes it easier to split fields apart later, rather than combining them.
C. It's easier to combine fields later, rather than trying to split them apart.
D. To save on storage space within the database.

Q4. What is one common method for determining the types of tables needed and their respective fields?
A. Using experience and example databases as reference.
B. Automatically generating them using Access' built-in wizard.
C. Guessing based on the size of the database.
D. Immediately starting to program and adjust as you go.

Q5. Why does the instructor advise against using spaces in field names and table names?
A. Because spaces can cause problems with visual basic programming and macros.
B. To ensure you use more visual basic coding.
C. Because Access does not allow spaces in names.
D. To make the names longer and more descriptive.

Q6. The instructor mentions that proper relationships will be covered in the future because:
A. It is not necessary to use relationships in Access databases.
B. He is deliberately withholding information to sell more classes.
C. Relationships are an advanced topic that requires understanding of basic database concepts first.
D. He doesn't know much about relationships in Access.

Q7. What is the instructor's rule of thumb regarding fields like phone numbers and email addresses?
A. Always put them in a separate table, no matter the number.
B. Only up to three of each can be stored in a single table.
C. Only one of each should be in the customer table, with the rest stored in the order table.
D. It's always better to combine them into one field for simplicity.

Q8. What is the main purpose of forms in an Access database?
A. To store data efficiently in the database.
B. To print out and fax documents to clients.
C. To provide a user interface for data entry and lookup.
D. To build relationships between tables.

Q9. Why should you not store files like pictures within the database according to the instructor?
A. Because it violates data protection laws.
B. Because it increases the complexity of visual basic programming.
C. It can lead to file corruption and cause performance issues.
D. Because there are better methods to handle files, which will be covered later.

Q10. What is an important distinction made between forms and reports in Access?
A. Forms are designed for screen use and data entry, reports are formatted for printouts.
B. Reports are only used in visual basic programming, while forms are not.
C. Forms can't be printed out, and reports can't be viewed on screen.
D. Forms are for database administrators, reports are for end users.

LESSON 03:

Q1. What is the purpose of creating a new blank database in Access?
A. To read data from an external source
B. To utilize pre-built templates only
C. To create a database shell to contain all your tables, queries, forms, and reports
D. To bypass using the Access interface entirely

Q2. How can you pin Microsoft Access to your Windows taskbar for easy access?
A. By right-clicking the Access icon and selecting "Pin to Start Menu"
B. By dragging the Access icon from the Start Menu to the desktop
C. By right-clicking the Access icon and selecting "Pin to taskbar"
D. By creating a shortcut of the Access icon and placing it in a folder

Q3. In what year was the instructional video created?
A. 1994
B. 2007
C. 2021
D. 2019

Q4. Why might someone use an Access template?
A. To troubleshoot issues in Access
B. To have a pre-built database for quick setup and experimentation
C. To access online databases
D. To avoid learning Access altogether

Q5. Which file extension is associated with Access database files?
A. .xlsx
B. .docx
C. .accdb
D. .pptx

Q6. What is the default view for objects such as tables, queries, forms, and reports when opening them in Access?
A. Overlapping windows
B. Tabbed document interface
C. Spread-out tiles
D. List view

Q7. Which interface change does the instructor prefer to make when beginning with a new Access database?
A. Keeping the tabbed document interface
B. Changing to overlapping windows
C. Hiding the status bar
D. Expanding the navigation pane by default

Q8. Why does Access display a security warning when opening a database?
A. To inform you about broken links
B. To warn about potential malicious code or viruses
C. To notify you of missing plug-ins
D. To alert you about expired software

Q9. What should you avoid doing when you receive an Access database from an untrusted source?
A. Adding new records to it
B. Enabling active content
C. Copying the file to another location
D. Renaming the file

Q10. What kind of content does the instructor plan to build in the series of Access courses?
A. Templates for advanced users
B. A database for a fictitious company called PC Resale
C. A series of spreadsheets for data analysis
D. A digital storefront for e-commerce

LESSON 04:

Q1. What is the preferred method to create a new table in Access according to the tutorial?
A. Datasheet View
B. Design View
C. SharePoint Lists
D. The Lookup Wizard

Q2. Why does the instructor suggest not using spaces in field names in Access?
A. It reduces the file size of the database
B. It looks neater on the form layouts
C. It makes advanced features like VBA programming easier
D. Spaces are not allowed in Access databases

Q3. What type of field would you use to store a social security number according to the video?
A. Currency
B. Auto Number
C. Short Text
D. Number

Q4. What is an Auto Number data type used for in Access?
A. To automatically format numbers as currency
B. To ensure each record has a unique identifying number
C. To compute automatic calculations within the table
D. To store large amounts of textual data

Q5. How should zip codes be stored in Access according to the tutorial?
A. As Short Text
B. As Long Integers
C. As Calculated Fields
D. As Hyperlinks

Q6. Which data type in Access allows users to type up a letter with formatting options like in Word?
A. OLE Object
B. Short Text
C. Long Text
D. Number

Q7. What is the maximum length for a Short Text data type field?
A. 65,000+ characters
B. 1 character
C. 255 characters
D. Unlimited characters

Q8. Access Database is not sensitive to which of the following? - Strike this question. It's not very good. 
A. Field Description
B. Reserved Words
C. Case of Field Names
D. Data Types

Q9. For what purpose does the instructor recommend using currency fields in Access?
A. For international addresses
B. For any numeric data
C. For storing money values
D. For data that requires formatting

Q10. What is the instructor's opinion on Lookup Wizard data types?
A. They are essential for complex databases
B. They make the database user-friendly 
C. They should be avoided for most cases
D. They are only for online databases

LESSON 05:

Q1. In the video, what data type is recommended for storing phone numbers?
A. Long Text
B. Number
C. Short Text
D. Date/Time

Q2. According to the video, when might you consider using a number data type over a text data type?
A. When storing a Social Security Number
B. When you need to perform calculations like sums or averages
C. When storing hyperlinks
D. When keeping track of phone numbers

Q3. What is the suggested limit for the number of fields in one table before considering breaking it down into multiple tables?
A. About 10 fields
B. 50-60 fields
C. Exactly 255 fields
D. More than 100 fields

Q4. When deciding whether to store data as text or a number, which of the following is an important consideration mentioned in the video?
A. The frequency of user access to the data
B. Whether you will be calculating sums or averages with the data
C. The data's relevance to the business model
D. The speed of retrieving the data from the database

Q5. What sort order is applied to number fields according to the video?
A. Alphanumerical
B. Numerical
C. Chronological
D. Random

Q6. Why is storing phone numbers, including those which may contain letters, as text suggested in the video?
A. To keep them in numerical order
B. To ensure calculations can be performed on them
C. Because they might contain characters other than numbers
D. To reduce the size of the database

Q7. What prefix does the instructor prefer to use for fields that represent a count of items, such as the number of employees?
A. count
B. total
C. num
D. qty

Q8. Which type of number field should be used for values that might include a decimal according to the video?
A. Long Text
B. Long Integer
C. Double
D. Currency

Q9. What data type should be used for a field that will store a monetary value, like a credit limit?
A. Double
B. Long Integer
C. Currency
D. Auto Number

Q10. What is the purpose of an Auto Number data type in a database as described in the video?
A. To set a default number for sorting records
B. To store frequent customer numbers
C. To uniquely identify records for internal use
D. To calculate averages and sums

Q11. What type of field did the instructor suggest adding to virtually every table in the database for additional, non-structured information?
A. Currency
B. Long Text
C. Short Text
D. Yes/No

Q12. According to the video, what should the fields in a table be marked with to indicate a relationship with other tables in a database?
A. Foreign keys
B. Auto numbers
C. Primary keys
D. Index keys

Q13. Why does the instructor suggest adding an Is Active yes/no field instead of deleting records?
A. To improve database performance
B. To prevent loss of historical data
C. To mark them inactive rather than deleting
D. To ensure a higher count of total customers

Q14. What does the instructor recommend as a table naming convention?
A. Ending with the letter "T"
B. Table names should start with "TB"
C. Using plural forms for all table names
D. Always including the year of creation in the table name

Q15. What concept related to database keys does the instructor emphasize will be important later for creating relationships between tables?
A. Composite keys
B. Candidate keys
C. Natural keys
D. Auto numbers

LESSON 06:

Q1. What view allows you to add or edit data in a table?
A. Design View
B. Layout View
C. Data Sheet View
D. Pivot Table View

Q2. What does the customer ID "auto number" field do when you begin typing a record?
A. It must be entered manually for each record.
B. It generates a unique numerical identifier automatically.
C. It creates a duplicate number from the previous record.
D. It requires you to select from a predefined list of IDs.

Q3. Which keyboard keys allow you to navigate to the next or previous fields without using the mouse during data entry?
A. Tab for next; Enter for previous
B. Tab for next; Shift + Tab for previous
C. Ctrl for next; Alt for previous
D. Shift for next; Ctrl + Shift for previous

Q4. How can you quickly adjust a column so it fits all the data and the title in Access Data Sheet View?
A. Right-click on the column and select "Fit to Data"
B. Drag the column separator until content fits
C. Double-click the column separator
D. Select "AutoFit Column" from the Table Tools menu

Q5. What does a "dirty" record indicate?
A. The record is marked for deletion.
B. The record has been saved to the table.
C. The record contains corrupt data.
D. The record is being edited and hasn't been saved yet.

Q6. Which function key opens the zoom window in Access?
A. F1
B. F2
C. Shift + F2
D. Alt + F2

Q7. To see a record with entered data as "committed to disk," you should:
A. Press the save icon in the Quick Access Toolbar.
B. Move to another record.
C. Press Ctrl + S.
D. Write a commit command in SQL view.

Q8. In which class does the instructor plan to cover default values?
A. Access Beginner 1
B. Access Beginner 2
C. Access Beginner 3
D. Access Beginner 4

Q9. What is the shortcut key for entering today's date in a date field?
A. Ctrl + D
B. Alt + D
C. Ctrl + ;
D. Shift + Ctrl + D

Q10. Which is not a recommended practice for entering phone numbers according to the tutorial?
A. Using just the digits without any formatting
B. Including parentheses, dashes, or other characters
C. Keeping data consistent for query use
D. Formatting them later using an input mask

LESSON 07:

Q1. What can be downloaded from the tutorial host's website to avoid having to type in records manually?
A. A guide on how to enter data
B. A link to purchase the full course
C. A sample database with records
D. An update patch for the Access software

Q2. According to the tutorial, what is the customer ID primarily used for?
A. It is an essential piece of data used for customer communications.
B. Access uses it internally for its own tracking and relationships.
C. It must be entered manually for each new customer.
D. It is a randomly generated number for security purposes.

Q3. The presenter suggests that if a user does not have certain information, like a phone number or zip code, it is best to:
A. Leave the corresponding field blank.
B. Enter a placeholder value like "N/A".
C. Create a new record without the missing information.
D. Guess the information and correct it later.

Q4. What is a 'Validation Rule' in Access?
A. A principle that validates the performance of the database.
B. A design feature that changes the color of the record selectors.
C. A property that ensures data entry conforms to specific criteria.
D. An automatic correction tool for typographical errors in records.

Q5. What does pressing the Escape key do when editing a new unsaved record in Access?
A. It saves the changes made to the record.
B. It deletes the record.
C. It cancels the changes and removes the unsaved record.
D. It locks the record for editing by other users.

Q6. If a user begins typing in a new record, what becomes of the auto number assigned to that record?
A. It is temporarily reserved until the record is saved.
B. It is permanently assigned to the record and cannot be reused.
C. It is reassigned to the next record in line.
D. It is discarded if the user decides not to save the record.

Q7. What is one reason the presenter prefers to enter data directly into the tables?
A. To train end users on how to use the database.
B. To test and ensure that the table's data works as expected.
C. Because it is recommended practice for Access databases.
D. To improve the speed of the Access database.

Q8. Where can users normally make changes to the settings for delete confirmations in Access?
A. Under the Home tab in the ribbon.
B. In the Options under the File menu.
C. On the Access database homepage.
D. By right-clicking the record selector.

Q9. How can a user move columns in Access tables?
A. By cutting and pasting the columns.
B. By dragging the column headers to a new position.
C. By using the sort and filter feature.
D. By modifying the table's design view.

Q10. When does Access prompt to save layout changes for a table?
A. After each record is entered
B. When the user moves columns around or resizes them
C. Whenever a new record is inserted or deleted
D. Only when the user exports the table

LESSON 08:

Q1. Which view should you be in to sort and filter data quickly as a developer?
A. Table Data Sheet view
B. Design view
C. Form view
D. Report view

Q2. What is the shortcut for sorting a field in ascending order from an open drop-down menu?
A. Select the "Sort Largest to Smallest" option
B. Click "Sort Z to A"
C. Click on the sort ascending button (A to Z)
D. Right-click and select "Sort New to Old"

Q3. What is the primary difference between a numeric and an alphanumeric sort?
A. A numeric sort arranges the numbers based on their arithmetic value, while alphanumeric is based on character order
B. They are both sorted based on arithmetic value
C. Alphanumeric sorts are for text fields only
D. Numeric sorts consider blank spaces before numbers

Q4. If a field looks like a number but is actually a text field, how will it sort?
A. In numeric order from smallest to largest
B. Based on character order as an alphanumeric sort
C. Randomly because it isn't a true numeric field
D. It will fail to sort because it is not a number

Q5. How does Access internally store date/time fields for sorting purposes?
A. As a sequence of characters representing the date
B. As a string in "YYYY-MM-DD" format
C. As a numerical value where smaller numbers are earlier dates
D. In a human-readable “Month Day, Year” format

Q6. How can you remove all sorts applied to your data?
A. Close the table and reopen it
B. Click on the "Remove Filter" option
C. Select the "Remove Sort" button
D. Right-click on the column and select "Unsort"

Q7. What kind of list might you use queries to save for future reference without having to reapply filters and sorts?
A. A list of all customers with overdue accounts
B. A list sorted by last name ascending for customers from New York
C. A list of all products in stock
D. A list of all the tables in the database

Q8. What happens to the records that do not match the filter criteria when you apply a filter?
A. They are permanently removed from the database
B. They are hidden from view but remain in the table
C. They are moved to a temporary storage area
D. They are deleted but can be retrieved from a backup

Q9. What does the status bar indication of "filtered" signify when you apply a filter?
A. It indicates that only filtered records are permanent in the table
B. It shows that some records have been filtered out from the current view
C. It means that new records will automatically be filtered upon entry
D. It warns that the filtering process has not completed successfully

Q10. True or False: Numeric fields and currency fields behave similarly when being sorted.
A. True
B. False
C. Not applicable
D. It depends on the field configuration

LESSON 09:

Q1. What is the primary purpose of creating a query in Access? What will you use a query for MOST of the time. Yes, some of the other answers are possible to do with queries, but what will you use them for the most?
A. To delete data from your database
B. To permanently store data
C. To display data based on certain criteria
D. To modify the structure of a table

Q2. When you start to create a new query in Access, which section in the Create tab do you use?
A. Table Design
B. Report Design
C. Query Design
D. Macro Builder

Q3. What type of query allows you to select data from a table?
A. Append Query
B. Make Table Query
C. Update Query
D. Select Query

Q4. If the Add Table pane does not appear when creating a query, what should you click?
A. The Query Wizard button
B. The little add tables button
C. The close window button
D. The show table button

Q5. To add fields to a query in Access, you need to:
A. Write a SQL statement
B. Drag them from the table to the query columns
C. Use the Query Wizard
D. Import them from Excel

Q6. After adding fields to a query, how do you view the results?
A. Click the Save button
B. Click the Run button
C. Click the Add Field button
D. Right-click and select Show Data

Q7. How can you permanently sort data in a query?
A. Use the sort row in Design View
B. Apply a sort in Datasheet View
C. Type a SQL ORDER BY statement
D. Use a custom VBA function

Q8. How do you delete a field from a query in Access?
A. Right-click the field and press Delete
B. Drag the field out of the query window
C. Select the column and press the delete key on the keyboard
D. Go to the External Data tab and select Remove Field

Q9. What is the consequence of modifying data in a query?
A. It only changes the data in the query, not the table
B. It deletes the data from the database
C. It triggers a backup of the database
D. It changes the data in the table as well

Q10. How can you rename and save a modified version of an existing query?
A. Use the "Save As" feature
B. Edit the query name in the SQL statement
C. Change the name in the navigation pane directly
D. There's no way to rename an existing query

Q11. If you wanted to filter a query to show only customers from a specific state, which field would you need to add to the query and where would you input the state's abbreviation?
A. Add the State field to the criteria row
B. Add the State field to the sort row
C. Add the abbreviation to the show row
D. Input the state's abbreviation in the Query Wizard

Q12. What is a parameter query?
A. A query that automatically deletes records based on parameters
B. A query that prompts the user for input when it is run
C. A query that can be edited only by authorized users
D. A query that updates parameters in the table

Q13. What is the purpose of the little asterisk or star in the query design table list?
A. To add all fields to the query at once
B. To create a new table with the selected fields
C. To mark fields as key fields
D. To insert a calculated field in the query

Q14. Why might a user utilize the "show" check boxes in a query?
A. To permanently delete fields from the table
B. To hide fields in the query results that they don't want to display
C. To show only the fields with errors
D. To highlight selected fields in the Design View

Q15. Can you make a query that allows editing of the data displayed in it?
A. No, queries are strictly for viewing data and cannot be edited
B. Yes, but only if the query is created using SQL View
C. No, editing must be done directly in the tables
D. Yes, queries show live data and changes reflect in the underlying table

LESSON 10:

Q1. What is the primary purpose of using forms in Microsoft Access?
A. To create complex reports for advanced data analysis
B. To simplify the process of entering, editing, and finding information in a database
C. To enhance the database's security features and permissions
D. To replace the need for tables and queries in a database

Q2. Which of the following statements about forms is NOT true?
A. Forms can be designed to display data from multiple tables on one form.
B. Forms prevent users from editing or deleting any data in the underlying tables.
C. Forms can improve efficiency by providing a user-friendly interface.
D. Subforms can be used to display related information inside another form.

Q3. What are the two primary ways to build a form in Microsoft Access as mentioned in the video?
A. Layout View and Design View
B. Navigation View and Datasheet View
C. Simple Mode and Advanced Mode
D. Report View and Query View

Q4. When building a form, which view does the instructor plan to focus on throughout most of the course?
A. Layout View
B. Datasheet View
C. Design View
D. Report View

Q5. What happens when you delete a record from a form?
A. The record is only hidden and can be retrieved later.
B. The record is temporarily archived for future use.
C. The record is permanently deleted from the underlying table.
D. The record is transferred to a new table for deleted items.

Q6. How can one transform a form to resemble existing paper forms?
A. By adjusting security settings
B. By customizing the form's layout and design
C. By using a special paper form import tool
D. By converting the database to a spreadsheet format

Q7. When opening a form for the first time after saving, in which view will it open by default?
A. Layout View
B. Datasheet View
C. Form View
D. Design View

Q8. How can a user modify the layout of a form that's already been created?
A. By entering Data Entry Mode
B. By switching to Layout View
C. By converting the form to a query
D. By exporting the form to an external editor

Q9. What indicates that a record on a form has not been saved yet when editing?
A. A green checkmark next to the record
B. A red exclamation mark next to the record
C. A blinking cursor in the record's fields
D. A pencil icon next to the record

Q10. What should one do to ensure changes in a form take effect, especially when coding is involved?
A. Preview the form in Report View
B. Close and reopen the form
C. Lock the form to prevent further edits
D. Export the form to another database

LESSON 11:

Q1. Which Access view is being emphasized as the proper method to build forms in this tutorial?
A. Datasheet View
B. Layout View
C. Form View
D. Design View

Q2. What is the first step after creating a blank new form in Design View according to the tutorial?
A. Add existing fields from the table to the form
B. Set the record source
C. Change the color of the form
D. Resize objects, labels, and text boxes

Q3. How can you access the form's property sheet to set the record source in Design View?
A. Click on the "Property Sheet" button on the ribbon
B. Double-click on the small block where the two ruler bars meet at the corner
C. Right-click on the form and select "Properties"
D. Press F4 on the keyboard

Q4. When dragging fields onto the form from the Field List, what two components are created with each field?
A. Command Button and Label
B. Text Box and Label
C. Subform/Subreport and Label
D. Combo Box and Label

Q5. How can you select and move multiple controls at once on the form?
A. Use the "Select All" button from the ribbon
B. Hold down the Ctrl key and select each control
C. Click and drag a box around the controls
D. Hold down the Shift key and click on each control you want to select

Q6. How can you delete just the label of a control, without deleting the corresponding text box?
A. Click the label and press Ctrl+D
B. Click the label and press Delete
C. Right-click the label and choose "Delete Label"
D. It's not possible to delete just the label

Q7. To change the background color of a form in Design View, you should:
A. Right-click on the background of the form and select "Color"
B. Go to the "Design" tab and choose "Background Color"
C. Go to the "Format" tab and choose a color from the "Background Color" section
D. Use the "Paint Bucket" tool and select a color from the palette

Q8. What should you do if you want to adjust the form to fit exactly around the fields that have been placed on it?
A. Use the "AutoFit" feature
B. Manually resize the form's edges
C. Click "Fit to Window" in the View tab
D. Drag the fields to the form's border

Q9. Why does the instructor prefer to use standard colors over theme colors for forms?
A. Standard colors are brighter
B. Standard colors do not change with the user's theme settings
C. Theme colors are only available in newer versions of Access
D. There are more standard colors than theme colors

Q10. According to the tutorial, in what later level will students learn more advanced form design?
A. Level 1
B. Level 2
C. Level 3
D. Level 4

LESSON 12:

Q1. What is the primary difference between forms and reports in Microsoft Access?
A. Forms are used for entering and editing data, while reports are for displaying data.
B. Forms are used only for printing purposes, while reports are used for data entry.
C. Reports are used exclusively for creating new tables, while forms are for queries.
D. Forms and reports serve the same purpose and are interchangeable.

Q2. Which view will show you what the report will look like when printed?
A. Report View
B. Design View
C. Print Preview
D. Layout View

Q3. What design method does the instructor prefer for creating reports in Access?
A. Simple Report Designer
B. Report Wizard
C. Report Design (blank report)
D. Labels

Q4. How can you modify a report to only display data for active customers?
A. Use the 'active' filter in the simple report designer.
B. Create a form that allows you to check the 'active' status for each customer.
C. Create a query that filters for customers where 'Is Active' is true, and base the report on this query.
D. Manually remove inactive customers from the report in Design View.

Q5. Which Access tool is specifically used for creating mailing labels?
A. Simple Report Designer
B. Report Wizard
C. Labels
D. Blank Report

Q6. What does the instructor suggest as a naming convention for knowing if an object is a Table or a Query?
A. Using 'Form' or 'Report' at the beginning of the name.
B. Adding a 'T' for Tables or 'Q' for Queries at the end of the name.
C. Using the entire word 'Table' or 'Query' in the name.
D. Adding a 'T' for Table or 'Q' for Query at the beginning of the name.

Q7. When using the report wizard, how can you indicate that you want to sort customers by their last name and then by their first name?
A. Specify the sort in the query design before creating the report.
B. Select 'last name' and then 'first name' in the report wizard sort step.
C. Cannot sort by the last name and then the first name using the report wizard.
D. This can only be done manually in Print Preview.

Q8. If you see an error message stating "some data may not be displayed" regarding mailing labels after using the label wizard, what might be the issue?
A. The report needs to be recreated from scratch.
B. The width of the label prototype is likely too wide, and the edges should be slightly adjusted inward.
C. The fields selected do not contain any data.
D. The wrong label type was selected and needs to be changed in the wizard.
   
Q9. Why should you avoid feeding a sheet of labels through a laser printer more than once?
A. The toner used in laser printers makes the labels too dark.
B. Repeated heating from the printer can cause the labels to peel off and get stuck inside the printer.
C. The labels will smudge if printed on more than once.
D. Recycled paper is not compatible with laser printers.

Q10. What does the instructor recommend for printing a lot of single labels rather than sheets?
A. Using an inkjet printer for all label printing tasks.
B. Investing in a dot matrix printer for its efficiency.
C. Purchasing a Dymo label printer for one-off label printing.
D. Handwriting labels to avoid printer issues.

LESSON 13:

Q1. In which video does the instructor cover how to create a form that allows you to select a customer and open their record? (This is an example of a question that the AI added that I wouldn't necessarily include myself. I'd delete it from the final quiz. Just leaving it here to see who REALLY pays attention).
A. Access Beginner Level 5
B. Access Beginner Level 7
C. Continuous Forms video
D. Blank Template video

Q2. What must laptop users often press in addition to the Shift-F2 to open the zoom window?
A. Alt key
B. Control key
C. Function key
D. Command key

Q3. Can you zoom in and out of objects (tables, queries, forms, reports, etc.) in Access like you can in Excel and Word?
A. Yes, for all Access objects
B. Yes, but only for reports
C. No, it's not possible in Access
D. Yes, with a special add-on

Q4. How can you increase the font size in datasheet view for better visibility?
A. You can't change the font size in Access
B. Change the theme of Access
C. Use the zoom feature on the form
D. Modify the font size in Options under the File menu

Q5. What is the correct method to delete a table?
A. Edit the table properties and select 'Delete'
B. Right-click the table in navigation pane and hit delete
C. Drag the table to the recycle bin
D. Use the delete record function while the table is open

Q6. Should you create an auto number as a primary key if you already have pre-assigned unique identifiers like student numbers?
A. No, only use the pre-assigned identifiers
B. Yes, use both an auto number and keep the pre-assigned identifiers
C. Only use auto numbers for new records
D. Pre-assigned identifiers become obsolete in Access

Q7. After deleting entries, if there are gaps in the auto numbers sequence, should you be concerned?
A. Yes, because it affects relationships
B. No, because auto numbers are for Access, not users
C. Yes, because it can corrupt data
D. No, because it means the database is running efficiently

Q8. What should you consider when a customer has multiple phone numbers or addresses?
A. Create a separate database for each category
B. Limit the number of fields in one table to three for simplicity
C. Make multiple fields in the same table for a few entries but use a related table if there are more
D. Always use a separate related table regardless of the number

Q9. How can you import Excel sheets into Access?
A. Copy and paste the data directly into Access tables
B. Manually recreate the data entries in Access
C. It's impossible to import from Excel to Access
D. Use the Excel importing features covered in Access Expert Level 20

Q10. If a customer falls under multiple classifications, like sales and service, how should you handle them in Access?
A. Create three separate tables for each classification
B. Use a many-to-many relationship
C. Ignore additional classifications and choose one primary
D. Create a new field for every classification combination

Q11. How can you prevent regular office users from making design changes to your database?
A. You can't prevent users from making changes
B. Use password protection on each object
C. Implement security measures from the Simple Security video
D. Change the file to read-only

Q12. Is there a web-based version of Access available for use over the internet?
A. Yes, it's readily available
B. No, but there are other solutions to run Access remotely
C. Yes, but only for certain versions of Access
D. No, Access can only be used on a local device

Q13. What should you NOT use when trying to run Access through file-sharing services?
A. Local Network Drives
B. Dropbox, OneDrive, Google Drive
C. Microsoft Teams
D. Email attachments

Q14. What do you need to back up to ensure all your Access database components are safe?
A. Each object individually (tables, forms, queries, etc.)
B. The accdb file only
C. Screenshots of your database setup
D. Printouts of your database tables and forms

Answers can be found in the comments section, below.

When you're finished with this one, take the Access Beginner 2 Quiz. 

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.