Q&A From Students

Lesson 13: Top Beginner Questions Answered

S M L XL FS | Slo Reg Fast 2x | Bookmark

In this lesson, Q&A From Students, we will cover the most common questions asked by students over the last 20 years about working with Microsoft Access. I will explain how to set up customer lists and navigation forms, fix function key issues on laptops, zoom in on reports, change datasheet font sizes, delete tables, use autonumbers, handle mail merge and letters, distribute Access databases using the runtime version, manage multiple contact details, import data from Excel, handle customer classifications, secure your database, run Access remotely, create menu systems, and properly back up your database.

Navigation

Prev: Lesson 12
Next: Lesson 14

Keywords

Access Beginner, customer form, continuous forms, blank template, shift F2, zoom in forms, delete table, autonumber gap, mail merge, runtime edition, multiple phone numbers, import Excel, customer classifications, many to many relationship, database secur

Subscribe to Q&A From Students
Get notifications when this page is updated

Intro

Transcript

Welcome to the question and answer segment of the class. As I mentioned in the earlier videos, I have been teaching this course for over 20 years now and during that time, I have seen a lot of the same questions come up over and over again.

I cannot take the time to answer every question during class. It is already over four hours long. So I put together this Q and A list of the top questions that I have seen come up over the last 20 years. One thing that I have learned is that people hate when I say, "We will get to that in a future class," which I used to do before I had all these videos recorded.

But I have all these videos recorded now. So all of these questions are answered in other videos, some are free and some are future classes. This will be a list of all of the popular questions and where you can find the answers. So if you need an answer to something now, here it is.

This question is, "I want to make a form that has a list of all of my customers and I would like to be able to click on one of those customers to open up their record in the customer form. How can I do this?"

This is something that we will cover in Access Beginner Level 7. I also have two of my free TechHelp videos, the Continuous Forms video and my Blank Template video, that will explain how to do it. There are the links. I will put links in the links section down below so you can just go click on them.

You can see an example of the customer list form from Access Beginner 7. You just click on one of these customers and click on the Open Selected Customer button and it opens up their form. And here it is in the TechHelp Free Template. Just click on the Customer List button there. There is the customer list and you can either click on the button, like click on John Luke and then hit the Open Customer button or I show you how to make a double click event. You double click and it opens up that way too. There are a lot of different ways to do it.

I press the Shift F2 key to open up the zoom window. It does not come up. This happens a lot with laptop users. Me included. I use laptops for all my work. Generally, when you get a laptop, the function keys have been remapped, so you have to actually use the function key too. So instead of just going Shift F2, you have to go Shift Function Key F2. I know that is annoying to me too, but everybody always asks this question so I figured I would share it.

There is a way that you can remap that so that the function keys are not necessary to hit the actual function keys. On a lot of laptops, for example, those function keys will also be for screen brightness up and down, the volume up and down. You can switch that and each laptop is different. You have to look in your laptop documentation.

Is there a way to zoom in with forms and tables and queries and stuff? Unfortunately, the answer is no. In Access, the only object that lets you zoom in and out is a report. Here, for example, is an invoice report that I built. You can click on it to zoom in or you can use a little zoom bar down here for reports, but unfortunately for forms and tables and queries, you cannot do that.

I know in Excel and Word and PowerPoint, you can zoom in and out, but you cannot in Access. Unfortunately, Microsoft does not give the same love to Access that it gives to those other apps because Access is not as popular. A lot of people really want that feature to be able to zoom in and out on a form, especially for people that are hard of sight, including myself. You can design a bigger form with bigger fonts and bigger text boxes, but you cannot do it with just this one standard, this form here, or in tables. You cannot zoom in and out of tables either. So yes, a lot of people ask for that, but you cannot do it.

You can change the datasheet font size. In tables, for example, you can go into File and then Options. Under datasheet, you can change right here the size of your font. You jack it up to 20 points, for example. Now when you open up any datasheet, you can see everything is much, much bigger. That is an option.

However, one of the things that I am going to teach you is that you generally do not want to poke around in your tables and your queries. You want to work with forms and that setting does not change the font size in forms. A lot of people ask this and I am pretty sure I mentioned it somewhere in the course but not positive.

