When creating a pivot table form, why does the wizard fail to open, probably because the table source is opened by someone else on an exclusive basis. How to solve it specifically

Access Database Programming Basic Requirements 1. basic knowledge of database systems. 2. a basic understanding of object-oriented concepts. 3. master the basic principles of relational databases. 4. master database program design methodology. 5. be able to use Access to build a small database application system. Examination content I. Database basics 1. Basic concepts: database, data model, database management system, classes and objects, events. 2. 2. Relational database basic concepts: relational model (entity integrity, referential integrity, user-defined integrity), relational schema, relationships, tuples, attributes, fields, domains, values, master keywords, etc.. 3. Basic concepts of relational operations: selection operations, projection operations, join operations. 4. SQL basic commands: query commands, operation commands. 5. 5. Access system introduction: (1) the basic characteristics of the Access system. (2) Basic objects: tables, queries, forms, reports, pages, macros, modules. Second, the basic operation of the database and table 1. Create a database: (1) create an empty database. (2) using the wizard to create a database. 2. Table creation: (1) Create the table structure: using the wizard, using the table designer, using the data table. (2) Setting field attributes. (3) Inputting data: directly inputting data, getting external data. (3) Establishment and modification of inter-table relationship: (1) The concept of inter-table relationship: one-to-one, one-to-many. (2) Establishing inter-table relationships. (3) Setting up referential integrity. (4) Table maintenance: (1) modify the table structure: add fields, modify fields, delete fields, reset the main keywords. (2) Edit table content: add records, modify records, delete records, copy records. (3) Adjust the table appearance. 5. Other operations of the table: (1) Find data. (2) Replace data. (3) Sort records. (4) Filter records. Third, the basic operation of the query 1. query classification: (1) select the query. (2) parameter query. (3) cross * table query. (4) operation query. (5) SQL query. 2. query criteria: (1) operators. (2) Functions. (3) Expressions. 3. Creating Queries: (1) Using the wizard to create a query. (2) Creating Queries with the Designer. (3) Calculate in a query. 4. Manipulate the created query: (1) Run the created query. (2) Edit the fields in the query. (3) Edit the data source in the query. (4) Sort the results of the query. Fourth, the basic operation of the form 1. form classification: (1) columnar form. (2) tabular forms. (3) main/sub forms. (4) data table forms. (5) Chart Forms. (6) Pivot Table Forms. 2. 2. Create Forms: (1) Use the wizard to create forms. (2) using the designer to create forms: the meaning and types of controls, add and modify controls in the form, set the common properties of controls. V. The basic operation of the report 1. report classification: (1) columnar reports; (2) tabular reports. (3) chart reports. (4) labeled reports. 2. Use the wizard to create reports. 3. 3. Edit reports using the designer. 4. Calculations and summaries in the report. Sixth, the basic operation of the page 1. The concept of data access pages. 2. Create data access pages: (1) automatically create a data access page. (2) using the wizard data access page. VII. Macro 1. The basic concept of macro. 2. 2. The basic operation of the macro: (1) create a macro: create a macro, create a macro group. (2) Run the macro. (3) use conditions in the macro. (4) Setting macro operation parameters. (5) Common macro operations. VIII. Module 1. The basic concept of module: (1) Class module. (2) Standard modules. (3) Convert macros to modules. 2. Creating Modules: (1) Create VBA modules: add procedures to the module and execute macros in the module. (2) Writing event procedures: keyboard events, mouse events, window events, operation events and other events. 3. Calling and parameter passing. 4. Fundamentals of VBA Programming: (1) Basic concepts of object oriented programming. (2) VBA Programming Environment: Entering VBE, VBE Interface. (3) VBA programming basics: constants, variables, expressions. (4) VBA program flow control: sequence control, selection control, loop control. (5) Debugging of VBA programs: setting breakpoints, single-step tracing, setting monitoring points. Examination 1. Written examination: 120 minutes, out of 100 points, including 30 points in the section of basic knowledge of public ****. 2. on-line operation: 60 minutes, out of 100 points. (1) Basic operation. (2) Simple application. (2) Simple application. (3) Comprehensive application