How do I delete a table? I just right click on it in the navigation pane and hit Delete. Here is your navigation pane. So if you want to get rid of version history, T, just right click on it and pick Delete. It will ask if you are sure. Once it is gone, it is gone, by the way. There is no undo. When you delete something, it is gone. Back up your database. We will talk about backing up in a few minutes.

Here is a popular question. I am building a database where I already have a student number assigned to each student by the university. Should I still create an autonumber as the primary key? I get this question a lot. I have already got customer IDs assigned in my old paper system or with Excel. I have already got product IDs that I am given from the suppliers. Should I keep those numbers?

Yes. Definitely keep those numbers. Make a field in your table called, in this case, student number and store that number. But you should make an autonumber too and have that as your ID field, student ID, for example. There is nothing wrong with having two different fields like that, a student number and a student ID, a product ID and a product code, whatever.

We will talk about relationships when we get to the expert series. I am going to talk a little bit about relationships in the next class, Access Beginner 2. Access uses those ID fields for making relationships between tables for relating customers to orders, students to classes, that kind of stuff. That is relationships. We are going to learn a lot more about relationships as we move forward.

Those autonumbers are not for you. They are for Access. You do not even need to worry about what they are. Watch that video there. My autonumbers video explains all of this in a lot more detail if you want to learn more about autonumbers.

I deleted a couple of customers that are no longer with me. Now there is a gap in my autonumbers. How do I get them back? Again, just like the answer to the last question, do not worry about them. Those autonumbers are not for you. They are for Access. So if you delete a customer and he is gone for good, do not worry about that autonumber. It does not matter if they go one, two, three, four, eight, twelve, twenty-six. This is for making relationships.

There is an exception. If you already have relationships set up in your database, let us say you have got customers one, two, and three and you have got orders in the system for customer two and you accidentally delete customer two. Now you have a whole bunch of orders in there missing their customer. So yes, there is a way you can restore that autonumber. There is a link right there. Go watch that video if you absolutely need to get that autonumber back. It is possible.

Sometimes people just want a counter variable. They want a number that goes one, two, three, four, five and counts up. Orders, for example. You can make unique order numbers for a customer and each customer has order one, order two, order three, and so on. That is possible. Again, I have another video on that. It is a little more advanced and requires a tiny bit of programming. Go watch my counter video if you want to learn how to do that.

Can I use my Access database to send out letters to all of my customers? Absolutely, you can. You can actually write all of your letters inside Access as a report. I cover that in Access Expert Level 5. You can also write the letter in Microsoft Word and then use Access as your data source for a mail merge. I cover that in my Microsoft Word 201 class and in my Access Expert 19 classes. If you want a quick version, watch my Letter Writer video. That is a TechHelp video that does the same thing in a quick format.
It is possible. It is one of my more popular classes, how to make Access into a letter writer. You can do it with or without Microsoft Word.

Here is another very popular question. I want to build an Access database for everyone in my company to use. But the boss does not want to fork over that much cash to buy copies of Microsoft Office for everyone, especially the warehouse guys who could use the database but do not need Excel, Word and all that. Is there a cheap version of Access available?

The answer is no. There is not a cheap version available, but there is a free version available. It is called the runtime edition. You use the runtime edition for people who only need to use the database and do not need to make design changes. So you have one copy of Access for the developer, the person who is building the database, and everybody else in the organization can get the runtime edition and it is absolutely free. Go watch that video that will explain how to get it, how to install it, and how to use it.

If you have 20 or 30 people in your office and 10 people in the warehouse, they all have their own workstations, and they need to be able to use the database to enter in products or whatever, all their copies are free. You just need to buy one copy of the full Microsoft Office with Access for your designer, for your developer.

What if a customer has multiple phone numbers, emails or addresses? I am pretty sure I talked about this in class, but generally as a rule of thumb, if they have two, maybe three of something, then it is okay to make multiple fields in the same table. Home phone, work phone, cell phone, not a problem. Shipping address, billing address, not a problem. If it goes over three, then you should consider making a second related table. We are going to focus on relationships in Access Expert Level 1. I talk about it a little bit more in Beginner 2, but we are going to give the full treatment in Access Expert Level 1.

I have seen people build databases where they were doing orders, for example, and instead of having an order table and then an order details table for all of the line items, the individual products on the order, they had 20 order item fields: product 1, product 2, product 3, product 4. Do not do that. That is bad database design. You will learn why in those two videos, Access Expert 1 and my relationships video.

We will get to that. This is a very important part of Access. It is also a little more advanced though. I cover it a little bit later on. So right now we are just focusing on basic database design, but keep that in mind. If you have six of something or like children, they might have zero children, they might have 10 children. You do not know how many children they are going to have. You do not want to reserve 10 fields. That goes in a separate related table.

I have been using Excel for years. How can I import all of my Excel sheets into Access? It is certainly easy to do, but it can be difficult to do right, especially if your data is not in your Excel sheets the right way. If you do not have all of your columns with the same kind of data, I have seen people do some really weird stuff with Excel sheets. So I give importing data from Excel the proper treatment in Access Expert Level 20.

It is not hard to do. If everything works great the first time and all your data is nice and orderly, then yes, it is easy. But when you have problems, you can be pulling your hair out all night trying to figure out why it is not working. We will get to that.

I have three different classifications of customers: sales, service, and warranty only. How can I differentiate between them? Right now I have them in three separate Excel sheets.

One thing you do not want to do in Access is have three separate tables with the same type of stuff. Customers are customers. They all have the same fields pretty much for the most part: first name, last name, address, phone number, all that stuff. You do not want to have three different tables with the same kind of stuff in them.

What you will do is put a field in that table to indicate what kind of customer this is: is it a sales customer, is it a service customer? Now, the tricky part is if one customer can be in multiple classifications. If someone can be a sales and service customer, or a service and warranty only customer, or all three, then you have to use something called a many-to-many relationship. It is a little more difficult. We will get to it in Access Expert Level 7. I also have a TechHelp video called Many to Many. That is where you find that answer. Yes, it can be done. It takes a little work.

Here is a big one. How can I keep people from changing the design of my forms, reports, tables, etc., poking around in my database?

Securing your database can take some work. I have a whole seven-hour course on just properly securing your database. It is called the Security Seminar. That is the first link there. It walks you through everything you need to know to properly lock down your database. We add user log-ons, all kinds of stuff, tracking what they do in the database with an audit log. That will keep pretty much the best hackers out of your database.

If you just want some simple tips on keeping your average Joe office user from messing with the database, I have that Simple Security video too. That will give you enough information to keep the majority of regular normal office people out of your database. We will lock it down a little bit. If you are worried about hackers in your office, I have the Security Seminar.

So Access can be very secure or it can be not secure at all. It depends on how much effort you put into securing it. Watch the Simple Security video first. If you need really good security, go get the Security Seminar.

This is a popular recent question in my forums and I figured I would include it here. With the COVID pandemic, lots of people are working from home. Is it possible to run Access over the web?

This is a tricky question to answer. There really is not one easy answer. There is no web-based version of Access. However, there are ways that you can run your database remotely over the Internet. I have a page on my website with some free videos that talk about how to run Access online. Go to that page and watch what is there and read that page over.

Whatever you do, I see a lot of people trying to do this: do not use Dropbox, OneDrive, Google Drive, or any of those file sharing services. There is a good chance you will corrupt your database. People try to run Access with other people through Google Drive or Dropbox or whatever. Do not do that. That is bad. Go watch that video and read what is on that page. You will get all the information on this. This changes often. There is always something new coming out, so keep checking that.

Is there a way to make a menu system in Access so I do not have to poke around on the navigation pane to find what I am looking for? Yes, we will cover that in Access Beginner 7. I also show how to do that in my Blank Database template for TechHelp. Here it is right here in my Blank Database template, my TechHelp Free Template. You will hear me refer to this a lot. It is basically a form with some labels and some buttons on it. You click a button. There is your customer list. There is your customer form. There is your order form.

We can use buttons and forms to make our menuing system. There is something called the Navigation Form. I do not like those. If you want to see why, there is another video you can go watch where I talk about Navigation Form. Switchboards they used to be called. Back in the old days, they were called switchboards and they upgraded to something called Navigation Forms, but I do not like either of those. I like to make my own menu.

Finally, to round out the questions for Access Beginner 1, what do I have to do to back up my database? There is a page right there. Back up. Fortunately, everything you need, all your tables, forms, queries, reports, all that stuff is stored in one file. It ends in ACCDB. It is wherever you happen to store it when you have created your database file. Back up that one file, and that is all you have to worry about. Everything is contained in there. Your forms, your queries, your data, everything you have typed in is all in that one file. Go watch my backup video for complete details.

So that is it. That is the Q and A session for Access Beginner Level 1. These are the most popular questions that I have been asked over the last 20 or so years that I have been doing this. If you have questions, post them on my website, right on the page that you find all these videos on. Scroll down to the bottom, and you will see where all the other questions and answers were posted. Feel free to post yours there.

Thanks, and I hope you learned something today.

Quiz

Q1. What is the recommended way to open a specific customer's record from a list in Access?
A. Use a form with a list of customers and a button or double-click event to open their record
B. Enter the customer name into the navigation bar
C. Use the search function in Access tables
D. Manually look up the customer record in the navigation pane

Q2. Why might Shift F2 not open the zoom window on some laptops?
A. The laptop has no function keys
B. The function keys are remapped and require the Fn key to be pressed
C. The laptop does not support Access shortcuts
D. The database is missing a necessary add-in

Q3. Which object in Access allows you to use the zoom feature natively?
A. Forms
B. Queries
C. Reports
D. Tables

Q4. What can you do to increase datasheet font size in Access tables?
A. Change font settings in File > Options under datasheet
B. Zoom in using Ctrl + Mouse Wheel
C. Expand the window to full screen
D. Use the magnifying glass tool

Q5. To delete a table in Access:
A. Click Delete in the Home ribbon
B. Use the File menu and select Delete Table
C. Right-click on the table in the navigation pane and choose Delete
D. Select the table and press Ctrl + D

Q6. If you already have an assigned student number from another system, what should you do in Access?
A. Disregard the old number and use only an autonumber primary key
B. Keep the student number as a separate field and also create an autonumber primary key
C. Merge both numbers into a single field
D. Use only the student number as the primary key

Q7. What should you generally NOT worry about with autonumber primary keys when records are deleted?
A. Gaps in the sequence of numbers
B. Data integrity for orders
C. Backing up your database
D. Relationships between tables

Q8. What is the primary role of an autonumber field in Access?
A. To create a user-visible identifier for printouts
B. For Access to manage table relationships internally
C. To match external IDs from other sources
D. To determine record sorting order

Q9. How can you send letters to all customers using Access?
A. Write all letters manually in Word
B. Use Access reports or a mail merge with Word
C. Use PowerPoint to generate the letters
D. Export data to Excel and use Excel mail merge

Q10. What is the free version of Access for users who do NOT need to make design changes?
A. Office Starter Edition
B. Access Lite
C. Access Runtime Edition
D. Access Read-Only Mode

Q11. When is it acceptable to have multiple fields for phone numbers or addresses in a customer table?
A. Only when there are more than five numbers/addresses
B. For only one contact per customer
C. If there are two or three of them
D. Never; always use a related table

Q12. If customers can belong to multiple classifications (such as sales, service, warranty), what is the recommended approach?
A. Create separate tables for each classification
B. Use a many-to-many relationship with a related table
C. Store classification in a single text field only
D. Assign a unique table to each classification

Q13. What is advised if you want to import Excel data into Access?
A. Paste the Excel rows directly into a form
B. Use the import feature, but be careful with inconsistent data
C. Set up macros in Access to import automatically
D. Only import files saved in CSV format

Q14. To keep non-developer users from changing the design of your database, what should you use?
A. Windows file permissions only
B. Access runtime and a simple security setup
C. Remove the navigation pane entirely
D. Require a password for each record

Q15. What is the danger of using OneDrive, Dropbox, or similar services to share an Access database file?
A. It can slow down database performance
B. It might make backups more difficult
C. It has a high risk of corrupting the database file
D. It improves collaboration and user access

Q16. What is the recommended way to create a menu system in Access?
A. Use built-in Navigation Forms or Switchboards only
B. Create your own custom menu form with buttons
C. Rename the navigation pane
D. Use a macro to load forms automatically at startup

Q17. What must you back up to save all your Access data, forms, queries, and reports?
A. The ACCDB file only
B. Only the tables
C. Each report and form file individually
D. The ACCDE executable

Answers: 1-A; 2-B; 3-C; 4-A; 5-C; 6-B; 7-A; 8-B; 9-B; 10-C; 11-C; 12-B; 13-B; 14-B; 15-C; 16-B; 17-A

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.

Summary

Today's video from Access Learning Zone is a special Q and A session where I am answering the most common questions I have received after teaching Microsoft Access for over 20 years. Instead of repeating myself in every class or having to tell students to wait until future sessions, I have compiled a comprehensive list of frequently asked questions and referenced exactly where you can find detailed answers in my other lessons and free videos.

A recurring question I get is how to create a form in Access that displays a list of all customers and allows you to easily open a specific customer's record by clicking on their name. This is covered in detail in Access Beginner Level 7. I have also created free TechHelp videos, such as Continuous Forms and my Blank Template video, that walk you through building this functionality. With these resources, you will see examples where you click on a customer's name and open their full record, either by clicking a button or by setting up a double-click event. There are several approaches to achieve this.

Another frequent issue, especially for laptop users, is being unable to open the zoom window with Shift and F2. Laptops often have the function keys mapped to system controls like screen brightness and volume. Usually, you need to hold down the Function (Fn) key along with Shift and F2. If you want to change this behavior, you will have to check your laptop documentation for instructions, as it varies from model to model.

Students also frequently ask if it is possible to zoom in on forms, tables, or queries. Unfortunately, Access only allows zooming in reports, not in other object types. Unlike Excel or Word, you cannot zoom into a data entry form or datasheet, which can be frustrating, especially for those who need larger text. One workaround is to increase the datasheet font size through File - Options. Keep in mind, though, that this does not affect forms, and I always recommend using forms for data entry rather than working directly in tables or queries.

If you need to delete a table, simply right-click on it in the navigation pane and select Delete. Once deleted, it is gone for good, and there is no undo function. Make sure you back up your database regularly.

A common design question involves whether to use an autonumber field as the primary key if you already have unique identifiers, like student or customer numbers from another system. My recommendation is to keep your original numbers in the table, but still add an autonumber field for Access to use as the primary key. Autonumbers help maintain relationships between tables and are mainly for Access's internal use. If you accidentally delete a record, you may create gaps in autonumbers, but these gaps do not matter for relational purposes. There are rare cases where you might need to restore a deleted autonumber, and I have a video that explains how if you ever need to do that. Additionally, if you need a simple sequential counter, such as order numbers per customer, that can be done with a little programming, and I have covered that topic as well.

Another popular question is about generating letters for customers. You can create personalized letters using Access reports or by integrating Access with Microsoft Word for a mail merge. I cover how to do both methods thoroughly in my Access Expert Level 5, Word 201, and Access Expert Level 19 classes. For a quicker introduction, my Letter Writer video offers a condensed walkthrough.

When it comes to distributing your database to multiple users in an organization, many wonder if there is an affordable or free version of Access. While there is no cheap full version, there is a completely free runtime edition for users who just need to use the database and not make design changes. This means only the designer needs the full version of Access, while everyone else can use the runtime edition at no cost. I explain how to obtain and use the runtime edition in a separate video.

Dealing with customers who have multiple phone numbers, emails, or addresses is another common scenario. If you need only two or three fields, separate columns are fine (for example, home phone, work phone, cell phone). If you might need more than three, then it is better to create a related table to store multiple values, like multiple children or orders. This way, you avoid bad database design, such as having 20 product fields for a single order, which is not best practice. Relationships and proper table structure are explained in Access Expert Level 1 and reviewed in Beginner Level 2.

Importing data from Excel is an activity many find challenging, especially if their spreadsheets are not well-organized. While Access makes it easy to import when the data is tidy, you may run into problems if things are inconsistent. I give this topic a full treatment in Access Expert Level 20, and I guide you through both the easy cases and troubleshooting the difficult ones.

If you have multiple types of customers, such as sales, service, and warranty-only, the correct approach is to use a field in the customer table indicating the type, rather than having three separate tables. If a customer might fall into multiple categories, you will want a many-to-many relationship, which I explain in Access Expert Level 7 and in my Many to Many video.

Database security is always a concern. If you want basic protection to prevent users from tampering with forms or tables, I have a Simple Security video. For more advanced needs, including user logins and audit logs, I offer a seven-hour Security Seminar. Depending on your security requirements, you can choose the approach that fits your organization.

With more people working remotely, I am often asked if Access can be used over the web. There is no web-based version of Access, but it is possible to run your database remotely using certain methods. I have a dedicated page and videos outlining current recommendations and what to avoid, like using Dropbox or OneDrive, since these services can corrupt your database if used for shared access.

Creating a menu system to make navigation easier in Access is absolutely possible. Forms can be used to build custom menus with labels and command buttons. I do not recommend Microsoft's built-in Navigation Forms or the older Switchboards, but instead, I teach you to build your own custom menu system. This is covered in Access Beginner Level 7 and in my Blank Database template resources.

Finally, regarding backups, all your work is stored in a single ACCDB file. Regularly back up this file to protect your database. My backup video explains the process in detail.

These cover the most common questions from students in Access Beginner Level 1. If you have any additional questions, you are welcome to post them on my website in the comment area beneath these videos where I regularly engage with students.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Creating a customer list form with clickable records
Using continuous forms to select and open records
Using double-click events to open customer records
How to use Shift F2 (Zoom) on laptops with function keys
Remapping function keys on laptops for Access use
Zooming options in Access forms, tables, and queries
Changing datasheet font size in tables
Proper way to delete tables in Access
Using autonumber as a primary key alongside custom IDs
Autonumbers and handling gaps after deletions
Using counter variables for sequential numbering
Writing and sending letters to customers from Access
Mail merge with Access data and Microsoft Word
Using the free Access Runtime edition for end users
Designing tables for multiple phone numbers or addresses
When to use related tables for repeating data
Proper Excel data import into Access
Classifying customers with category fields vs separate tables
Handling customers with multiple classifications (many-to-many)
Database security basics and user access restriction
Making a custom menu system with forms and buttons
Backing up your Access database file

Article

If you are new to Microsoft Access or just looking for some answers to common questions, you are in the right place. I have taught Microsoft Access for over 20 years and have seen many of the same questions and issues come up. Here, I will guide you through some of the most frequent topics and solutions, with practical advice and clear examples. This guide will help you get started with Access and avoid common pitfalls.

One of the most frequent requests is how to create a form that lists all your customers, allowing you to click on a customer to open their detailed record in a separate form. To accomplish this, create a continuous form that displays your customer list. Add a button or set up a double-click event on each row that opens the customer form filtered to the selected record. You can use VBA for this. For example, to open the customer form and go to the selected record, you can use the following code in your button's On Click event:

DoCmd.OpenForm "CustomerForm", , , "CustomerID = " & Me.CustomerID

Replace "CustomerForm" with the name of your form and "CustomerID" with your primary key field. Alternatively, you can set up a double-click event on the form's detail section with similar code.

Laptop users often encounter issues with function keys. If pressing Shift+F2 does not open the Zoom window, it is likely because most laptops require you to also hold down the Fn (function) key. So you may need Shift+Fn+F2 instead of just Shift+F2. Each laptop has different function key behavior, and you can usually change this in your laptop's BIOS or system settings if you want to use standard function key actions.

A question that comes up frequently is whether you can zoom in or out on forms, tables, or queries in Access like you can in Excel or Word. The short answer is no. Only reports allow you to zoom in or out. In forms, tables, and queries, there is no zoom slider or shortcut. To make things easier to read, you can design your forms with larger fonts or fields, but you cannot zoom dynamically. In datasheet views (tables and queries), you can increase the font size globally by going to File, then Options, and adjusting the Datasheet font size. However, this does not affect forms.

If you want to delete a table, just right-click on the table in the navigation pane and choose Delete. Be careful, though. Once you delete a table or other object in Access, it is gone permanently with no undo. Always back up your database regularly before making major changes.

One area that causes confusion is planning your primary keys when you already have an external ID system, such as student numbers, customer IDs, or product codes from another system. Even if you already have unique numbers, you should still use an AutoNumber as the primary key in your Access tables. Keep your external numbers in their own fields but rely on the AutoNumber ID for setting up relationships. This approach makes building and maintaining your database much easier. The AutoNumber fields are used internally by Access for relationships and are not intended for users to see or manage.

After deleting records, some users worry about gaps in their AutoNumber fields. For example, if you delete customer records with ID numbers 5 and 7, those numbers will not be reused. This is natural and expected. Do not worry about the missing numbers; AutoNumbers are intended only for relationships, not as meaningful numbers for people.

If you need a simple counter for numbers to always increase by one with no skips, such as an internal order number for each customer, you will need a bit of programming. This involves writing code that calculates the next available number for the customer and assigns it to a field in your order table.

Sending letters from your Access database is absolutely possible. You can design a letter as a report in Access and print or export it for each customer. Alternatively, you can use Microsoft Word mail merge features and select your Access database as the data source. Both options allow you to create form letters personalized with customer names and other information.

For organizations, purchasing multiple copies of Access can be expensive. Fortunately, Microsoft offers a free runtime edition of Access for users who only need to enter and edit data without making structural changes. Only the developer needs the full version of Access; everyone else can use the runtime version to run forms and reports.

When your data requires storing multiple pieces of the same information, such as a customer with multiple phone numbers or addresses, it depends on how many you plan to keep. If you only need to store two or three items, like home phone, work phone, and cell phone, it is acceptable to make three fields. If you might have more, or an unknown quantity (such as a list of email addresses), you should design a separate related table to hold those values, linked by the primary key. The same goes for orders; do not create OrderItem1, OrderItem2, and so on in one table. Instead, have an Orders table and a related OrderDetails table to hold line items.

If you already have data in Excel and want to bring it into Access, you can use the import feature. Go to External Data and select Excel. Make sure your Excel data is organized with each column containing only one type of data, and each column consistently labeled. Importing works best when your data is structured properly. If you run into issues, check for inconsistencies or mixed data types in your columns.

For customer classification, such as sales, service, or warranty customers, do not create separate tables for each category. Instead, add a field to your customer table to track the type. If customers can belong to more than one category, use a separate table to record the combinations, creating a many-to-many relationship between customers and categories.

Database security is important, especially if multiple people use your Access database. To prevent users from making design changes, you can use the Access Runtime and remove design permissions. For more advanced security, you can create user logons and audit tracking features. There are various strategies depending on how secure you need your system to be, from simple hiding of navigation and locking forms, to full audit logs and user-level permissions.

Running Access databases over the web or for remote users is a common need. There is no fully web-based version of Access. However, you can set up remote desktop access or use third-party hosting services to allow users to connect and use the Access application remotely. Avoid sharing your database file using cloud file-sharing tools like Dropbox or OneDrive, as this can corrupt your database. Always consult up-to-date resources for the latest remote options.

Creating a menu system in Access helps users find what they need without digging through the navigation pane. The easiest method is to create a main menu form with buttons that open other forms, reports, or processes. You can design these buttons yourself for full control. While Access offers Navigation Forms, building your own custom menu gives you more flexibility and avoids limitations of the built-in options.

Finally, backing up your Access database is simple. All your tables, queries, forms, reports, and data are stored in a single file with an .ACCDB extension. To back up your database, just make a copy of this file and store it in a safe location. It is always a good idea to make regular backups, especially before making significant changes.

If you have further questions about Microsoft Access as you learn, keep practicing and do not hesitate to look for answers in communities or help forums. The key to mastering Access is understanding its structure and using best practices for data organization and relationships. With these tips, you will avoid common mistakes and build a solid foundation for your database projects.